Macro to select table data

**Justair07** · 03-12-2013, 09:51 AM

Hello,

I'm trying to create a macro and have had no success at all. I need the macro to select all data from all the tables on a worksheet (not including the headings). The tables are all kept seperate and are spread apart. I then need to copy and paste this data on a different worksheet in the first empty cell but I need the data all on top of each other. I attached a very simple example of the tables on sheet 1 and what i would like the macro to do on sheet 2. I've been working on this for a day now and have not even came close. Granted I am new to VBA but am getting very fustraded in my poor attempt to write my own code so i'm trying a differnt approach and starting over. I'm still trying to learn so if anyone can help me at all or even get me started it would be very appricated! I'm a quik learner i'm just completly lost on this one.

Thank you in advance to anyone willing to look at my problem...

Regards, Justair

**nilem** · 03-12-2013, 09:59 AM

Hi Justair07,
try this

Please Login or Register  to view this content.

**Justair07** · 03-12-2013, 10:09 AM

Perfect! You are a geinus! I have a lot to learn thank you for the help nilem!

**Justair07** · 03-12-2013, 10:31 AM

Do you know if it's possible to do a Special Paste so that way none of the formating or if i'm getting the value from a formula only the value will be pasted in sheet 2? Not any of the extra stuff.

**nilem** · 03-12-2013, 10:38 AM

try

Please Login or Register  to view this content.

**GeneralDisarray** · 03-12-2013, 10:42 AM

Please Login or Register  to view this content.

You can align the values to ignore the formatting. This seems to work (note, also added in a clearContents line to remove previous runs. If you run this on the sheet you already have used the macro on, remove the formatting from sheet2 before running this (otherwise it will remain in place even though the values are copied).

edit---
sorry, didn't see nilem's second reply