$$Excel-Macros$$ Re: automation of transfer of data from several sheets to one sheet

Thank you once again -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ Re: automation of transfer of data from several sheets to one sheet

Hi Mr Pascal Thank you very much for you help, but there is slightly moving the row below the destination location, please see the attachment . -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Re: automation of transfer of data from several sheets to one sheet

this needs to be changed: Range(ActiveCell, ActiveCell.End(xlUp).Offset(1, 0)).Value = SN and the macro needs to be changed to accomodate the change above, Sub CopyAll() Application.ScreenUpdating = False Dim cnt As Long Dim r As Range For i = 1 To Sheets.Count - 1 Sheets(i).Select SN =

$$Excel-Macros$$ Re: automation of transfer of data from several sheets to one sheet

HI FRIENDS AND BROTHERS PLEASE DO ME A FAVOR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread