Excel Automatic Data Updating

[shmuelsash]

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?

 

[oldbrewer]

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]

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]

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]

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
now do this again on YOUR spreadsheet
paste my code in

delete the last end sub

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