Hello
I've mostly dealt with macros that go from A to B to C without having to stop for user input so this is a new thing for me.
What I'm doing is adding in names against a record, but it's not a specific name it could be A or B. At the moment I'm doing copy/paste and the repetition is causing physical problems.
Here is an example:
[pre ]L M
2 Mary Smith
3 John Brown
4 Matthew White
5 Amy Jones
[/pre]
Where at this point column L is all blank.
the result should be:
[pre]L M
2 John Brown or Matthew White Mary Smith
3 Mary Smith or Amy Jones John Brown
4 Mary Smith or Amy Jones Matthew White
5 Jon Brown or Matthew White Amy Jones
[/pre]
I'm wondering about using concatenate : =concatenate(M2," or ",M5) to give the result "Mary Smith or Amy Jones" I could use a small macro to type in the formula each time, but what I'd want to do is have it stop and ask me what cell number to use, and I could type M2 or click in the appropriate cell.
The way these are organised, there is no guarantee that the names would appear in a orderly fashion. These are actually birth marriage and death records I'm trying to organise.
Can someone point me in the right direction? There are over 30,000 lines in this one spreadsheet and I've a dozen more spreadsheets, so anything that will help speed things up and lessen the RSI would be appreciated!
thank you for helping
____________
Pendle
I've mostly dealt with macros that go from A to B to C without having to stop for user input so this is a new thing for me.
What I'm doing is adding in names against a record, but it's not a specific name it could be A or B. At the moment I'm doing copy/paste and the repetition is causing physical problems.
Here is an example:
[pre ]L M
2 Mary Smith
3 John Brown
4 Matthew White
5 Amy Jones
[/pre]
Where at this point column L is all blank.
the result should be:
[pre]L M
2 John Brown or Matthew White Mary Smith
3 Mary Smith or Amy Jones John Brown
4 Mary Smith or Amy Jones Matthew White
5 Jon Brown or Matthew White Amy Jones
[/pre]
I'm wondering about using concatenate : =concatenate(M2," or ",M5) to give the result "Mary Smith or Amy Jones" I could use a small macro to type in the formula each time, but what I'd want to do is have it stop and ask me what cell number to use, and I could type M2 or click in the appropriate cell.
The way these are organised, there is no guarantee that the names would appear in a orderly fashion. These are actually birth marriage and death records I'm trying to organise.
Can someone point me in the right direction? There are over 30,000 lines in this one spreadsheet and I've a dozen more spreadsheets, so anything that will help speed things up and lessen the RSI would be appreciated!
thank you for helping
____________
Pendle