Info Filtering
 

How would I create a workbook, where information from a pervious workbook
would filter into the new workbook automatically?

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?

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?

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?

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?