Info Filtering

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

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---
 
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
 
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.
 
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---
 
Back
Top