Solved

Port V1.2

Posted on 2016-07-25
4
41 Views
Last Modified: 2016-07-26
I had this question after viewing Port v1.
Hi Experts,

Will any one please add few lines in existing Code Module NewTabs...which print type Broker or Client in Cell G1.... i.e. new Sheet created from column A Then Print "Broker" in Cell G1 and if New Sheet Created From column B Then Print "Client" in Cell G1. whole explanation is given in above link.Assuming Sheet BigB and MySelf is not there between sheet Start to Sheet EndSo after running macro it has been created.If Sheet Created from column A Name then Print Broker in Cell G1if sheet created from column B then print client in Cell G1
See attched

Thanks
Portfolio-V05.xlsm
0
Comment
Question by:itjockey
  • 2
  • 2
4 Comments
 
LVL 53

Accepted Solution

by:
Bill Prew earned 500 total points
ID: 41729427
I think you can get what you want just by changing the template shhets with no change to the VBA macro.  Take a look at the updated workbook attached, I think this was what you were looking for.

~bp
Portfolio-V06.xlsm
0
 
LVL 8

Author Comment

by:itjockey
ID: 41729797
Awesome Man.....Some Time I Confuse My Self & Make Task More Difficult ....and forgot obvious.

Thanks
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 41729800
Simply Perfect....
0
 
LVL 53

Expert Comment

by:Bill Prew
ID: 41729802
Thanks, glad that was helpful.

~bp
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
.Range Set 25 78
Excel Conditional Statements 11 39
VBA taking too long 5 20
How to transform one row line like this in excel table 2010? 8 21
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question