Help with a macro please

[Buns1976]

Hi Everyone,

I have a worksheet where cell B2 is populated by a handheld scanner as text, cell C2 is a date that is keyed and cell D2 is an invoice that is keyed and formatted as text.

What I am looking for is when B3 is populated, cells C3 and D3 are populated with the same date and invoice as C2 & D2 and so forth down to row 50!

Any help would be greatly appreciated.

Thank you!!

 

[shg]

How about just a formula?

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Scan input​

[/td][td="bgcolor:#F3F3F3"]

Date​

[/td][td="bgcolor:#F3F3F3"]

Invoice​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td](scan text)[/td][td]

26 Mar 2019​

[/td][td]ABCD[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td](scan text)[/td][td="bgcolor:#CCFFCC"]

26 Mar 2019​

[/td][td="bgcolor:#CCFFCC"]ABCD[/td][td="bgcolor:#CCFFCC"]C3: =IF($B3 = "", "", C2)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td](scan text)[/td][td="bgcolor:#CCFFCC"]

26 Mar 2019​

[/td][td="bgcolor:#CCFFCC"]ABCD[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td][/td][td="bgcolor:#CCFFCC"][/td][td="bgcolor:#CCFFCC"][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td][/td][td="bgcolor:#CCFFCC"][/td][td="bgcolor:#CCFFCC"][/td][td][/td][/tr]
[/table]

 

[Joe4]

So, are you saying that for all the rows between 3 and 50, when column B is populated, columns C and D should automatically be populated with the same values from the row just above it (or should it always pull the values from row 2)?

 

[Buns1976]

shg,

That would be the ticket. I was way overthinking that one.

Thanks so much!!

 

[shg]

You're welcome.