help with macro - ExcelBanter

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

help with macro

Hi
I need help to create a macro which will look in
column "Z"
and if any cell in this column has value 1 then do this:
1) On the entire row with offset put in column "K"
current date
2) Entire row Copy-Paste Special-Values
3) Entire row change value 1 in column "Z" with the
formula: =IF(sub!C1=6,1,"")
Any help is highly appreciated.

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 recorded... tabs & file names changed, macro hangs	Steve	Excel Worksheet Functions	3	October 30th 09 11:41 AM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort	Gavin	Excel Worksheet Functions	0	May 17th 07 01:20 PM
how to count/sum by function/macro to get the number of record to do copy/paste in macro	tango	Excel Programming	1	October 15th 04 01:16 PM
macro to delete entire rows when column A is blank ...a quick macro	vikram	Excel Programming	4	May 3rd 04 08:45 PM
Start Macro / Stop Macro / Restart Macro	Pete[_13_]	Excel Programming	2	November 21st 03 05:04 PM

All times are GMT +1. The time now is 11:14 PM.

Menu

About Us