MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cell/Column Calculation


Posted by Kev Tweddle on December 27, 2001 6:13 AM

Calling all Macro Gurus.

Here is a task:

I have a list of values in a column (say Column Q). Everyday there are values added to this column ie day 1 has 10 values in Column Q and then day two there are 12 values in column Q, day three there are 11 values. I want to write a program that checks this column to see if any values are present in any cells and if so then they are to be added and the result given in cell A1 on sheet 2.

Is that possible?

Thanks


Posted by Gary Bailey on December 27, 2001 6:19 AM

Is there any reason why you can't just use the Excel formula

=SUM(Sheet1!Q:Q)

Is there a particular reason you want to use VBA?

Gary