Posted to microsoft.public.excel.worksheet.functions

EÃ¡n[_2_]

external usenet poster

Posts: 30

Formula or Macro

I need to write a formula or macro that would allow me to do the follow:

If cells $F$3:$F$70 contain "Very High" and cells $G$3:$G$70 contain "Very
High" in sheet1 I need the whole line A:K to be repeated on sheet2.

How do I do it please?

Thanks

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
MACRO or FORMULA	CHENG28	Excel Worksheet Functions	3	November 19th 09 03:21 PM
How do I add a formula to a macro?	Aline	Excel Discussion (Misc queries)	4	July 24th 08 07:05 PM
Formula or Macro	Meadowlark	Excel Discussion (Misc queries)	5	February 27th 08 03:59 PM
Macro with formula	orquidea	Excel Worksheet Functions	3	December 5th 07 08:53 PM
Macro and Formula	strung	Excel Worksheet Functions	3	September 6th 05 02:43 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us