Copy data from data sheet
 

Hi everyone. I have a large data sheet, with the first 6 columns of
data I need. Column 1 of the data sheet is an invoice number. I then
have a calculation sheet. In cell A2 of the calculation sheet is an
invoice number. Can I have vba scan column A of the data sheet for
the invoice number in A2 and return columns 1 thru 6 into the
calculation sheet? Thanks!!!

Copy data from data sheet
 

You can, but why wouldn't use use VLOOKUP instead?
--
HTH,
Barb Reinhardt



"Steve" wrote:

Hi everyone. I have a large data sheet, with the first 6 columns of
data I need. Column 1 of the data sheet is an invoice number. I then
have a calculation sheet. In cell A2 of the calculation sheet is an
invoice number. Can I have vba scan column A of the data sheet for
the invoice number in A2 and return columns 1 thru 6 into the
calculation sheet? Thanks!!!

Copy data from data sheet
 

Because I have multiple instances of the same invoice number. I need
to copy in every instance of the given invoice number. Thanks!

On Mar 24, 3:54*pm, Barb Reinhardt
wrote:
You can, but why wouldn't use use VLOOKUP instead?
--
HTH,
Barb Reinhardt



"Steve" wrote:
Hi everyone. *I have a large data sheet, with the first 6 columns of
data I need. *Column 1 of the data sheet is an invoice number. *I then
have a calculation sheet. *In cell A2 of the calculation sheet is an
invoice number. *Can I have vba scan column A of the data sheet for
the invoice number in A2 and return columns 1 thru 6 into the
calculation sheet? *Thanks!!!- Hide quoted text -

- Show quoted text -