Hello all,
I am having to check a large amount of data and am trying to automate a part of my process to help tone down my checking time. I believe that VBA is the best way to handle what I am trying to accomplish, and so I have been reading tutorials/watching youtube videos over basic concepts. I even enrolled in a course at my local community college! You guys who program are extremely valuable in your companies, and I am trying to increase my value as well.
With that being said I don't know much (if anything, to be honest), and I was hoping that someone could point me in the right direction of how I can go about accomplishing my task.
What I have is a spreadsheet that looks similar to the one below.
<tbody>
</tbody>
Column A is a code. I will have multiple codes in one spreadsheet, and the order that they appear will be at random. Each code has its own set of attributes, and they populate in B:F.
Right now I am focusing on G_WELD, because if I can figure out how to do that one code I believe I can figure out the rest.
Each time G_Weld pops up in Column A, the code will need to compare its C column against the E column of the NEXT G_WELD. Please notice how C1 and E2 are the same. If the contents of the cells are different, then they need to be highlighted, as is the case for C2 & E5. The problem is there might be multiple codes in column A between each G_WELD.
Originally I filtered my spreadsheet by Column A, and then did a conditional formatting once all my G_WELDS were together, but that was a mistake on my end, because I have to keep the order of the codes as they are exported from the software we use. So it makes checking them very tedious.
So my question is, can I make my active cell be A, have code that runs down the columns until it hits a G_WELD, then offset the active cell towards C, have it store that information, and check it against the column E of the NEXT G_WELD in column A?
Sorry if my question is poorly worded. I appreciate your patience and your time in reading my question. Thank you very much for any help!
Jxspea
I am having to check a large amount of data and am trying to automate a part of my process to help tone down my checking time. I believe that VBA is the best way to handle what I am trying to accomplish, and so I have been reading tutorials/watching youtube videos over basic concepts. I even enrolled in a course at my local community college! You guys who program are extremely valuable in your companies, and I am trying to increase my value as well.
With that being said I don't know much (if anything, to be honest), and I was hoping that someone could point me in the right direction of how I can go about accomplishing my task.
What I have is a spreadsheet that looks similar to the one below.
A | B | C | D | E | F |
G_WELD | CMLG0374 | 0330 034 13A | 16.5 | 0322 034 05A | 30.2 |
G_WELD | XMLS0378 | 2000679677 | 44.95 | 0330 034 13A | 16.5 |
P_TRANS | 0.375 | X60 | 0.312 | X60 | |
L_END | 9099568 | ||||
G_WELD | CMLG0376 | 0177 034 05 | 64.6 | 0123 054 12 | 44.98 |
<tbody>
</tbody>
Column A is a code. I will have multiple codes in one spreadsheet, and the order that they appear will be at random. Each code has its own set of attributes, and they populate in B:F.
Right now I am focusing on G_WELD, because if I can figure out how to do that one code I believe I can figure out the rest.
Each time G_Weld pops up in Column A, the code will need to compare its C column against the E column of the NEXT G_WELD. Please notice how C1 and E2 are the same. If the contents of the cells are different, then they need to be highlighted, as is the case for C2 & E5. The problem is there might be multiple codes in column A between each G_WELD.
Originally I filtered my spreadsheet by Column A, and then did a conditional formatting once all my G_WELDS were together, but that was a mistake on my end, because I have to keep the order of the codes as they are exported from the software we use. So it makes checking them very tedious.
So my question is, can I make my active cell be A, have code that runs down the columns until it hits a G_WELD, then offset the active cell towards C, have it store that information, and check it against the column E of the NEXT G_WELD in column A?
Sorry if my question is poorly worded. I appreciate your patience and your time in reading my question. Thank you very much for any help!
Jxspea