russthebarber
New Member
- Joined
- Oct 4, 2016
- Messages
- 3
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".
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".