Chris_1990
New Member
- Joined
- Mar 8, 2021
- Messages
- 1
- Office Version
- 365
- 2016
- 2010
- Platform
- Windows
Hello all,
I am new to VBA and can read/modify some coding but am not fluent enough to write any from scratch. I have searched for many different pieces of code from others projects and tried to splice together but can't make it remotely do what I want. I have a master checklist based on a table, this table has been changed by others significantly (columns added/deleted, rows added deleted. and sorting changed) the original author used a formula to set row numbers so when the document got resorted we couldn't determine the original sorting to set it back. Now for my part of the problem I only need to make sure my 10 columns get entered into its match rows, however if a row does not match I do not want it to create a row as it is probably the case of a naming change within the tag description. So basically I want to search row x column D-H of the original for matches with row x column C-G in the updated and if match is found then copy row x column P-Y on the original and paste it to row x column O-X in the updated. If match was found then I want the copied cells that were pasted in the updated form to be formatted Dark Grey to allow for easy filtering of the non-matches. this may be simple but as I said I am not fluent enough to write my own code for it and I haven't found anything that will do all of what I am wanting yet.
Thank you in advance for any time you spend in assisting me.
I am new to VBA and can read/modify some coding but am not fluent enough to write any from scratch. I have searched for many different pieces of code from others projects and tried to splice together but can't make it remotely do what I want. I have a master checklist based on a table, this table has been changed by others significantly (columns added/deleted, rows added deleted. and sorting changed) the original author used a formula to set row numbers so when the document got resorted we couldn't determine the original sorting to set it back. Now for my part of the problem I only need to make sure my 10 columns get entered into its match rows, however if a row does not match I do not want it to create a row as it is probably the case of a naming change within the tag description. So basically I want to search row x column D-H of the original for matches with row x column C-G in the updated and if match is found then copy row x column P-Y on the original and paste it to row x column O-X in the updated. If match was found then I want the copied cells that were pasted in the updated form to be formatted Dark Grey to allow for easy filtering of the non-matches. this may be simple but as I said I am not fluent enough to write my own code for it and I haven't found anything that will do all of what I am wanting yet.
Thank you in advance for any time you spend in assisting me.
