Hi all,

I have an excel sheet with many worksheets with values, every day i got this sheet with diffirent values but in the same locations (example: A2, D5, W4....).

Every day i'm copy & past some locations with values & put it to new spreadsheet & save it to new sheet. i'm tierd to do this every day

Is there any way to do this automaticlly??

in attachment you can find the origenal spreadsheet with values & the final spreadsheet that i did it.


plz my friends help me on this :(


Thanks.

The next time you copy and paste the data, record your actions as a macro and then in future just run the macro.
smiler44