Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy data from 1 sheet into another
Is this possible? I have a spreadsheet with over 30 worksheets in it. Each sheet is individualized with names and personal information in it. I have a summary worksheet that lists everyone's name and a running total of numeric values. I need a new worksheet that I can use to type names into a list. As I type in the person's name, can excel pull the running total value from the summary sheet? Example: Name Number John Doe 8 (value from summary worksheet cell:B7) Jane Doe 36 "" "" cell:B8 Mary Doe 80 "" "" Cell:B9 etc Cell:B10 etc cell:B11 etc cell:b12 -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=497989 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy data from 1 sheet into another
It sounds like you could use =vlookup().
If that summary worksheet looks like a table, it should work. You may want to read Debra Dalgleish's notes: http://www.contextures.com/xlFunctions02.html Ltat42a wrote: Is this possible? I have a spreadsheet with over 30 worksheets in it. Each sheet is individualized with names and personal information in it. I have a summary worksheet that lists everyone's name and a running total of numeric values. I need a new worksheet that I can use to type names into a list. As I type in the person's name, can excel pull the running total value from the summary sheet? Example: Name Number John Doe 8 (value from summary worksheet cell:B7) Jane Doe 36 "" "" cell:B8 Mary Doe 80 "" "" Cell:B9 etc Cell:B10 etc cell:B11 etc cell:b12 -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=497989 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Copy an additional row based on another sheet | Excel Discussion (Misc queries) | |||
data from one sheet to several in sequential order! | New Users to Excel | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |