Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populating Multiple Worksheets with one entry
Hello all, I'm new to this forum and it looks like this may be the place I need to be to find an answer to my question. I have a workbook that contains multiple worksheets. My goal is to enter data into one worksheets and have that data automatically transfer and update all the other worksheets with the same data so I don't have to enter it into each worksheet. Anyone know if this is possible? Thanks in advance! -- Intuit ------------------------------------------------------------------------ Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901 View this thread: http://www.excelforum.com/showthread...hreadid=505762 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populating Multiple Worksheets with one entry
Intuit, group the sheets, right click on the worksheet tab an select all
sheets, make your changes then right click on sheet tab and ungroup sheets -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Intuit" wrote in message ... Hello all, I'm new to this forum and it looks like this may be the place I need to be to find an answer to my question. I have a workbook that contains multiple worksheets. My goal is to enter data into one worksheets and have that data automatically transfer and update all the other worksheets with the same data so I don't have to enter it into each worksheet. Anyone know if this is possible? Thanks in advance! -- Intuit ------------------------------------------------------------------------ Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901 View this thread: http://www.excelforum.com/showthread...hreadid=505762 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populating Multiple Worksheets with one entry
Intuit,
You might also look into paste special link and see if that does what you want. It pastes a link to the original data so that if your original data changes, the cell containing the link will change as well. Heidi "Intuit" wrote: Hello all, I'm new to this forum and it looks like this may be the place I need to be to find an answer to my question. I have a workbook that contains multiple worksheets. My goal is to enter data into one worksheets and have that data automatically transfer and update all the other worksheets with the same data so I don't have to enter it into each worksheet. Anyone know if this is possible? Thanks in advance! -- Intuit ------------------------------------------------------------------------ Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901 View this thread: http://www.excelforum.com/showthread...hreadid=505762 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populating Multiple Worksheets with one entry
Paul B Wrote: Intuit, group the sheets, right click on the worksheet tab an select all sheets, make your changes then right click on sheet tab and ungroup sheets -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Intuit" wrote in message ... Hello all, I'm new to this forum and it looks like this may be the place I need to be to find an answer to my question. I have a workbook that contains multiple worksheets. My goal is to enter data into one worksheets and have that data automatically transfer and update all the other worksheets with the same data so I don't have to enter it into each worksheet. Anyone know if this is possible? Thanks in advance! -- Intuit ------------------------------------------------------------------------ Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901 View this thread: http://www.excelforum.com/showthread...hreadid=505762 This worked great! Your awesome! You just saved me a possibly big headache! Thanks!!!!!!!!!!!! -- Intuit ------------------------------------------------------------------------ Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901 View this thread: http://www.excelforum.com/showthread...hreadid=505762 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populating Multiple Worksheets with one entry
Paul B Wrote: Intuit, group the sheets, right click on the worksheet tab an select all sheets, make your changes then right click on sheet tab and ungroup sheets -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Intuit" wrote in message ... Hello all, I'm new to this forum and it looks like this may be the place I need to be to find an answer to my question. I have a workbook that contains multiple worksheets. My goal is to enter data into one worksheets and have that data automatically transfer and update all the other worksheets with the same data so I don't have to enter it into each worksheet. Anyone know if this is possible? Thanks in advance! -- Intuit ------------------------------------------------------------------------ Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901 View this thread: http://www.excelforum.com/showthread...hreadid=505762 This worked great! Your awesome! You just saved me a possibly big headache! Thanks!!!!!!!!!!!! -- Intuit ------------------------------------------------------------------------ Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901 View this thread: http://www.excelforum.com/showthread...hreadid=505762 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populating Multiple Worksheets with one entry
Your welcome
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Intuit" wrote in message ... Paul B Wrote: Intuit, group the sheets, right click on the worksheet tab an select all sheets, make your changes then right click on sheet tab and ungroup sheets -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Intuit" wrote in message ... Hello all, I'm new to this forum and it looks like this may be the place I need to be to find an answer to my question. I have a workbook that contains multiple worksheets. My goal is to enter data into one worksheets and have that data automatically transfer and update all the other worksheets with the same data so I don't have to enter it into each worksheet. Anyone know if this is possible? Thanks in advance! -- Intuit ------------------------------------------------------------------------ Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901 View this thread: http://www.excelforum.com/showthread...hreadid=505762 This worked great! Your awesome! You just saved me a possibly big headache! Thanks!!!!!!!!!!!! -- Intuit ------------------------------------------------------------------------ Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901 View this thread: http://www.excelforum.com/showthread...hreadid=505762 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
Line chart from multiple worksheets | Charts and Charting in Excel | |||
Adding and Naming Multiple Worksheets | Excel Worksheet Functions | |||
Update multiple worksheets | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |