Macro to copy data from one sht to another

[dobracik]

Hi all,

I was wondering, whethe here is anybody who could help me with small code correction.
I have a data ( Position change sheet) rom where I need to copy always data to ( Alltogether sheet).

=> data should be copy pasted as values and formats to "Alltogether" sheet
=> Data shold be copy pasted until last cell filled in "Column A" sheet Position change

Here is the code:

Please Login or Register  to view this content.

Can anybody help? Attaching the sample workbook with code in it.

Thanks,
andy

[jindon]

=> data should be copy pasted as values and formats to "Alltogether" sheet
=> Data shold be copy pasted until last cell filled in "Column A" sheet Position change

try

Please Login or Register  to view this content.

[dobracik]

Thank you so much, it's working :-)

Just is it possible to amend the code to copy data from sheet Position change untul last filled column A? To not copy all the formulas below?

Thank you :-)

[jindon]

If you have formula in column A then change to

Please Login or Register  to view this content.