complex cell referencing macro

[russthebarber]

Any ideas how to do this? - I have two sheets in a spreadsheet called "stockcheck" and "stock" and I want to set up an 'add' button that adds a new row to one of the sheets. This row will be pulling information from various places, however. This is what should be performed by the macro:

1. Cell below last populated cell in column A of "stocksheet" gets populated by contents of last populated cell in column G of "stock".
2. Cell below last populated cell in column B of "stocksheet" gets populated by contents of last populated cell in column J of "stock".
3. Cell below last populated cell in column C of "stocksheet" gets populated by contents of last populated cell in column K of "stock".
4. Cell below last populated cell in column D of "stocksheet" gets populated by contents of last populated cell in column S of "stock".
5. Cell below last populated cell in column H of "stocksheet" gets populated by contents of last populated cell in column Y of "stock".

 

[My Aswer Is This]

Will the last row with data of all these columns normally be same? I know the row # will always change but will lastrow with data in column A normally be the same as last row with data in column B