I have a spreadsheet with 9 identical tabs. The only thing differentiating the tabs is the tab name.
I am looking for some help with a macrto that will insert a new col in A and populate the col with the tab name all the way to the end of the data and then move to tab 2 and do the same until all 9 tabs are done.
I have tried a couple of crude methods but this is above my Macro experience level.
Thank you in advance.
Ken
Last edited by kcleere; 09-05-2012 at 12:21 PM.
hi there Ken, i thought you were the TS in the other thread you posted a question. sorry~ here's a similar one that can help you:
Please Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
You are really good. Your solution in the other thread worked fine but I realized what I was doing ended up exceeding the row limit for Excel. So even though your solution didn't work there, I can use that code elsewhere.
I just now tried this new code as well and it works like a charm. Thank you. I'm going to try and mark this post solved if I can figure out how.
Thank you again.
The same thing only different.
Please Login or Register to view this content.
David
(*) Reputation points appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks