MS Excel ?

[HB Vic]

How about when entering a date? It wants to progress to next day. Can I change something to copy same date?

You can also enter the same data in two cells, say A1 & B1, highlight both cells, then drag the lower right across to the left.

[Stainless]

You can also enter the same data in two cells, say A1 & B1, highlight both cells, then drag the lower right across to the left.

Yea, I figured that out in post 7. What is the absolute reference? Sorry I'm self teaching here.

[HB Vic]

Yea, I figured that out in post 7. What is the absolute reference? Sorry I'm self teaching here.

The dollar sign: $. So if you want to fix A1 so it doesn't update, enter: $A$1. If you want to fix only A, enter: $A1 and vice versa

[Stainless]

The dollar sign: $. So if you want to fix A1 so it doesn't update, enter: $A$1. If you want to fix only A, enter: $A1 and vice versa

I'm lost here, but date isn't a big deal. I can do what I what I described in post 1. Maybe I will re-read this tomorrow and get it.