Creating a MACRO that will copy values from one sheet to another. HELP!

[Coates1991]

Hello,

I'm new to creating macros and I've been playing around trying to make one for hours without any luck.

I have two sheets on my Spreadsheet. "Start" and "Register"

What I need the macro to do is as follows -


Search column B on sheet "Register" for a value that is entered into cell U7 on sheet "Start"

If no value is found then a message displays 'No value found'

If the value is exactly the same as the value entered on U7, then the macro copies the value on sheet "start" in U8. And copies that value into column "P" in the exact same row as the value "U7" that was found on sheet "Register"


So this is how I dream it will work -

On the "Start" sheet I enter a serial number in U7 for example 001, and a date returned (e.g. 29/05/15) in cell U8. I then click the update button which is hopefully linked to the above macro.

When I click that button the macro searches column B on sheet 'register' for serial number 001. When 001 is found the macro will copy the date from cell U8 on sheet 'start' (29/05/15) and copy that date into column "P" on sheet 'Register' in the exact same column as 001 was found. (So if 001 was found on sheet 'Register' in cell B12, the macro will copy the date in U8 on sheet 'Start' into cell P12 on sheet 'Register'.

If someone could help me on the above issue you would be a lifesaver!

As we have 1000s of serialised items than are lent out it would save days going through records if a macro could find and populate the entered return date.

I hope the above makes sense.

Regards,

Jack

 

[Joe4]

Cross-posted: MACRO. Please help!

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).

 

[Coates1991]

Sorry for any mistakes. This has been cross posted here

[/COLOR]http://www.excelforum.com/e...1085469-macro-please-help.html[COLOR=#3e3e3e]

An answer has not yet been received on this forum.

 

[Chrisdontm]

Jack, I am not that good with VBA, but this should help you find the location of the matching row... To post the row number on either page use this formula; MATCH(Start!$U$7,Register!$B:$B,0) To post where you want the date posted use this formula; ADDRESS(MATCH(Start!U7,Register!B:B,0),16,4) Maybe someone can take it from there. It will at least help you find it a little faster... ☺ Chris

 

[Coates1991]

Thanks everyone for the support.

This had been answered on another forum. Here is the link to the answer if anyone is interested.

A macro that will search a column for a value and copy the value to another sheet. [SOLVED]

thanks again.