Excel - macro to create multiple sheets [Solved/Closed]

Report
Posts
3
Registration date
Thursday May 26, 2016
Status
Member
Last seen
May 31, 2016
-
vcoolio
Posts
1253
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 15, 2020
-
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.

3 replies

Posts
1253
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 15, 2020
207
Hello Maria,

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

Cheerio,
vcoolio.
Hi Vcoolio, could I ask you for some help in integrating macros for some work?
Posts
1253
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 15, 2020
207
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.
Posts
1253
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 15, 2020
207
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.
Mariaca113
Posts
3
Registration date
Thursday May 26, 2016
Status
Member
Last seen
May 31, 2016

thanks a lot vcoolio! it works now :)