Solved

Port V1.2

Posted on 2016-07-25
4
33 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 51

Accepted Solution

by:
Bill Prew earned 500 total points
Comment Utility
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
Comment Utility
Awesome Man.....Some Time I Confuse My Self & Make Task More Difficult ....and forgot obvious.

Thanks
0
 
LVL 8

Author Closing Comment

by:itjockey
Comment Utility
Simply Perfect....
0
 
LVL 51

Expert Comment

by:Bill Prew
Comment Utility
Thanks, glad that was helpful.

~bp
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now