Excel - macro to create multiple sheets

Solved/Closed
Mariaca113 Posts 2 Registration date Thursday May 26, 2016 Status Member Last seen May 31, 2016 - May 27, 2016 at 04:46 AM
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 22, 2024 - Apr 14, 2017 at 05:54 PM
Hello,
I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1.

This is for credit info.

The main spreadsheet has all the offices in column O with credit notes (name, invoice number etc).
I need to spread this info by office into a new spreadsheet.

I created a macro to sort the sheets but it is not working well. It would be nice if this macro automatically ran the information and updates the individual offices spreadsheets.

Thanks.
Related:

3 responses

vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 22, 2024 262
May 31, 2016 at 05:24 AM
Hello Maria,

Excellent! Come back any time should you need any further assistance.

Cheerio,
vcoolio.
0
Hi Vcoolio, could I ask you for some help in integrating macros for some work?
0
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 22, 2024 262
Apr 14, 2017 at 05:54 PM
Hello S,
I'm away from home and my PC at the moment and will be for awhile yet. I can't do this on my phone successfully but in the meantime start a new thread fully describing/explaining your query.
Thanks S.
Cheerio,
vcoolio.
0
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 22, 2024 262
May 27, 2016 at 09:29 AM
Hello Maria,

Please upload a sample of your work book to a free file sharing site such as DropBox, ge.tt or SpeedyShare then post the link to your file back here. Be careful with any sensitive data. Pleae also post the code that you have already created. We'll see what we can do from there.

In the meantime, have a look my test work book at the following link:-

https://www.dropbox.com/s/ppe9ukewz9po3e1/Teke%20%283%29.xlsm?dl=0

The code attached to the work book is one that I wrote for another Poster a few months ago and I believe that it may work for you also as the query was similar to yours.

Cheerio,
vcoolio.
-1
Mariaca113 Posts 2 Registration date Thursday May 26, 2016 Status Member Last seen May 31, 2016
May 31, 2016 at 04:18 AM
thanks a lot vcoolio! it works now :)
0