Cell Comparison

[heliskier89]

I’d be grateful if anyone can offer some advice on how to achieve my goal by either modifying the code below or offering an alternative method.

The spreadsheet named “Register Rev e Forum Post” will be updated routinely, only one worksheet at a time, to show the actual status ‘OPEN’ or ‘CLOSED’.

What I need to do is when a particular actual (cell D) status differs from the normal (cell C) status then the whole row needs to be copied to another workbook (Out of Sequence). Any subsequent differences will be added to the next available row. If any of these discrepancies revert to the correct status (ie Normal & Actual are the same) then the associated row on the ‘Out of Sequence’ worksheet will be deleted.

The macro in ‘This Workbook’ of ‘Register Rev e Forum Post’ achieves this somewhat but has the following bugs.

• Rows are copied only to rows 4 & 5 on the ‘Out of Sequence’ worksheet. For example the first two differences will be copied to these rows then if a third existed it would copy into row 5 and hence only show 2 selections when 3 actually existed.

• This macro requests that the input be in uppercase with no background colour. In reality these inputs will be as seen in the Normal columns ie red or green background.

• This macro requires the ‘Out of Sequence’ workbook to be open. Ideally I would like to have this workbook, which will be located in another drive, to be copied to automatically without the need to manually open the workbook prior to the input of data to ‘Register Rev e Forum Post’ workbook.
There is also no need for the error message regarding the input data.

I have very limited knowledge of coding and have been reliant so far on the help of others. Any help at all would be much appreciated.

I'm using Excel 2007

Please Login or Register  to view this content.