Hello,
I have been asked to automate copying certain values from two different sheets into a third sheet if the value selected in the last column on the two sheets read "hardcode". The problem is the third sheet has multiple rows to be filled in for each value transfered from the other sheets. I have attached a sample workbook.
The data from 5 specific columns have to be moved to the third sheet and I have mapped which cell values have to be copied to the sheet.
The value has to be inserted in the next empty cell on sheet 'TestAttribute' after skipping 15 rows. The rows are to be filled in by the user with the percentages and codes of accounts to be charged.
I've not been able to do this and would appreciate any help.
Cheers
I have been asked to automate copying certain values from two different sheets into a third sheet if the value selected in the last column on the two sheets read "hardcode". The problem is the third sheet has multiple rows to be filled in for each value transfered from the other sheets. I have attached a sample workbook.
The data from 5 specific columns have to be moved to the third sheet and I have mapped which cell values have to be copied to the sheet.
The value has to be inserted in the next empty cell on sheet 'TestAttribute' after skipping 15 rows. The rows are to be filled in by the user with the percentages and codes of accounts to be charged.
I've not been able to do this and would appreciate any help.
Cheers