G
Guest
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.
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.