excel macro illiterate - need to copy information out of sheets

**darknature** · 06-03-2011, 09:31 AM

need to copy information, name, date, time out of one sheet and into another. I have no experience with macros in excel. Appreciate any help you might give.

**nohero** · 06-03-2011, 09:45 AM

Not sure the scenario you're working with but it sounds like a =vlookup formula you need.

=VLOOKUP(A1,SheetTwo!A:G,2,FALSE)

What this does is:
-Looks at a value in the cell you specify on your current sheet (A1 in the example above)
-Looks at a range in another sheet you specify (named SheetTwo above, range is columns A through G.
-Looks for the corresponding value in the row it found based on which column you need (column 2 in your range in the example above)
-FALSE only indicates that it needs an exact match when looking for the value

So you'd have a name on your current sheet and you're trying to grab all associated info with that name on your 2nd sheet and bring it over. So if you put a name in cell A1 on your first sheet and this formula in cell B1, it will look for the name anywhere in columns A:G on your 2nd sheet, when it finds it in column A on the 2nd sheet it will return the value of the cell next to it in column B (if you put a 3 instead of 2 in the formula it would return the value of the 3rd column, C).

Is this at all what you were looking for?

**nohero** · 06-03-2011, 09:56 AM

Oh I just noticed it said macro. Do you want to push a button and have it just copy all the info from one sheet to another? I think I'd need more specific information of what you are needing because it sounds like a copy & paste.

The other possibility is you are looking for a userform. A userform will create a box with information fields for the user to fill out and submit, this info then gets placed into another sheet. If this is the case there are some great step by step userform creation instructions out there, such as:

http://www.contextures.com/xlUserForm01.html

**darknature** · 06-03-2011, 10:00 AM

This looks about what I need, thanks for the great break down! Very helpful!

Yeah basically I need it to search a specific name, date and time - then take the info it finds that meets that criteria and copy it out to another excel sheet.

**royUK** · 06-03-2011, 11:57 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST