I have a spreadsheet with many columns and only 1 row of data
If the sum of the numbers is >=500 then combine those numbers and put the result in the cell.
Keep doing this until you reach the last column.
I am trying to avoid a manual process and increase my efficiency.
Right now, I have to manually look at the data and sum if >500.
The spreadsheet is a scaled down version.
maybe there is some canned function in excel for what I am after.
Angell: I do get an invalid outside procedure and the debugger highlights Sheet1 in the following line:
cols = Sheet1.UsedRange.Columns.Count
I am not certain how to use it though.
thank you....