Posted to microsoft.public.excel.programming

Hugh Askew Hugh Askew is offline

external usenet poster

Posts: 4

lookup,copy, paste macro??

I have searched Google and the groups for this, but unable to find.

Need a macro to take a entered value in any cell on Sheet 1, column A,
look up that value on Sheet 2, column A, go one row over to col. B,
copy the cell, then paste it into Sheet 1, column B, next to the
entered value.
Just like Vlookup, only copypaste .
Need to paste the cell contents, not just values.

any and all help GREATLY 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
Copy and Paste Macro	ABelect	Excel Discussion (Misc queries)	1	April 15th 10 11:24 PM
copy and paste using macro	kate	Excel Discussion (Misc queries)	3	May 22nd 07 07:41 PM
Copy Paste macro	GWB Direct	Excel Discussion (Misc queries)	2	May 9th 05 03:31 PM
Macro Copy/Paste Help	esi	Excel Programming	2	October 8th 03 11:15 AM
copy/paste macro	PLN	Excel Programming	2	July 21st 03 10:15 PM

All times are GMT +1. The time now is 09:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us