Excel - macro to create multiple sheetsSolved/Closed

Question

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.

vcoolio · Answer

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.

vcoolio · Answer

Hello Maria,

Excellent! Come back any time should you need any further assistance.

Cheerio,
vcoolio.

vcoolio · Answer

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.

Excel - macro to create multiple sheets

3 responses

Similar discussions

Subscribe To Our Newsletter!