2 Questions regarding the use of the “=” sign

[so_fistica_ted]

1- I have a column of dates (A100:A250).
In B1:B30 I need the first 30 dates, in C1:C30, the next 30 and so on, in D, E and F.
I wrote in B1 "=A100", in B2 "=A101"..... B30 "=A130".
I can go to C1 and manually write "=A131", copy down; then in D1 "=A161" and so on.

Looking for a way (hope there is one) to avoid writing manually in C1, D1 and so.
I tried writing in C1 "=B130+1" but, of course if, for example, the date in B30/A130 is 4/20 and in B31/A131 is "4/26", it's giving me "4/21" (4/20+1).


2- In the above set up, if I erase one raw in the A1:A150, the corresponding "=" cell in the B1:F30 gives the #REF! error message.
I would like to be able to erase a raw and still keep the right (updated) dates in the B1:F30 range.

Any ideas anyone?
Thanks in advance and appreciate any help.
Ted

[scott.s.fower]

use the fill handle, the little black square in the lower right hand corner, it will make your cursor become a + sign you can then drag down a formula =B130+1 will give you the value of B130 + 1
if B130 = 200, then it would be 200 + 1, if it is a date it will be that date plus one day

also you should lock your column, if all the dates are in the A column your formula should be =$A100 when you copy the formula from the B column to the C column then it will still look at the A column, then you can change the row number and drag it down

once you have the dates in, you can copy and paste special values to preserve the date, then you can delete the raw data

[so_fistica_ted]

use the fill handle, the little black square in the lower right hand corner,

Thanks scott for your answer, but those were not my questions. :-) and I did use the fill handle.

also you should lock your column, if all the dates are in the A column your formula should be =$A100 when you copy the formula from the B column to the C column then it will still look at the A column, then you can change the row number and drag it down

Again, thanks for this one.
The reason I used a relative and not an absolute reference was that I simply wanted to use the fill handle also for copying the formula from B1 to C1 and so on (if it was an absolute ref. it wouldn't be able to do it).

Now to my questions: I am asking specifically for a way to write and use the "=" sign or formula, or whatever is possible when I move from B30 to C1, from C31 to D1 and so on.

And my 2nd question is regarding the deletion of a raw and the way to avoid receiving the #REF! error.

Thanks for trying though, appreciate your time.
Hope I made it clear this time. :-)

[JosephP]

perhaps in B1:
=INDEX($A:$A,99+(COLUMN()-2)*30+ROW())
then copy down and across

[scott.s.fower]

you need to give us an example workbook, a picture is worth a thousand words, your explanation is not very clear

[so_fistica_ted]

you need to give us an example workbook, a picture is worth a thousand words, your explanation is not very clear

You are right, I assumed I explain it clearly, but I should have attached a file.
I tried right now but it gives me an error 2038 message. I will try to find out what the problem is and if I find out I will try to upload the file again, so you can see what I was talking about.
Anyway, thanks a lot for trying, appreciate that!

perhaps in B1:
=INDEX($A:$A,99+(COLUMN()-2)*30+ROW())
then copy down and across

Thanks JosephP! It solved my question completely! Appreciate your time and suggestion!
Ted