Hello,
i need a help in paste a range from sheet to another one in a different workbook
i have a workbook called "Main" want to copy a schedule range from a sheet called "Preview" in columns ("A:F") to another workbook called "Database" in an active sheet called "Adherence"
but i need to copy this range to the last row and paste it to the last row of another worksheet
due to the data range "Preview" sheet is variable i need to copy this range till the last indexed row
eg: let's say if i move the data for first time from ("A5:F10") i need it paste in (Adherence) sheet in range ("A2:F7"), the second migration if the range will be from ("A5:F20") in the "Preview" sheet, this data will paste after the last index cell in (Adherence) sheet = will pasted in range ("A8:F23") etc...
to use this migrated data in a pivot table in one range
thanks a lot,
i need a help in paste a range from sheet to another one in a different workbook
i have a workbook called "Main" want to copy a schedule range from a sheet called "Preview" in columns ("A:F") to another workbook called "Database" in an active sheet called "Adherence"
but i need to copy this range to the last row and paste it to the last row of another worksheet
due to the data range "Preview" sheet is variable i need to copy this range till the last indexed row
eg: let's say if i move the data for first time from ("A5:F10") i need it paste in (Adherence) sheet in range ("A2:F7"), the second migration if the range will be from ("A5:F20") in the "Preview" sheet, this data will paste after the last index cell in (Adherence) sheet = will pasted in range ("A8:F23") etc...
to use this migrated data in a pivot table in one range
thanks a lot,