multiple worksheets into one worksheet

Hi,

This link might help you

http://www.rondebruin.nl/summary2.htm


VBA Noob

Having a bit of difficulty understanding what you mean by putting multiple spreadsheets into one sheet (tab?). What I think you are trying to do is make a summary tab that pulls in usable "live" data from many of the other tabs without copying the formulas that generate those results.

Simplest way is to go to the summary tab, pick the cell you want the piece of data to appear in, type = and then change tabs and select the cell where you want to get the data from. Hit enter, which will take you back to the summary tab. This will update automatically when the data changes on the source tab. Format the summary table any way you want. Incidentally, you can copy this cell downward on the summary tab, and it will use the next cell down on the source tab as it's data source.

Pharm, that is what i wanted to do but i was seeing if there was an easier way so i could get the border lines and everything so what i did was copy and paste so i got the borders than i had to paste special just the values so i had the numbers but no formulas for now. My next step will be to do what you were saying and just link to the sheet and not have the actual formula.