Jeorge
New Member
- Joined
- Nov 27, 2015
- Messages
- 32
Hi Sir Ma'am,
Need help to put the dates only on visible cells, I hid A2, A3 then hid A5, A6 then hid A8, A9 and so on... With that my visible cells were A1, A4, A7, A10.
A1= 1-Apr and I wanted to drag it to A10 and my expectation was
A1 = 1-Apr
A4 = 2-Apr
A7 = 3-Apr
A10 = 4-Apr
but when I drag it, hidden cells are still considered which failed my date that I wish to see only on visible cells.
Thank you very much for any help
Need help to put the dates only on visible cells, I hid A2, A3 then hid A5, A6 then hid A8, A9 and so on... With that my visible cells were A1, A4, A7, A10.
A1= 1-Apr and I wanted to drag it to A10 and my expectation was
A1 = 1-Apr
A4 = 2-Apr
A7 = 3-Apr
A10 = 4-Apr
but when I drag it, hidden cells are still considered which failed my date that I wish to see only on visible cells.
Thank you very much for any help