Hi all
Struggling to get a solution here. Would be grateful for a kick start.
I receive periodic reports in a way shown in the first tab of the attached workbook. I need to build a Pivot Table of the information, so am trying to copy discrete data onto another sheet, shown in the secod tab.
I only want to copy the cells highlighted in yellow in the first tab and paste them in the manner shown in the second tab.
Could anybody help start me off?
Kind regards
almost finished writing your solution. Need another 15 minutes or so
If you like my contribution click the star icon!
Please Login or Register to view this content.
Last edited by AB33; 01-10-2013 at 06:36 AM.
This code maybe an idea:
Regards,Please Login or Register to view this content.
Antonio
Have a look at the attached solution. Hope it works for you.
PS. I have also taken the liberty of setting the correct cell formats in the target worksheet based on the cell formatting of the source worksheet.
WOW!!! Thanks so much guys!
I was just looking for a kick start, but you have all provided me with the full solution!
All three codes were different but all worked like a charm.
OllieB, thanks for all the rem statements. It will help me understand your code.
What a fantastic forum.
Thanks once again all for taking the time to help me.
hi
i have almost the same problem. see the example file. i have a list of merged tabs content. to process the data with a pivot table or other functions i need a structured list with specific cell values.
can anyone help with a vba code to get this job done?
thanks a lot for your support
meincontroller,
Welcome to the forum!
Please start your own thread as per forum's rule.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks