# Excel Automatic Data Updating

#### shmuelsash

##### New Member
I have an excel list of about 5000 alumni with numerous columns of different information.

I frequently use this list to create smaller more focused lists (e.g. just from a specific location). These lists are then shared on google docs to a small group of staff that use the information to call the alumni and then update the information into the document.

Is it possible that the information that is entered into these smaller lists can be automatically reflected into the main document? If yes, how?

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### oldbrewer

##### Well-known Member
say you have a new address for fred in a sub list, then the easiest way is to use a simple macro to copy ALL Fred data from the small list to the master list

#### oldbrewer

##### Well-known Member
 bill 19 high st anytwn sid 44 station road leicester sid 44 station road leicester fred 99 high st anytwn this macro copies the new sid info into the master list For j = 1 To 5 If Cells(j, 11) = "" Then GoTo 100 For k = 1 To 5 If Cells(k, 1) <> Cells(j, 11) Then GoTo 50 Cells(k, 2) = Cells(j, 12) Cells(k, 3) = Cells(j, 13) 50 Next k Next j original sid info 100 End Sub sid 39 high st anytwn

<colgroup><col><col><col><col span="8"><col><col span="2"></colgroup><tbody>
</tbody>

#### shmuelsash

##### New Member
 bill 19 high st anytwn sid 44 station road leicester sid 44 station road leicester fred 99 high st anytwn this macro copies the new sid info into the master list For j = 1 To 5 If Cells(j, 11) = "" Then GoTo 100 For k = 1 To 5 If Cells(k, 1) <> Cells(j, 11) Then GoTo 50 Cells(k, 2) = Cells(j, 12) Cells(k, 3) = Cells(j, 13) 50 Next k Next j original sid info 100 End Sub sid 39 high st anytwn

<tbody>
</tbody>

I hope you'll be my savior! Where do I put this macro? I dont know how to use macros...

#### oldbrewer

##### Well-known Member
do this on a new spreadsheet

tools, macro, record new macro

ok

select A1, stop the macro

tools, macros macro1, edit

you will see one line of code starting Range

cursor to left of R delete the line of code
paste my code in

delete the last end sub

then back to spreadsheet, tools, macro, macro1, run

Last edited:

Replies
0
Views
195
Replies
0
Views
225
Replies
1
Views
203
Replies
0
Views
259
Replies
0
Views
234

1,191,633
Messages
5,987,783
Members
440,110
Latest member
albertod8

### 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.

### Which adblocker are you using?

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

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