| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Likned Sheets
Appreciate any assistance that anyone can provide. I have a spreadsheet
(excel 2007) of which I have 8 people that I have to obtain data from. Is there a way that I can create a spreadsheet for each and have them update the main spreadsheet via their individual spreadsheets. I am hoping that there is something out there better than cutting and pasting. I tried linking, however, once I start typing in a cell the link goes away. Again I appreciate any assistance/advice that you can provide. -- Django |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Likned Sheets
Django =
Sorry -- the formula is: =SUM('Adam:Harold'!A1) fingers work. brain don't. "Django" wrote: Appreciate any assistance that anyone can provide. I have a spreadsheet (excel 2007) of which I have 8 people that I have to obtain data from. Is there a way that I can create a spreadsheet for each and have them update the main spreadsheet via their individual spreadsheets. I am hoping that there is something out there better than cutting and pasting. I tried linking, however, once I start typing in a cell the link goes away. Again I appreciate any assistance/advice that you can provide. -- Django |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Likned Sheets
Django --
An easy way: Let's say you have eight pages, named Adam, Barb, Chuck, etc., through Harold, all set up identically. You can add a sheet outside that set (either in front or behind) named Total. In that Total worksheet, cell A1 could be: ='Adam:Harold'!A1 HTH "Django" wrote: Appreciate any assistance that anyone can provide. I have a spreadsheet (excel 2007) of which I have 8 people that I have to obtain data from. Is there a way that I can create a spreadsheet for each and have them update the main spreadsheet via their individual spreadsheets. I am hoping that there is something out there better than cutting and pasting. I tried linking, however, once I start typing in a cell the link goes away. Again I appreciate any assistance/advice that you can provide. -- Django |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Likned Sheets
PB thanks for thr info. However, what I am trying to do is have them populate
certain fields. The main spreadsheet will do the rest. -- Django "pdberger" wrote: Django = Sorry -- the formula is: =SUM('Adam:Harold'!A1) fingers work. brain don't. "Django" wrote: Appreciate any assistance that anyone can provide. I have a spreadsheet (excel 2007) of which I have 8 people that I have to obtain data from. Is there a way that I can create a spreadsheet for each and have them update the main spreadsheet via their individual spreadsheets. I am hoping that there is something out there better than cutting and pasting. I tried linking, however, once I start typing in a cell the link goes away. Again I appreciate any assistance/advice that you can provide. -- Django |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
Linear Mode
