Struggling to create a macro that selects all the data on diff tabs....

[Weaselwithagun]

Hi folks,

Could someone explain to me (in as basic language as possible), how i'd go about creating a macro that does the same function on each tab, but where the amount of rows of data on each tab is different?

So on tab 1 i've got say 20 lines of data that i want to turn into a table, then on tab two i've got exactly same amount of columns and the data is in the same places etc there are just more rows. The way i've taught myself to make macros is to simply record the movements i'm making, but in this example that's no good

Could i go into the editor itself and write in to do the same function as done in the first tab, but ensuring that it takes all the data instead of stopping where the first tab's info did.

Does this make sense?

Thanks

[alansidman]

try this:

Please Login or Register  to view this content.

[KOKOSEK]

Hi

Record macro for 1st tab. Check this twice is it working as intended.
If difference is only with ROW quantity you can use variable which find out how many rows you need.

For ex.

Please Login or Register  to view this content.

var lastRow get last row with data in column A.

So, if you recorded macro and you will see something like:

Please Login or Register  to view this content.

it means on Sheet1 operation is done for 57 rows, then you can replace it with:

Please Login or Register  to view this content.

then, if Sheet2 or Sheet3 has more/less rows, operation will be applied to all non empty rows.

[Weaselwithagun]

Cheers - this sounds like exactly the sort of thing i was looking for

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Weaselwithagun]

I've had a go at adding the above VB text into the existing macro, but i've not grasped/misunderstood what & where it's supposed to go

This is possibly because i make several changes to the sheet during the macro on specific cells (i.e. change the top line, go to the bottom of the table and add a sum etc), so i can't really see a part of the code that says something like Range("A1:A57").select

If i upload my macro into this site, could someone take a look and let me know how this could be made to work?

Thanks