| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Info Filtering
How would I create a workbook, where information from a pervious workbook
would filter into the new workbook automatically? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Info Filtering
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--- -- RyGuy "Kevin" wrote: How would I create a workbook, where information from a pervious workbook would filter into the new workbook automatically? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Info Filtering
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 "ryguy7272" wrote: 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--- -- RyGuy "Kevin" wrote: How would I create a workbook, where information from a pervious workbook would filter into the new workbook automatically? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Info Filtering
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. On Feb 8, 3:25 pm, Kevin wrote: 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 "ryguy7272" wrote: 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--- -- RyGuy "Kevin" wrote: How would I create a workbook, where information from a pervious workbook would filter into the new workbook automatically? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Info Filtering
Take a peek at this:
http://www.rondebruin.nl/tips.htm Your answer should be in he 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--- -- RyGuy "ilia" wrote: 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. On Feb 8, 3:25 pm, Kevin wrote: 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 "ryguy7272" wrote: 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--- -- RyGuy "Kevin" wrote: How would I create a workbook, where information from a pervious workbook would filter into the new workbook automatically? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
| varying validation info based on preceding info | Excel Discussion (Misc queries) | |||
| Tables, How do I make new info push existing info to the next row? | Excel Worksheet Functions | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Hybrid Mode
