In the mornings I am given a couple of hand filled out forms for job sites. I
have a template saved to my computer and I fill out the basic info, all in
different tabs on the same book, and send it back to our QC guy. The problem
comes up when later in the day a job calls in. Now i need to make the same
sheet and get it into that work book that hes is already editing so i can not
jus send him the whole thing over because he'll lose his work. I have drop
down lists in the sheets. If I just 'Move Sheet' to the new work book then
the lists stop working. I am looking for an efficent way to be able to make a
sheet from my computer, email it to him, have it added to the orginal
workbook i made that morning while still functioning correctly. Any
suggestions????

Hi,

Open your workbook.

1. Choose Window, Arrange, Tile and then resize the window so you can see a
blank area behind it.
2. Select the sheet you want to copy, hold down the Ctrl key and drag it to
the blank area, releasing the mouse first. You have a copy of the sheet in
its own workbook.
3. Send this one sheet workbook to the QC guy and tell him to open both
workbooks - the original one and this new single sheeted one.
4. Choose Window, Arrange, Tile
5. Activate the single sheet file
6. Drag and drop the sheet tab for that workbook to the original file.
This will move the sheet to the original workbook and the one sheet file will
disappear. (if he has saved it the saved copy still exists).

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"C Vi" wrote:

In the mornings I am given a couple of hand filled out forms for job sites. I
have a template saved to my computer and I fill out the basic info, all in
different tabs on the same book, and send it back to our QC guy. The problem
comes up when later in the day a job calls in. Now i need to make the same
sheet and get it into that work book that hes is already editing so i can not
jus send him the whole thing over because he'll lose his work. I have drop
down lists in the sheets. If I just 'Move Sheet' to the new work book then
the lists stop working. I am looking for an efficent way to be able to make a
sheet from my computer, email it to him, have it added to the orginal
workbook i made that morning while still functioning correctly. Any
suggestions????

I have 2007 I don't see a 'Window' anywere, sorry fairly new to this

"Shane Devenshire" wrote:

Hi,

Open your workbook.

1. Choose Window, Arrange, Tile and then resize the window so you can see a
blank area behind it.
2. Select the sheet you want to copy, hold down the Ctrl key and drag it to
the blank area, releasing the mouse first. You have a copy of the sheet in
its own workbook.
3. Send this one sheet workbook to the QC guy and tell him to open both
workbooks - the original one and this new single sheeted one.
4. Choose Window, Arrange, Tile
5. Activate the single sheet file
6. Drag and drop the sheet tab for that workbook to the original file.
This will move the sheet to the original workbook and the one sheet file will
disappear. (if he has saved it the saved copy still exists).

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"C Vi" wrote:

In the mornings I am given a couple of hand filled out forms for job sites. I
have a template saved to my computer and I fill out the basic info, all in
different tabs on the same book, and send it back to our QC guy. The problem
comes up when later in the day a job calls in. Now i need to make the same
sheet and get it into that work book that hes is already editing so i can not
jus send him the whole thing over because he'll lose his work. I have drop
down lists in the sheets. If I just 'Move Sheet' to the new work book then
the lists stop working. I am looking for an efficent way to be able to make a
sheet from my computer, email it to him, have it added to the orginal
workbook i made that morning while still functioning correctly. Any
suggestions????