How to Link to the next blank row after the last entry in a column?

J

JagBbeach

Cell BM6 Sheet1, has a formula that gives me a numeric total.

The total belongs in Column D1 Sheet2 after the last entry, and there
will be cells that will remain blank in that column before the last
entry.

Sheet1 is a work sheet, which will be saved with a new file name at the
end of the month after the totals have been sent to Sheet2. Sheet2 is a
permanent, ongoing record.

The numbers on original Sheet1 will then be erased and the worksheet
reused for the new month.

:confused: How do I get the values into the appropriate row of Sheet2
and have them remain there when I reuse the worksheet?

Many Thanks, JagBbeach.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need To Compare Two Worksheets, Update Current Records And Insert New 1
Inserting Columns Based on List 0
What formula do I use to show the last cell with text in a colum 3
calculate last 4 data points in a column (with sometimes blank rows) 7
Formula and values stay with row/cell after sort 0
Select all rows till last row with value in Column A and CopyPaste 7
Return last row no. of column with blanks at top 7
Help Automatically Populating A Summary sheet 1

Top