Create new sheet and copy data automatically using VB

**exchangejames** · 05-28-2012, 05:02 AM

Hi Folks,

I am looking to have a single input sheet where my order guys can update and this inturn creates a new tab with all the data transferred across.

I then want to extract this data and tabs to another sheet and this I also need help with.

I can use the following script to create the new tab with the name transferred from the cell, but just cant get find how to do the data copy from that specific row.

Please Login or Register  to view this content.

All help is very much appreciated.

**arlu1201** · 05-28-2012, 05:08 AM

Your file is protected, am not able to open it.

**exchangejames** · 05-28-2012, 05:14 AM

sorry password is avaya01 forgot to save without this!

**jraj1106** · 05-28-2012, 05:38 AM

Hi

You want to create new sheets based on the order number... ie. in this case you want 36 sheets to be created with the respective data... right?

**exchangejames** · 05-28-2012, 05:53 AM

Thanks for your reply,

I am looking to create a new tab for each order that is created and logged. I have allowed for 500 rows in the original code, I feel this should be far more than I need ever. I plan on starting a new sheet every month to keep the file size small and easily manageable, and have a single master spreadsheet to allow me to reference every order on a single sheet.

thanks,
James

**jraj1106** · 05-28-2012, 05:59 AM

Try this. I m not sure if this is what you wanted...

order tracker help file.xlsm

**exchangejames** · 05-28-2012, 06:26 AM

Hi Jraj1106,

Thanks for this. Do I have to open it any particular way or do anything to make this automated? It seems to not do anything, but this is probably my lack of excel knowledge

thanks,

**jraj1106** · 05-28-2012, 06:32 AM

You just have to run the macro. I have only 10 orders. Just to test...

order tracker help file.xlsm

**exchangejames** · 05-28-2012, 06:50 AM

Yip my understanding of Excel!! It works great, I get a 'run time error 28' Out of stack space if I add another row and run the macro again. It is fine if I delete all the tabs after running the data, but this will interfere with the master spreadsheet that I copy the data from. Is there a way to stop the run time error.