How to copy automatically from sheetx to sheet1
One way:
B2: =INDEX(Sheet2!E:E, COUNTA(Sheet2!E:E))
assuming no blank rows in Sheet2!E:E (adjust the count as necessary if
there are blanks, e.g.:
=INDEX(Sheet2!E:E, COUNTA(Sheet2!E:E)+3)
if 3 blank rows.
In article om,
Macbet wrote:
Every day I have to write data to different worksheets.
So there is written as example in
sheet2 E80 value = 40.00
sheet3 E34 value = 25.50
sheet4 E78 value = 140.75
I would like to have this data automatically copied to
sheet1
Columns B2 = sheet2 E80
Columns B3 = sheet3 E34
Columns B4 = sheet4 E78
By the next daily entry the row will increase
And should copy
Columns B2 = sheet2 E81
Columns B3 = sheet3 E35
Columns B4 = sheet4 E79
Has somebody an idea, how to do this with excel?
Thanks in advance
macbet
|