Formula to copy rng of cells where (value is met) to anther sheet

Exit Advantage

Posts: n/a

Formula to copy rng of cells where (value is met) to anther sheet

I have one sheet that contains info for all three office locations. One
column on this sheet contains location ID. I want to create three seperate
sheets for each office, then have a formula that will copy the info from a
row on the primary sheet to respective office sheet. Office locations are 28,
44 and 68. So if column c on main sheet =28 then copy all rows where column c
= 28 to 28 sheet, etc with 44 and 68. Please help, I can't figure it out.

Thanks,
Brian

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
copy values generated by conditional formula in one sheet to the other work sheet as values	ramana	Excel Worksheet Functions	1	October 5th 05 01:04 PM
copy values generated by conditional formula in one sheet to the other work sheet as values	bobby	Excel Discussion (Misc queries)	1	October 5th 05 12:18 PM
Edit / Move or copy sheet stopped working in Excel 2003	kris2u	Excel Worksheet Functions	0	October 4th 05 08:20 PM
Formula works in some cells, doesn't in other	Wowbagger	New Users to Excel	13	June 30th 05 03:21 PM
Howdo U copy a formula down a column, that uses data in another w.	Need Help pasting a formula	Excel Worksheet Functions	1	February 25th 05 06:04 PM

All times are GMT +1. The time now is 05:23 PM.

Menu

About Us