Finding and copying data from one sheet to another

Hi everyone,

I'm new to the forum and new to VBA as well, so I really hope that I could receive good advice and help here from seasoned/experienced programmers.

If you refer to the attachment, basically what I am trying to do is to retrieve information from 'ClientDB' and plucking some of those data into 'UpdateClient'. However, I don't know how to write any code to read the cell-link and trigger a macro for the correct company. When I tried to record a macro, what I did was to copy and paste data from 'UpdateClient' into row16 of 'ClientDB'. But this is terribly flawed cos it doesn't lookup the correct client in ClientDB and effectively wipes out some other client's details.

Is there a way to rectify this and could anyone help, perchance? thanks in advance!!!

sab

The attached might help. I'm afraid that I mucked up your data base with testing values.

The routine UpdateMaybe should be linked to the Update button on UpdateClient. It finds the client row from the index of the dropdown. Since the dropdown is loaded from the ClientDB, the restoration should match. I couldn't find Departments or Client ID's on the sheet ClientDB.

Please Login or Register  to view this content.

would anyone be able to help?

Code preserves its indending and is easier to read if one wraps one's code. (Hence the site's rule.) Please do so.

This line is a problem.

Please Login or Register  to view this content.

In the first file, I was reading the ListIndex of the ComboBox to get the row number.
But Text boxes don't have indices and Forms menu textboxes aren't controls (no Control Format).
To get the contents of Text Box 17, this syntax would be used

Please Login or Register  to view this content.

Its not clear what is supposed to be in that text box, it looks like you are using it as a command button.

You may want to use find the row number with,

Please Login or Register  to view this content.

hi mike, thanks for your response!!

i wanted to wrap the code but i didn't know how.... i missed the button and only saw the quote button sorry!

anyway, it's not working for me somehow

what i have is this:

Please Login or Register  to view this content.

it says the bug is in the new line I added in:

Please Login or Register  to view this content.

yikesss :S


-sab

The code you added in refers to the entry in the text box. It doesn't do anything with that value. Is as if you added the line

Please Login or Register  to view this content.

.
What happens if you omit that line, but retain the

Please Login or Register  to view this content.

?

yikes mike, nothing happens!!!

The routine I posted was to get data from UpdateClient and put it in ClientDB.

Your modification is trying to move data from Update Job and move it to Job List. The cells references have to be changed to match the new task.

hi mike,

i did change the cell ref but have no idea why nothing is happening!

can i just clarify..

If I am moving from "Update Job" to "Job List", then clientrow is "Update Job" and toSheet is "Job List" right?

so

Please Login or Register  to view this content.

means shifting the data from cell (row 22, column 3) from "Update Job" to column 1 of "Job List"?

Yes, that's the right interpetattion of the syntax.

You might want to put

Please Login or Register  to view this content.

in the routine to find out if its working right.