About Us

MattShoreson[_126_]

For both site and locality, how about this...

Application.VLookup(range("F6"), Worksheets("List").Range("B3:C5"), 2,
False)

--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=563633

thegooner[_7_]

Excellent.

That worked. Last question, how do I insert the new data into a cell?

The worksheet is called "data" and the cell reference is held under
varaibales ("x" and "the value") and the data to input is held i
varaible "now".

This didn't work:

Worksheets("Data").Cells(x, thevalue) = now

Thanks agai

--
thegoone
-----------------------------------------------------------------------
thegooner's Profile: http://www.excelforum.com/member.php...fo&userid=3661
View this thread: http://www.excelforum.com/showthread.php?threadid=56363

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

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
Need syntax for RUNning a Word macro with an argument, called from an Excel macro	Steve[_84_]	Excel Programming	3	July 6th 06 07:42 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

Menu

About Us