Hi All,
I have a code which lets me merge sheets courtesy a fellow forum member.
The below snippet of the code merges the sheets in a given workbook in case data in each sheet starts from row 1 and cell a1.
I modify it as per the scenario....if the data starts in row 3 then I modify Rows(1).copy to Rows(3).copy and [a1].CurrentRegion to [a3].CurrentRegion
Is it possible to have an inputbox which lets the user decide where the data starts by providing these inputs without having to modify the code?
Thanks!