Using a reference from another page to fill a worksheet

**Fuddy Duddy** · 01-18-2008, 05:16 PM

I have a workbook that has several worksheets for jobs that have exactly the same data in each cell.

I want to have a recap worksheet that would not require the typical pasting or each cell on the recap worksheet, i.e., ='sheet1'!A1, etc.

In other words, the job worksheets would have a cell with the name of the name of the job, and then by referencing the cell on each job worksheet on the recap sheet, it would complete the recap sheet automatically.

Thanks in advance for any help that you can give.

**oldchippy** · 01-19-2008, 05:08 PM

Hi,

Is this what you mean?

http://exceltips.vitalnews.com/Pages...orksheets.html

**Fuddy Duddy** · 01-20-2008, 04:20 PM

Thanks, but that is not what my problem is.

I wish I could attach a zip file, but for some reason my zip utility is not working right.

I know that it is hard to follow, but I will try again.

There is a screen shot attached that will give you a better idea.

The data in Columns A thru K come from the data from the worksheets shown on the tabs at the bottom of the RECAP sheet.

What I would like to do is to be able to fill the cells from the other worksheet without having to mechanically having to do the "=BLANK1!I18" process for each piece on data shown.

For example, by filling out the secondary sheets, the RECAP sheet has a wildcard formula that fills out the corresponding from the other worksheets.

This would save a great deal of time when each investmenet sheet is added.

Hope this helps.

**VBA Noob** · 01-20-2008, 04:45 PM

See if this helps

Place in a empty sheet in A1 and drag down and across. It will return the values in sheet Blank1

=OFFSET(Blank1!A1,COLUMNS(A1)-1,ROWS(A1)-1)

VBA Noob

**Fuddy Duddy** · 01-20-2008, 08:45 PM

Thanks but that does not do what I need it to do.

Although each of the secondary pages are identically the same, the RECAP sheet summarizes the results in the secondary worksheets.

Is there are way to use wildcards in Excel?

Let's say that by using the wildcard formulas in each row that is to receive the info from the secondary sheets, and by changing either a cell in the secondary or the tab for each secondary page...you have the data from each secondary cell shown on the RECAP sheet.

Am I trying to do something that is not possible in Excel. I know that it can be done in programming, but can such a thing be done in Excel?