I would need a macro that loops through column (eg. "D") in Sheet1, and creates new sheets (same workbook) and names them after each value in column D. Values might be repeating so once sheet name exists it doesn't do anything.
Thank you.
Figured out adding unique sheets.
Now I would like to add on each added sheet specific first row (categories).
.....A......B..........C.......D........E.....
..car...engine...speed...cost.....total..
Any ideas?
Last edited by Tona; 11-10-2014 at 02:56 AM.
try this
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Something like this u r looking for...
Please Login or Register to view this content.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Please Login or Register to view this content.
Thank you for replies. Works well!
Actually I would need to copy from one sheet range A1:G6 and paste special (range contains formulas, conditional formatting,..) to all added sheets.
Sorry for confusion.
Try this attached file
Thank you for solution.
Would you be kind and explain the macro please.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks