Solved

Port V1.2

Posted on 2016-07-25
4
44 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 54

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 54

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

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

685 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