Get data from closed file... Cont..

  • Thread starter Thread starter Kashyap
  • Start date Start date
K

Kashyap

I have the below code.. But the range is fixed in the below case.. How to
make it dynamic?

i.e: if value in peter.xls Sheets("may") A2:AD2 matches value in current
sheet A2 then

it should copy values from row3 to row 21 from peter.xls Sheets("may") to
current sheet D1

Sub GetData_Example3()
GetData "D:\SavedFiles\CK\ZSL\May\\peter.xls", "May", _
"E3:E21", Sheets("may").Range("D1"), False, False

End Sub
 

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

Filter and copy data to other sheet 3
Copy Data from Closed File to Existing File 0
Code copies ONLY last j from sheet 9
Dynamic Offset from an Application.Goto cell = Date or Time 10
VBA Copying/Pasting problem when data is filtered 1
Follow up question. Get value of closed file. 5
Hidden sheet bleeds through 3
Userforms, switching sheets 6

Back
Top