vba macro - search ID, copy, paste

**sgp** · 10-30-2011, 02:17 PM

Hi All

The coding for my macro button does not seem to work properly, I have the following worksheets:

- SiteDetails - this worksheet acts like a user form
- SiteRecords - This is where the information is to be saved based on the Site ID

The code currently pastes some information based on the correct ID but does not paste all the information...I have attached an example to illustrate my point.

The highlighted yellow cells is the information I would like to macro to pick up, also would be helpful if the information in the check box (at the bottom of the worksheet) could also be copied through.

Much Appreciated!

**rylo** · 10-30-2011, 09:15 PM

Hi

Couple of things.

1) Some of the array references don't point to the cells with data. j6 should be h6. You will have to correct all of these.
2) Some of the items have been missed. J16 for the mobile number is one.
3) You will have to ungroup all the controls, (some twice) and then link them to a cell. Once you have done that, then you will have to include the cell references in the array.
4) Once you have done that, and got all the items in the correct order, then you will have to change the 11 in

r.Resize(, 11)

to the correct number. Didn't work it all out, but would be somewhere around 95 ish

HTH

rylo

**sgp** · 10-31-2011, 07:00 AM

Thanks for all your help!!!!!

Originally Posted by rylo

Hi

Couple of things.

1) Some of the array references don't point to the cells with data. j6 should be h6. You will have to correct all of these.
2) Some of the items have been missed. J16 for the mobile number is one.
3) You will have to ungroup all the controls, (some twice) and then link them to a cell. Once you have done that, then you will have to include the cell references in the array.
4) Once you have done that, and got all the items in the correct order, then you will have to change the 11 in