G
Guest
I have a workbook with numerous worksheets. Every worksheet is set up the
same with the same headers etc. and the last row of text (which varies each
day) is a sum total of the values in column F. What I want to do is use some
type of code to say to copy the last cell in column F in worksheet A and
place it in the Sheet titled "Summary" in cell C4. Then do the same for the
other documents in the Workbook, for example
Last populated Cell in Col F in WS A copy to cell C4 in Summary Document
Last populated Cell in Col F in WS B copy to cell C6 in Summary Document
Last populated Cell in Col F in WS C copy to cell C8 in Summary Document.
Last popluated Cell in Col F in WS D copy to cell C10 in Summary Document
Can this be done with VBA? Thanks for your help.
same with the same headers etc. and the last row of text (which varies each
day) is a sum total of the values in column F. What I want to do is use some
type of code to say to copy the last cell in column F in worksheet A and
place it in the Sheet titled "Summary" in cell C4. Then do the same for the
other documents in the Workbook, for example
Last populated Cell in Col F in WS A copy to cell C4 in Summary Document
Last populated Cell in Col F in WS B copy to cell C6 in Summary Document
Last populated Cell in Col F in WS C copy to cell C8 in Summary Document.
Last popluated Cell in Col F in WS D copy to cell C10 in Summary Document
Can this be done with VBA? Thanks for your help.