Macro To Record Data Into Next Available Row

pwebley

Board Regular
Joined
Mar 2, 2011
Messages
69
I want to create workbook that records sales. I would like for the macro that I create take to cut the number of units sold and paste it onto another spreadsheet within the next available row. The spreadsheet containing the number of units sold is called "Dashboard" and the spreadsheet I want it cut and pasted to is "Inventory." How might I do this? Any help will be appreciated.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
so where on the dashboard would the "sold" indicator be shown and how?
 

pwebley

Board Regular
Joined
Mar 2, 2011
Messages
69
At this point I am not sure. As long as I can put it in a convenient location that is all that really matters.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,042
Messages
5,526,420
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top