automating data across cells/sheets
 

Hello all

I have another question and hope someone will be able to help.

What i need to do is have data that i enter in a cell automatically transpose this data to other cells within the week sheet and across to other sheets within in the work book.

i have used the concatenate formula but believe there must be other ways.


Thanks all

Reppy