Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy cells into worksheets via pull-down
To give some insight I'm basically transferring data from a Sales order
to multiple Job Sheets and Work Orders ( 5 different worksheets). I have a pull down with three worksheet choices located in the Sales Order sheet. This pull down will determine what information will go to different sheets, I have 15 of these pull downs for each possible item on the Sales Order. I would like to send 7 different values from the Sales Order to one of the three sheets, the pull down value will determine this. My question is how can I "link" or "send" cell data to the other sheets based on which worksheet is selected in the pull down, and how can I sort it by the Due Date on each of these sheets. The Due Date will come from the in the Sales Order. Thanks for the help, Chad |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy cells into worksheets via pull-down
This sounds like a great macro to write-- you could use advanced filter to
pull out the data. Start the advance filter on the sheet you would like the data to be; Choose the criteria and check that you want the data in a different location rather than sorting in place. A simple sort will place the data in date order, be sure to build the sort into a macro.. anitadai " wrote: To give some insight I'm basically transferring data from a Sales order to multiple Job Sheets and Work Orders ( 5 different worksheets). I have a pull down with three worksheet choices located in the Sales Order sheet. This pull down will determine what information will go to different sheets, I have 15 of these pull downs for each possible item on the Sales Order. I would like to send 7 different values from the Sales Order to one of the three sheets, the pull down value will determine this. My question is how can I "link" or "send" cell data to the other sheets based on which worksheet is selected in the pull down, and how can I sort it by the Due Date on each of these sheets. The Due Date will come from the in the Sales Order. Thanks for the help, Chad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enter data once... copy to multiple cells on other worksheets | Excel Discussion (Misc queries) | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
Using Command Button to copy cells | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |