Set up macro in Excel to choose active row?
I have an Excel spreadsheet with multiple worksheets. I want to be able to
set up a macro within one of the worksheets that will allow me to do the
following:
Once I type in a barcode number in a cell (say b3 of worksheet 2) and click
on the macro button it will:
1 open another worksheet in the file (worksheet 1)
2 find the number from the active cell (b3 of worksheet 2)
3 highlight the entire row in worksheet 1 where the barcode number was found
4 turn the text in that row green
5 save the worksheet
6 go back to worksheet 2
I don't know any visual basic code. I have in the past used macros to do
generic steps, none that required it to find a number and do something with
it. My problem is that it does the action only to the row the initial macro
was recorded in.
Any help would be greatly appreciated.
|