Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is it possible to copy only selected items to another worksheet...
I would like to copy items from a worksheet that have been checked off and
move them into another worksheet automatically. I would like there to be a link between the 2 worksheets. Is this possible?? |
#2
|
|||
|
|||
Heather
I would say "yes" it is possible, but without more details hard to make suggestions. What does "checked off" mean to you? Post details so we would know how to identify the checked off cells. Go to Help and "linking" to see options for linking cells from one sheet to another. Gord Dibben Excel MVP On Mon, 28 Feb 2005 11:13:02 -0800, "HEATHERCOX" wrote: I would like to copy items from a worksheet that have been checked off and move them into another worksheet automatically. I would like there to be a link between the 2 worksheets. Is this possible?? |
#3
|
|||
|
|||
Hi Gord,
I inserted check boxes into an Excel spreadsheet. What I'm trying to do is have only the items that have been selected by the checkmark transfer over to another page in the workbook. We have a template that items that the customer wants to order are checked off, then what I would like is for those items to then be transferred to our contract, which is another worksheet in the same workbook. I would like this to be a link so that when our sales rep. checks off the item in the template, it automatically transfers to the contract. That way our sales rep doesn't have to cut and paste it all at the customer's home. Do you think this is something that can be done??? Thank you so much for all your help!!! I'm just learning all the in-depth stuff that Excel can do. It's pretty cool!! Thanks for all your help!! Heather Cox "Gord Dibben" wrote: Heather I would say "yes" it is possible, but without more details hard to make suggestions. What does "checked off" mean to you? Post details so we would know how to identify the checked off cells. Go to Help and "linking" to see options for linking cells from one sheet to another. Gord Dibben Excel MVP On Mon, 28 Feb 2005 11:13:02 -0800, "HEATHERCOX" wrote: I would like to copy items from a worksheet that have been checked off and move them into another worksheet automatically. I would like there to be a link between the 2 worksheets. Is this possible?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I tell Excel to take a selected item and copy it to anothe. | Excel Worksheet Functions | |||
How do I copy specific items to another worksheet? | Excel Worksheet Functions | |||
selected items flash | Excel Discussion (Misc queries) | |||
Copy and pasting graphs to PowerPoint | Excel Discussion (Misc queries) | |||
how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) |