Input data to a specific record in a S/sheet

**bajdr47** · 06-07-2011, 05:37 AM

Morning Everyone,

i was hoping that someone could help with a problem i have.

i have a spreadsheet containing a record on each row 8 columns across.

the first column conatins a unique reference for the record.

i think i need a macro to achieve this next part.

on a separate sheet i want to be able to input a Unique Ref. No. and also input a date for instance, and then activate a macro that will locate the record in the first sheet and copy the date into the date column for the record

Many Thanks in Advance

**royUK** · 06-07-2011, 05:39 AM

VLOOKUP might work, but attach an example workbook

**Roger Govier** · 06-07-2011, 05:41 AM

Hi

You need to use Advanced Filter.
Full instructions can be found here.
http://www.contextures.com/xladvfilt...html#ExtractWs

**bajdr47** · 06-07-2011, 07:18 AM

This is a sample sheet.

I want to be able to select a "urn" and type in the date and pass/fail

use a command button for example to run a macro to input the date and pass fail to the appropiate record in the data sheet

the finished data sheet will conatin 5000 approx

**Roger Govier** · 06-07-2011, 07:45 AM

hi

No need for any Command Button or any macro.
Just type the URN value in C4 and the results will appear in F4 and I4

In F4
=IF(C4="","",INDEX(data!$D:$D,MATCH(Input!C4,data!A:A,0)))

in I4
=IF(C4="","",INDEX(data!$G:$G,MATCH(Input!C4,data!A:A,0)))

**bajdr47** · 06-07-2011, 09:02 AM

Sorry about explanation,

i want to type in the URN to C4, and type in the date and pass/fail in f4 and i4,
then have the data in f4 and i4 copied to the DATA sheet, to the correct row.

**Roger Govier** · 06-07-2011, 09:53 AM

Hi

Attached workbook does what you want.

Code in module 1 - CopyData is triggered by clicking the Input button on Input sheet.

Please Login or Register  to view this content.

**bajdr47** · 06-07-2011, 12:48 PM

Roger,

From one Celt to another.......your efforts and patience are very much appreciated....works perfectly...i must now try and see if i can figure out how..

**bajdr47** · 06-14-2011, 10:49 AM

Ladies and Gents,

i apologies for this.

the macro supplied works perfectly.

i didn't input the exact criteria..as a result it didn't work for me ...My fault

the sample sheet shows the URN as seguential numbers...in reality they are non sequential and includes Letters.

also the column containing theURNS is in the 3rd Column not the 1st.

Can someone assist me with a modified Macro Please....again apologies.

BR