Macro for seperating an identidied number on to a seperate page
I want to create a macro that allows me to seperate data from a spreadsheet that is in a pre-exsisting format.
I want to take column A which identifies the subject name with a numerical value or "API Number" and seperate those rows related to a specific "API" onto a seperate page for each API. I just cant make this thing work.
Does anyone have the expereince to help me?
Hi, sharahoff,
maybe you can have a look at this code and give it a try.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
It would help if you could post an example workbook which shows the format of the data that you have and how you would want it to be.
Pete
Holger thanks so much that is great! I think I can make it work with a few tweaks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks