VBA retrieving information 2 spredsheet

[neveu]

hello Forum,

i would need your advise on solving the next chalenge in Excel.

i have a list with invoice ordinal number ( from 1 to 40 - which depicts the position in a list ) in the Columns spreadsheet.
see image attached

image1

Uploaded with ImageShack.us


in another spreadsheet -matching panel- i have a list with the invoice number (generally a 10 character number but can also be a text aroudn 20 characters).

image 2

Uploaded with ImageShack.us
[the information from print screen are displayed starting wiht column D - frist 3 columns are hidden]
what i would need to through a VBA code is to copy the invoice number from the Matching panel over the respective ordinal number in the Columns spreasheet.

for example, invoice number 51217835 from matching panel should be copied over 1 in the columns spreadsheet as it is the first item in the list
similarly, db3s79ab110421-30259 should go over 3 as it is the 3rd item in the list


any help would be highly appreciated

 

[Desu Nota from Columbus]

hello Forum,

i would need your advise on solving the next chalenge in Excel.

i have a list with invoice ordinal number ( from 1 to 40 - which depicts the position in a list ) in the Columns spreadsheet.
see image attached

image1

Uploaded with ImageShack.us


in another spreadsheet -matching panel- i have a list with the invoice number (generally a 10 character number but can also be a text aroudn 20 characters).

image 2

Uploaded with ImageShack.us
[the information from print screen are displayed starting wiht column D - frist 3 columns are hidden]
what i would need to through a VBA code is to copy the invoice number from the Matching panel over the respective ordinal number in the Columns spreasheet.

for example, invoice number 51217835 from matching panel should be copied over 1 in the columns spreadsheet as it is the first item in the list
similarly, db3s79ab110421-30259 should go over 3 as it is the 3rd item in the list


any help would be highly appreciated

Will there always be only 40 numbers in a row that you need to copy and paste into the first table?
And will the data always start on Row 26 of Column A and paste over Row 6 Column A of sheet1?

If so, you could just record a macro of you performing the copy/paste.

 

[neveu]

Will there always be only 40 numbers in a row that you need to copy and paste into the first table?
And will the data always start on Row 26 of Column A and paste over Row 6 Column A of sheet1?

If so, you could just record a macro of you performing the copy/paste.

hello,
there can be more than 40 rows, or less.
i cannot use the macro recorder as i will not know what ordinal number i will have in the first spreadsheet