sglife
Valued Forum Contributor

thanks for the help with my timesheet. it is great.

thanks you for your VBA program today. A couple of other users posted formulas, but I could not get them to work. Your method excells

i replied on you regarding the data consolidation and i am waiting your urgent feedback thanks in advance

Hi sglife,

You very helpfully gave me the following formula a couple of weeks ago which allowed me to specifically reference a cell on another sheet and then from this move to other cells - the formula was:

=INDIRECT("Sheet1!A"&((ROW()+13)/14)+1)

However, I'm struggling to adapt this for other locations on other sheets. Would you mind explaining what the formula actually does?

Kind regards,

Anakeimai

My thread was locked (though I'm not actually sure why) so I thought I'd just thank you via private message for your help. Many thanks.