I have a spreadsheet with up to 2000 rows which I run each day to check for matching errors. All data is general (alpah
I compare in rows 1-2000 the col A number with the col C number and the col B number with the col D number.
I am running Excel 2003.
I do not know VB or scripting.
Col A and B are automatically populated by input from a data base with up to 2000 numbers in a new worksheet.
Col C and D are populated by hand scanner input.
After scanning in the row of data into col C then col D I need to automatically return to the next empty row in col C. My
scanner allows me to go from row "X" col D one cell to the right to col E (tab) or one cell down in col D (return).
So I need to go left one cell or down one cell and left two cells to get back to the next empty row in col C. My scanner does
not allow further commands.
I am stuck in one of these two cells after entering data in row "X" col D.
Not a complicated process.
However, I want to expedite the process.
I need a way to automatically return to the next empty row of col C without hitting a key so I can scan in the next rows
Entering in up to 2000 rows of data in col C and D takes a lot longer without the automation I am looking for.
I built a macro but it still requires a keyed entry. I think what I need is an automatic shift/tab to move left one cell from
the col D I can end up in.
Is there a way to automate the "move" or "go to" to the next empty col C row?
In col E I compare data in col A (each row 1 - 2000) with data in col C.
In col F I compare data in col B (each row 1 - 2000) with data in col D.
The formulas for col E and F are easy.
Formulas are in rows 1-2000.
In G1 I count the number of "BAD" compares with:
In H1 I count the number of "BAD" compares with: =COUNTIF(F1:F2000,"BAD")
In I1 I sum G1:H1 for a total of "BAD" for the day.
Help appreciated, thanks.