Multiple tabs created

[gz3s36]

When I download a report from another system I use it does so by limiting the number of rows per tab (50). Therefore I get it with 11 tabs. Is there a way to add tabs 2-11 to tab 1? Or add all 11 to a new tab?

[BadlySpelledBuoy]

You could run a simple VBA script on the file to combine all sheets into sheet 1.

Would that be of interest?

BSB

[gz3s36]

Yes It would. I'll switch it to xslm and attach a file.

[gz3s36]

Here is the file I get from Maximo.

[BadlySpelledBuoy]

In the attached I've linked the sub below to a button on sheet 1. When you click it data from all sheets will be consolidated to sheet 1.

Please Login or Register  to view this content.

You can store the sub in a Personal.xlsb and run it from there so long as the newly downloaded data is the active workbook at the time.

BSB

[gz3s36]

That was excellent. Worked exactly as I needed. Thank you.

[BadlySpelledBuoy]

No problem at all. Happy to help

Thanks for the feedback.

BSB