LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
kapiliary
 
Posts: n/a
Default Copying records to another sheet


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic column chart - copying from Sheet to Sheet. Marko Pinteric Excel Discussion (Misc queries) 1 April 10th 06 12:57 PM
copying sheet references that refer to a cell in the preceding she GBT Excel Worksheet Functions 1 March 24th 06 07:51 PM
Copying information and calculations from one sheet to another she HawksNest Excel Worksheet Functions 3 December 12th 05 05:17 PM
Copying and Pasting from One Sheet to Another RayRedSoxFan Setting up and Configuration of Excel 1 November 1st 05 12:50 AM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"