Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi Folks, I wonder if someone can help me. I am building a spreadsheet that uses a master table of PCs on an estate that are being upgraded. PCs P4 and above dont need an upgrade, hence if they are already out there, all they need is our new build installing. If it is a P4, we take the old P4 off the estate and replace it with a new like for like model. When this happens, the one coming off the estate is reuseable, so what I want to do, is to use a formula that identifies this PC by model (within a scope of about 10 P4s') in a particular column, then sorts by Dept no and then it copies that record to another table such as a buffer stock table that updates dynamically. I suspect its part of the IF function but beyond me I am afraid. I am more than happy to send the sheet if anyone needs it, but essentially its the function or string I need to be honest. Many thanks Mike -- kapiliary ------------------------------------------------------------------------ kapiliary's Profile: http://www.excelforum.com/member.php...o&userid=33424 View this thread: http://www.excelforum.com/showthread...hreadid=532403 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
copying sheet references that refer to a cell in the preceding she | Excel Worksheet Functions | |||
Copying information and calculations from one sheet to another she | Excel Worksheet Functions | |||
Copying and Pasting from One Sheet to Another | Setting up and Configuration of Excel | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |