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.
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.
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.
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---
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
