transfer DATA FROM SHEET 2 TO SHEET1 AUTOMATICALLY

[DAVIDZZZ]

HI ALL,
I AM LOOKING FOR A WAY TO TRANSFER DATA FROM SHEET2 TO SHEET1 AUTOMATICALLY. I ONLY NEED TO TRANSFER A24:D60 FROM SHEET 2 TO SHEET1 A24:D60. HOW WILL i DO IT WITHOUT LOOSING THE FORMATTING AND DATA?
ATTACHED IS THE SPREADSHEET FOR REFERENCE.
I TRIED USING =+'sheet2'!A24, but it will generate 0's wherever blank in sheet2 and don't copy the formatting. can anyone help?

[Green Crocodile]

Why not just select A24:D60 on sheet2 and paste it to sheet1?

If the data changes often on sheet two... After pasting to sheet1 (which should also transfer the formatting) you can then change the cells to reference sheet such ='sheet2'!A24.

[DAVIDZZZ]

Yes, data will change often, like there will be changes in the values, sorting order and even some rows will be deleted. So I was looking for a way to copy these data automatically to my results sheet which will be a great achievement.

[oeldere]

Please Login or Register  to view this content.

Please do not use UPPERCASE, it looks like shouting.

For that you will need VBA, it can't be done in Excel with formula).

[DAVIDZZZ]

noted.. But any solutions that can help me?

[oeldere]

Did you consider using pivot table to analyse the data?

[DAVIDZZZ]

yes, I did. It will not work if there is a change in the sorting order

[oeldere]

Please Login or Register  to view this content.

explain better, since I think that is incorrect.

Edit:

Please do NOT pm me, it is a public forum, so you get better help adding the question on the forum.

[gaixixon]

Is it what you want?

[DAVIDZZZ]

yes, this is what i was looking for. Thanks Gaixixon, but may I ask how did you do this? I didn't get it really
Thanks again