Report

Excel - macro to create multiple sheets [Solved]

Ask a question Mariaca113 3Posts Thursday May 26, 2016Registration date May 31, 2016 Last seen - Last answered on May 31, 2016 05:24AM
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.
See more 
Helpful
+0
moins plus
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 3Posts Thursday May 26, 2016Registration date May 31, 2016 Last seen - May 31, 2016 04:18AM
thanks a lot vcoolio! it works now :)
Reply
Add comment
Helpful
+0
moins plus
Hello Maria,

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

Cheerio,
vcoolio.
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!