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

Coates1991

New Member
Joined
May 29, 2015
Messages
3
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
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
57,633
Office Version
  1. 365
Platform
  1. Windows
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).
 

Chrisdontm

Well-known Member
Joined
May 4, 2015
Messages
810
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
 

Watch MrExcel Video

Forum statistics

Threads
1,133,243
Messages
5,657,576
Members
418,401
Latest member
B_A_M155

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top