VBA retrieves a value from a closed workbook

Microsoft Excel 2007 home and student
February 26, 2010 at 12:21:13
Specs: Windows XP
I need a macro to look up for text in Column A ( Book1 sheet 1 ) equaling "CAT" or "DOG" in Column F (in closed Book2. Sheet1) and copying (retrieves ) the Cells Value , Dx,Hx of the corresponding found Fx cell to Sheet1 Book1 in column B,C for all the values in column A

See More: VBA retrieves a value from a closed workbook

Report •

#1
February 26, 2010 at 18:06:10
re: "I need a macro to look up for text in Column A... "

And we hope you find one.


Report •
Related Solutions


Ask Question