Solved

Port V1.2

Posted on 2016-07-25
4
48 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:Naresh Patel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 56

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:Naresh Patel
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:Naresh Patel
ID: 41729800
Simply Perfect....
0
 
LVL 56

Expert Comment

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

~bp
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Use Windows Task Scheduler to print a Word document weekly so your printer ink won't dry out.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

626 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