Hi,
I have a very complex spreadsheet with over 200 rows of data, this data is spread over 3 columns with only one piece of data in each row. I want to write a macro to scan the cells, select the one with data, and depending on which column that data falls in apply a calculation to it, then drop to the next row and repeat.
eg. start with B3:D3, look across range, select cell with data (in this example it is B3) then apply this calculation =1-exp(-1*A3*$B$2) (A3 is a relative reference to the data, ie in B7 the calculation will be =1-exp(-1*A7*$B$2). then drop to row #4.
in range B4:D4, look across range, select cell with data (here it is C4) run this calculation, (A4/2)*$C$2. then drop to row #5
in range B4:D4, look across range select cell with data (here it is D5) run this calculation, (A5/2)*$D$2. the drop to row #6 etc...
i have made a simple example of my spreadsheet example vlookups.xlsx
All help will be much appreciated.
Bookmarks