K0st4din
Well-known Member
- Joined
- Feb 8, 2012
- Messages
- 501
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hello, everyone,
thanks to your help, so far I have been dealing with a lot of troublesome tasks for me.
I'm here again for your help.
I have a large database table.
With other macros, I get almost to the end of this table.
I have a dilemma with which I can not fight.
The table has a range of A2:AB - by the end.
In column "D" are the dates (day, month, year), in column "G" - are the numbers or names, in column "J" - there are codes.
I'm looking for a macro that can check for the last two months (regardless of who they are) to repeat the codes in "J", according to the numbers or names in "G" against the dates in column "D".
For example, if I compare the December 2018 and January 2019 and the same number in column "G" have the same codes in column "J", make (remove) the coloration and colorless the cell (in the example given in December 2018 ) - (we are talking about all comparisons in the table).
If this condition is repeated several months back, then leave colored "G" cells without changing anything in them.
Attach a pic, if you want an example table, I will attach.
I ask for your help because I review thousands of rows and spoil my eyes from watching in every single line.
If you have questions, please ask them to explain even more.
I thank everyone for your cooperation.
picture - https://drive.google.com/file/d/1UrNInwHJ9TaIeZJ_aJHHkQt7D4VJVs7a/view
https://drive.google.com/open?id=1UrNInwHJ9TaIeZJ_aJHHkQt7D4VJVs7a
thanks to your help, so far I have been dealing with a lot of troublesome tasks for me.
I'm here again for your help.
I have a large database table.
With other macros, I get almost to the end of this table.
I have a dilemma with which I can not fight.
The table has a range of A2:AB - by the end.
In column "D" are the dates (day, month, year), in column "G" - are the numbers or names, in column "J" - there are codes.
I'm looking for a macro that can check for the last two months (regardless of who they are) to repeat the codes in "J", according to the numbers or names in "G" against the dates in column "D".
For example, if I compare the December 2018 and January 2019 and the same number in column "G" have the same codes in column "J", make (remove) the coloration and colorless the cell (in the example given in December 2018 ) - (we are talking about all comparisons in the table).
If this condition is repeated several months back, then leave colored "G" cells without changing anything in them.
Attach a pic, if you want an example table, I will attach.
I ask for your help because I review thousands of rows and spoil my eyes from watching in every single line.
If you have questions, please ask them to explain even more.
I thank everyone for your cooperation.
picture - https://drive.google.com/file/d/1UrNInwHJ9TaIeZJ_aJHHkQt7D4VJVs7a/view
https://drive.google.com/open?id=1UrNInwHJ9TaIeZJ_aJHHkQt7D4VJVs7a