Edit Macro for GOTO Part No.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Sebastienm's solution to "GOTO a Part Number" Works Great, But once
I get to the part number I want to goto the current quarter (QT1, QT2, QT3,
QT4) and edit/add the Recd1, Recd2, Recd3, Recd4 in that cell.

Thanks for the Help
 
Hi,
Could you please be more specific?
When the row is found , say it is store in the range variable Rg , what
should the macro do? just go to the another column on the same row?
-say Rg has been found
-instead of going to that cell, say you want to go 3 cells (columns) on
the right.
Add the following line of code before the Goto method.
Set Rg=Rg.Offset(0,3)

Regards,
Sebastien
 
It should go to another column named either Recd1, Recd2, Recd3, or Recd4 in
the same row as Rg. Maybe even ask what quarter to enter data? Then edit the
active cell.(F2) and loop back to enter the next Part No.

Thanks,
RSB
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looping through records 1
Resetting error reporting after On Error GoTo 1
GOTO a Part Number 4
Goto Reference:="abc" where abc is formula result 5
Macro cannot access hidden sheet 2
Macro Code not reliable 6
How to stop 'Egg Timer' 3
GoTo problem. 4

Back
Top