Improve company productivity with a Business Account.Sign Up

x
?
Solved

Port V1.2

Posted on 2016-07-25
4
Medium Priority
?
66 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
  • 2
  • 2
4 Comments
 
LVL 61

Accepted Solution

by:
Bill Prew earned 2000 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 61

Expert Comment

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

~bp
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Implementing simple internal controls in the Microsoft Access application.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

608 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