excel macro

[elenamccarthy]

I want to look at one excel sheet called "shipping and receiving log", I want it to find a "serial number" ex. W-111, then go to another excel sheet called "Serial Numbers" and find the correct instrument type ex. Worker. I want it to find the matching serial number from the first excel sheet ex. W-111, locate the date ex. 1-28-10 and then input it into the "shipping and receiving log". How would I write this up? Any code is appreciated.

 

[elenamccarthy]

Yes. Is there a way to do it?

 

[oldbrewer]

serial

date

number of rows of data

27

bt687

01/07/2017

2

current serial No

bt687

bt688

05/07/2017

occurrencies

3

bt689

09/07/2017

previous date

02/07/2017

bt690

13/07/2017

bt691

17/07/2017

bt692

21/07/2017

bt693

25/07/2017

bt688

05/07/2017

bt689

09/07/2017

bt690

13/07/2017

bt691

17/07/2017

bt692

21/07/2017

bt693

25/07/2017

note that the last entry bt687 has

bt687

02/07/2017

15

retrieved the date from the previous bt687

bt688

05/07/2017

bt689

09/07/2017

the helpers at the top automatically

bt690

13/07/2017

detect the last row number and how

bt691

17/07/2017

many prev occurrences

bt692

21/07/2017

and the previous date

bt693

25/07/2017

bt688

05/07/2017

which is pulled by the formula

bt689

09/07/2017

bt690

13/07/2017

formula giving the date in row 28 is

bt691

17/07/2017

=IF(ISERROR(MATCH(A28,$A$2:$A27,0)),"type in today's date",$I$4)

bt692

21/07/2017

bt693

25/07/2017

bt687

02/07/2017

28

col C finds every occurrence of bt687

<colgroup><col><col><col span="5"><col><col><col span="6"></colgroup><tbody>
</tbody>

 

[oldbrewer]

alas when I entered the next serial number it fell over, so I think a date confirmation macro button is needed.....

 

[elenamccarthy]

Ok how can i find or put that in?