Copy data from a sheet to another automatically

Hello gents,
I would understand who to copy the data automatically, from a sheet to another.
In the enclosed example, on EXP sheet we have some data, i would like that this data goes automatically in the sheet RESUME and anytime i will data in the EXP sheet, for instance adding it on row 9-10-11 etc.
, the data is created automatically also in the sheet resume on the first available row. Is it possible?

Hope i was clear.
Thank you
Best Regards,
Roberto

I presume you will have similar headings, so you can put this formula in A3 of the Resume sheet:

=Exp!A3&""

Then put this formula in B3:

=IF($A3="","",Exp!B3)

and copy across into C3:D3

Format those 4 cells how you would like to see them (you can use the Format Painter icon to copy the format from row 3 of the Exp sheet), then copy the formulae down as far as you need them.

Hope this helps.

Pete

Could you please put it into the example file? I have italian excel and i get error message pasting the formula.
Thank you,
Roberto

Okay, here it is. You probably have to use semicolons ( ; ) instead of commas ( , ), and of course you need to translate IF to the Italian equivalent. It is not clear that you are from Italy, though, as your profile gives your location as "1905" - please update so that we'll know in future.

Pete

Thank you very much, got it, i did not get the use of "", it worked perfectly.
Now is becoming a bit harder, supposing EXP is a monthly sheet, at some point the expenses of EXPApril will end and we will have EXPMay, is it possible that the data of this expenses will fill the first available row after the last one of EXPApril, of course i can, after April, add into the following row the same code adapted you teached me, i am just wondering if it is possible to do it automaticlaly?
Thank you,
Roberto

It becomes a bit more complicated if you want to gather data from multiple sheets, but it can be done. I'm just about to have a meal break, so I'll get back to you later.

Pete

Perfect, thank you.
Roberto