B
Barry Lennox
I have a spreadsheet with names in column A and dates along row 4. I now
realise that the maximum number of names I will have will be 100 to 150 but
over say 10 years there will be 2500 t0 3000 dates. Therefore I need to
transpose the data.
My problem is that the list of names refers to a master sheet with names
and addresses, set out conventionally. The list of names is sorted
alphabetically and changes with additions and deletions. Is there a quick way
to arrange that cell C4 on the current worksheet = A3 on the master sheet
then D4 = A4, E4 = A5, F4 = A6 etc. without having to insert each value one
at a time
Barry
realise that the maximum number of names I will have will be 100 to 150 but
over say 10 years there will be 2500 t0 3000 dates. Therefore I need to
transpose the data.
My problem is that the list of names refers to a master sheet with names
and addresses, set out conventionally. The list of names is sorted
alphabetically and changes with additions and deletions. Is there a quick way
to arrange that cell C4 on the current worksheet = A3 on the master sheet
then D4 = A4, E4 = A5, F4 = A6 etc. without having to insert each value one
at a time
Barry