| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros with variable data
Hi Gary:
I used your macro and it worked great....now, though, I want to create a macro to do almost the same thing, except I want it to retrieve more than 1 field of data for the person...Can I tweak this one to do what I want? I want it to say say: If "Doe, Jane" is found by auto-filter in Column A from Cell A2:A160 in Worksheet 2 , Take the data in Column A through Column L and copy to Worksheet 1 "Jane D" in Cells A4 to L14. How can i do that? You are terrific and I'm so new to this, I really appreciate it. -- jeannie v |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading data from another sheet where data is in variable cells | Excel Discussion (Misc queries) | |||
| Variable data | Setting up and Configuration of Excel | |||
| DATA > TABLE -- 2 variable data tables? | Excel Worksheet Functions | |||
| DATA > TABLE -- 2 variable data tables? | Excel Discussion (Misc queries) | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Threaded Mode
