Inserting info in a cell to complete a formula??

[vingo]

I am setting up a file to automatically fill in time on a timesheet based on the time my reps sign in and out. Currently, I have to reference each cell specifically. Here is an example..

=Sun1!B31

This particular rep signs in on line 31. I want to be able to put "31" in cell A1 on the current worksheet and for the formula to pull B31 in worksheet Sun1. This would also allow me to change A1 to whatever line the rep is signing on...Doe this make sense?? HELP PLEASE!!!!!!!

Vi

 

[SydneyGeek]

Hi Vingo, welcome!

Try this: =INDIRECT("Sun1!B" & A1)

Denis

 

[vingo]

That worked!! Thanks a lot!!! Better add this page to my favorites!!!