View Single Post
 
Old 07-08-2011, 08:27 AM
vtec vtec is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2011
Posts: 2
vtec is on a distinguished road
Default Monster XL Question

Right. Deep breath.

I'm in the process of writing a monster spreadsheet and have hit a pretty vertical wall.

It is composed of 5 sheets.

On the main sheet, I need a formula that autofills cells.

I want to be able to enter either RDL 0035, RDS 009, RDS 007 or RDL 002 into cell G1. These are the names of the other 4 spreadsheets.

Depending on what text is entered into main sheet, cell G1, the values in main sheet, J2:K17 change to the values of J2:K17 from the sheet that is named in cell G1.

I believe I need to use VLookups?

Is this even possible?

Thanks.
Reply With Quote