Creating a Macro to paste special values, which removes a formula dependant on what the ti

[ryanwaters]

Hi All,

There are requirements to identify and amend a data table that contains both data that is currently “Planned” data, which will be entered manually by the user and “Actual” data, which will be collected in [Replicon-Data Actuals] tab within the workbook.
The logical requirements are as follows:

Logic to Actualise data in the Revenue Tracker Tab
1. Look for next cell/column FROM LEFT in row 3 that contains the wording “Planned” in it.
2. Copy and paste special the (only) values that exist in the column found in point 1. From row 6 down to row 500, so that the data now stored in this column is hard-coded.
3. In row 3, change the cell in the relevant column from points 1. & 2. from “Planned” to “Actual”.
4. Formatting must match that of the previous actual row. First “Actual” row will only ever be column M.

Logic to Reverse the data in the Revenue Tracker Tab
1. Look for the last cell/column FROM LEFT in row 3 that contains “Actual”.
2. Pull the proceeding column back allowing the calculations and formatting back with it and the calculations to change with the movement.

Any help on this would be greatly appreciated as it’s got us baffled here.

Thanks,

Ryan

[ragulduy]

Please Login or Register  to view this content.