Looking for some help here. I've managed to put together a macro for inventory at my business that works pretty well, but I've hit a bump in the road and am looking for some help. I currently have a spreadsheet where each row is a different item within my store. Each cell in that row represents a different bit of info on that item. For example, Cell B1 = a SKU number, Cell C1 = A Description, Cell D1 = Serial Number, Cell E1 = ID Number, etc. The way I have my macro set up, is it searches the entire spreadsheet for the requested item, very similar to the "Find" option built into Excel. I usually search by ID Number, but occationally have to go by Serial Number. I've got my macro set up so that when the item is found in the spreadsheet, it is automatically highlighted red. What I would like to do is to keep column A blank and in addition to highlighting the cell red, I would like to put an "*" in column A which corresponds to the the row of the found item. Example, I run my macro and search for ID Number 0025987. The macro finds the matching ID Number within the spreadsheet and highlights it red. Let's say it was found in Cell E17. I would like my macro to automactically put an "*" in A17. The offset property works if I search by the same column everytime. For example if I ALWAYS search by ID Number I can set the Offset Property, but if I search by Serial Number the Offset Property gets all messed up, because it puts my "*" in a column other than A.
Here is the code that colors the activecell for me.
With ActiveCell 'Set Color
.Interior.ColorIndex = 3 'Red=3
End With
How can I get the activecell to move to Column A within the current row?
Any help would be GREATLY appreciated!
Thanks,
-Rave
Here is the code that colors the activecell for me.
With ActiveCell 'Set Color
.Interior.ColorIndex = 3 'Red=3
End With
How can I get the activecell to move to Column A within the current row?
Any help would be GREATLY appreciated!
Thanks,
-Rave