im trying to have a popup box to add data in a column. but i want it to add the data under the last row that has data.
example
Date...........quantity A.............quantity B
6/12...............1
6/13..........................................2
(dots used to show columns)
i want to run a macro that will bring up a popup box to add data. i want that data to go under the last row with data.
I only know a little about macros but i started a code to add input
i know i need to put something in the range part but i don't know how to make the range put the value under the last row of data in column a for the date.
Also what do i add to the code to have the same input box and have another entry for the change in quantity A and another for change in quantity B all added in the same row?
using the example above, i would want to insert data under the last row (6/13..............................2) and have it add a date under column A, and quantity under columns B and C
thanks for any help
JED
Bookmarks