 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008Info Filtering
How would I create a workbook, where information from a pervious workbook would filter into the new workbook automatically? There are several ways to do what you want to do, but you should probably give more information to better describe your specific scenario. Usually, the more detailed questions questiosn receive more detailed answers. Regards, Ryan---  SignatureRyGuy > How would I create a workbook, where information from a pervious workbook > would filter into the new workbook automatically? I would like to populate a new worksheet using all the information that I entered on the first one. What I want is to open up new workbook or worksheet, have the pervious workbook or worksheet that I worked in last carry over to the new leaving empty cells to enter new data in... Almost like a "copy workbook", but the formulas are already in there and not having to copy/paste every time I do. Kevin > There are several ways to do what you want to do, but you should probably > give more information to better describe your specific scenario. Usually, [quoted text clipped - 5 lines] > > How would I create a workbook, where information from a pervious workbook > > would filter into the new workbook automatically? You should save one with data entry fields empty, as a template file. .xlt for 2003 and earlier, and .xltx/.xltm for 2007. Then just double-click on the template file to open it. > I would like to populate a new worksheet using all the information that I > entered on the first one. What I want is to open up new workbook or [quoted text clipped - 17 lines] > > > How would I create a workbook, where information from a pervious workbook > > > would filter into the new workbook automatically? Take a peek at this: http://www.rondebruin.nl/tips.htm Your answer should be in here: Copy/Paste/Merge Examples If it is just one sheet, maybe you can try: right-click sheet tab, click 'Move or Copy, and then check off 'Create a copy'. Regards, Ryan--- SignatureRyGuy > You should save one with data entry fields empty, as a template > file. .xlt for 2003 and earlier, and .xltx/.xltm for 2007. Then just [quoted text clipped - 21 lines] > > > > How would I create a workbook, where information from a pervious workbook > > > > would filter into the new workbook automatically? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.