Not sure if this should be in the Excel subforum or the modules as it is being done from Access but dealing with Excel.
I can't seem to word my question right for Google to provide me direction, so I apologize if this is a really simple one. Below is a snip of an example file:
I am looping through the columns looking for the value "Line Note:", which is simple enough, however what I cant figure out is once I find it, find the next value above it, cut and paste the note with an offset of 1 to the right so it ends up on the same line as the part number but one column over.
The finding of the note and the final cut/paste and offset I get, I just cant figure out how to dynamically find data above each line note as the amount of rows above it can change.
I can't seem to word my question right for Google to provide me direction, so I apologize if this is a really simple one. Below is a snip of an example file:
I am looping through the columns looking for the value "Line Note:", which is simple enough, however what I cant figure out is once I find it, find the next value above it, cut and paste the note with an offset of 1 to the right so it ends up on the same line as the part number but one column over.
The finding of the note and the final cut/paste and offset I get, I just cant figure out how to dynamically find data above each line note as the amount of rows above it can change.