populate cells on current sheet depending on data on another sheet
Posted on 2014-08-21
would appreciate an expert providing me with VBA code that will populate cells on Sheet2 based on the number of rows in Sheet1.
i.e. Sheet 1 contains data in cells A2-P2. [Row 1 is the header] The number of rows will change daiy so today there could be 50 rows tomorrow 250 next day 100 and so on.
depending on the number of rows each day I will clear the data from my sheet 2 and then I want to add a formula based on the same number of rows.
So if there are 50 rows today I need to populate cell B2 in sheet 2 with =Sheet1!A2&Sheet1!D2&Sheet1!E2&Sheet1!F2&Sheet1!C2 and copy this down to cover the same number of rows that are in sheet 1.
I also have formulas in C2,D2 and E2 but I presume I can replicate the code that an expert provides for these.
Thanks in advance