L/P

Posts: n/a

Find and copy??

Have the below formula but need to replace the dates (January) with
corresponding date across top of work sheet., Febuary, March, etc.etc.

Is there a way to do it w/o retyping, and making mistakes?

Thanks,
L.

=IF(SUM('January 2005'!C16,'January 2005'!E16,'January
2005'!G16)=0,"",IF(SUM('January 2005'!C16,'January 2005'!E16,'January
2005'!G16)='January 2005'!$B16,"P","X"))

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
Automatic backup copy	craigq	Charts and Charting in Excel	2	April 11th 05 04:57 PM
How do I edit, copy and paste text in excel cells?	floridactyl	New Users to Excel	2	December 31st 04 03:52 PM
why can't excel do a simple find and copy row from a worksheet to.	rasman	Excel Worksheet Functions	2	December 28th 04 05:49 PM
Past Link then copy	Hal LEGERE-Steam Guy	Excel Discussion (Misc queries)	3	December 23rd 04 02:58 PM
Find duplicates	R. Choate	Excel Discussion (Misc queries)	5	November 28th 04 10:14 PM

All times are GMT +1. The time now is 08:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us