I have looked thru many many posts regarding copying data to the next empty row in another sheet, but none seem to address my particular situation.
I need a macro to check and see it a cell >0, if not then copy cells in that row, however the cells are not concurrent.
The check cells existing in Sheet101 (named Calc) can be a range since there are only 30 rows that I need to evaulate, the range is C6:C35, if those cells are not blank then copy the certain cell values to the next blank row in sheet102 (Named RDATA).
Example would be as follows;
if Cell C6 >0
Copy cell BB2 to RDATA A2
Copy cell C6 to RDATA B2
Copy cell E6 to RDATA C2
Copy cell G6 to RDATA D2
Copy cell BB6 to RDATA E2
Copy cell BC6 to RDATA F2
Copy cell BD6 to RDATA G2
Copy cell BE6 to RDATA H2
Copy cell BF6 to RDATA I2
Copy cell BG6 to RDATA J2
Copy cell BH6 to RDATA K2
Copy cell BI6 to RDATA L2
Then the same thing for rows 7 thru 35, the first cell copied (in example BB2) is a constant and should be copied in the column A every time for each instance. Also since all the cells contain formulas, it must copy & paste the values.
Thank you in advance for your help with this.
I need a macro to check and see it a cell >0, if not then copy cells in that row, however the cells are not concurrent.
The check cells existing in Sheet101 (named Calc) can be a range since there are only 30 rows that I need to evaulate, the range is C6:C35, if those cells are not blank then copy the certain cell values to the next blank row in sheet102 (Named RDATA).
Example would be as follows;
if Cell C6 >0
Copy cell BB2 to RDATA A2
Copy cell C6 to RDATA B2
Copy cell E6 to RDATA C2
Copy cell G6 to RDATA D2
Copy cell BB6 to RDATA E2
Copy cell BC6 to RDATA F2
Copy cell BD6 to RDATA G2
Copy cell BE6 to RDATA H2
Copy cell BF6 to RDATA I2
Copy cell BG6 to RDATA J2
Copy cell BH6 to RDATA K2
Copy cell BI6 to RDATA L2
Then the same thing for rows 7 thru 35, the first cell copied (in example BB2) is a constant and should be copied in the column A every time for each instance. Also since all the cells contain formulas, it must copy & paste the values.
Thank you in advance for your help with this.