Might be a stupid question

[Jrose85]

We keep our database in Excel and update it as needed. However we have different sheets for different form purposes. Such as one form for applications sent, mail received for a certain client, etc. We fill in the persons name, client id, specific dates, etc., on each sheet. But what I was wondering is, is there a way to transfer the data from one sheet to another. Because each sheet contains thousands of cells, and id rather not have to individually look up the person's info, and copy and paste the info. I may be missing an easy way to do this but I'm blanking at a solution. Any help is appreciated.

 

[Sektor]

Your question is too vague. An example of your data is welcome as well as more detailed description of what you're trying to accomplish.

 

[jim may]

Check out the formula: VLOOKUP() in HELP...

 

[Jrose85]

A sample of the data is: Column A: Date form was sent, Column B ID, Column C Client Last Name, Column D Client First Name, Column E Client Personal ID, Column F: type of form, Column G DOB, Column H Gender, etc.

Each sheet contains that info, but some of the columns have different information, such as the form type may be different or dates may differ.

What id like to be able to do is copy specific client info, like their ids, names, DOB, etc into another sheet, but have it go to the appropriate person. Because the information isn't sorted alphabetically, its by date. Otherwise Id have to copy and paste individual information from one sheet to the next. Not sure if I made that clear or more confusing.

 

[Sektor]

ADVERTISEMENT

Without actual data, it's hard to say. But I would use VBA to search clients.

 

[Jrose85]

I unfortunately cannot post the data as it contains highly sensitive data. I'm unsure how to use VBA but I'll google it.

 

[Sektor]

ADVERTISEMENT

You could use Find method of Range object.
Equally, you could use any worksheet function by using WorksheetFunction object.

 

[Jrose85]

Yea I've been using the find option. Which is helpful.
But unfortunately I am having to complete work that a former coworker didn't do. Which ends up being thousands of cells of information they failed to complete. Guess I'll have to do it using the Find option for each one .
I appreciate your help. Thank you

 

[Sektor]

But Find can be used not only as Cells.Find (which forces scan whole sheet), but you can limit the search by Range:

Dim cell As Range
Set cell = Range("B:B").Find("Jackson") '//Search in column B
If Not cell Is Nothing Then
'//Jackson is found. Do the rest of work.
End If

 

[Yourself93]

What do you use to search? If you use their ID then search with vlookup.

Ex. Vlookup(123,'Sheet1'$B$2:'Sheet1'$Z$2,2) This would pull column C info for associated ID. You need to type in the ID you need, but you could also simply set it to Vlookup(F2,'Sheet1'$B$2:'Sheet1'$Z$2,2) and put a bunch of ID's you are looking up in column F. Drag down and it will look them up.