Using GOTO to first empty cell in a macro

[cullism]

I am planning to write a macro which joins two worksheets. It will first open Worksheet 1 then go to the first emty cell. Next it will open Worksheet 2 and copy its contents to the first emty cell in Worksheet 2. This is a very basic descriprion of a more complex macro. My question is as follows: if I add rows to worksheet 1 will the macro copy worksheet 2 to the first empty cell in Worksheet 1 or will it always go to the cell it found when I first ran the macro? If the latter it would mean that the new rows in Worksheet 1 would be overwritten.

[TMS]

If you record a macro, it will always do the same thing with hard coded cells and ranges. If you write a macro yourself, you can make it more flexible and generic.

Finding the last row of data or the next available cell are common tasks that are done all the time.

[cullism]

Although I have been using Excel for thirty years or more I have never written a macro, instead I record them. Rather than spending hour teaching myself to write a macro I have come up with a different method of achieving the same result. The macro I record will open the first worksheet (Worksheet 1), find the last cell containing data, page down several hundred rows then save the result as a new worksheet (Worksheet 1a). It will then open the second worksheet (Worksheet 2), highlight all the cells and copy them to the bottom of Worksheet 1a before sorting the combined data and saving the result as Worksheet 3. It will be more complicated than this as I also want to add data from yet another worksheet which has the same data but arranged in different order.

[TMS]

This code will copy the data from one worksheet (2) to the bottom of the data on another worksheet (1). In this example, both worksheets are in the same workbook with the code. An example is given for opening the second workbook.

Please Login or Register  to view this content.