I’m wanting to auto paste sums from one workbook to another workbook to a specific cell based on a condition. The sums are in workbook1 and I’m wanting to paste the sums to workbook2. The sums will be placed on the same row but different cells where the cell value = current date.
example: worksheet1 sums to c3 then place this value in worksheet2 on the same row where current date is found. For instance, current date is on Worksheet2:A1 so I want to paste the sum from worksheet1 to worksheet2:a3. (Two cells to the right where current date Is found).Current date will only appear once in workbook. How can I do this?
example: worksheet1 sums to c3 then place this value in worksheet2 on the same row where current date is found. For instance, current date is on Worksheet2:A1 so I want to paste the sum from worksheet1 to worksheet2:a3. (Two cells to the right where current date Is found).Current date will only appear once in workbook. How can I do this?