Excel macro to copy paste data based on conditions
Budget: $10 – $30 USD
Excel VBA script for copy a formula from a cell (source_cell) and paste special formulaes it in a range only if the cell color in the destination is the same as Source Cell.
Note: the macro should work as follows upon execution;
Step 1 User should be asked to select the source_cell. (Error handle: the user should select only one cell. If more than one cell is selected an error should be displayed ‘Please select only one cell’
Step 2: Then, the macro should then prompt the user to select the range where the formula is to be copied to.
Step 3: Macro should run and copy paste the formula in the cells within the range (selected in previous step) only if the cell color matches with the source_cell
Step 3: display ‘Copy complete’
Note: the macro should work as follows upon execution;
Step 1 User should be asked to select the source_cell. (Error handle: the user should select only one cell. If more than one cell is selected an error should be displayed ‘Please select only one cell’
Step 2: Then, the macro should then prompt the user to select the range where the formula is to be copied to.
Step 3: Macro should run and copy paste the formula in the cells within the range (selected in previous step) only if the cell color matches with the source_cell
Step 3: display ‘Copy complete’