How can I do this? Please help

  • Thread starter Thread starter inbound03
  • Start date Start date
I

inbound03

I have two workbooks WA and WB. WB Sheet 1 has 853 rows starts from
number 104 on A1 till number 896 on A853; the data are stored in column
B to Column P. I need to transfer data from Workbook B Sheet 1 to
Workbook A Sheet 1 cells C5 - C10, C11, E11, and G5 - G9 every time I
input a number (from 104 to 896) into an input box embedded in WA Sheet
1. I know I need to create a For¡KNext Loop but I don't know how to
write it. Can someone please help!

Thanks in advance.

Alex
 
Not really clear what you want. I would guess that you need to *find*
some data in a worksheet using and inputbox and transfer it to another
sheet. No For...Next loop needed.

Rather than trying to describe what you want it would be easier if you
record a macro of the process and come back with problems. This is the
best method of starting all new processes. Forces us to organise our
thoughts.
 
Back
Top