Copying unprotected data from one sheet of workbook to another workbook

**rushabh bhansali** · 06-28-2013, 06:58 AM

Hi
I have to a workbook with 31 sheets
I wish to paste the unprotected data from each sheet to another workbook in the same particular named sheet and same cell as the previous work book

I cannot use the copy sheet in excel as the formats of the sheets are different giving me different out put through formulae

I wish to delete the previous sheet once data is trasfered
please assist me with a macro to do so.

**JBeaucaire** · 06-30-2013, 04:06 AM

So, you have two identically constructed workbooks.

The old one has some data (not formulas) in certain unlocked cells on each of 31 separate sheets.

In the new wb you would like that same data (not formulas) to be transferred to the sheets of the same name and into the same cell addresses, on all 31 sheets.

Is this correct?

**rushabh bhansali** · 07-02-2013, 06:18 AM

I have attached excel sheet for your reference.

I need to copy data from Dinning Hall May 13 to Dinning Hall format Ammd 27.06.2013 for all days.

There has been a change in certain formulas. Hence no folmulaes (locked cell data ) has to be trans fed only data in unprotected cell has to be transferred to the new ammeded format workbook.
A new column has been added in AJ27called Total Cups as compared to the previous sheet where in AJ 27 has discount.

Hence the discount appearing in AJ27:AJ39 should appear in AK27:AK39 rest all data in unprotected cell should be transferred in ditto cells in the new work book.

Your quick assistance will be greatly appreciated as I have a presentation and have been loosing a lot of time trying to copy data manually for a quarter

Thanking you