Transferring Text

  • Thread starter Thread starter Ed O'Brien
  • Start date Start date
E

Ed O'Brien

I need to be able to send data from one worksheet to another. Sheet 1 is the
master and only sheet where data is entered. I have found out all cells have
to be set to "Text" - which is not a problem.

Sheet 1
Column A is Name
Column B is Date of Birth
Column C is the Surgery's name

Is there a way that when the Surgery name is entered in say C5 the row's
Name and Date of Birth can be sent to the next vacant row in say Sheet 3.

Because of the number of surgeries, it is not possible to set them up to
receive data from Sheet 1 - which is much easier, of course.

I thought of a 4th column with a surgery's number (01 to 21) when that
number may be used (rather than text) as the key to the transfer.

Can anyone offer me any advice on this?

TIA

Ed
 
Ed
What you want done is easy enough to do and would require VBA. I take
it that the destination sheet names are the names of the surgeries. Is that
correct?
You suggest using numbers instead of surgery names. Using the surgery
name is no problem at all. I would suggest, though, that you select the
surgery name from a Drop-Down list of surgery names rather than rely on
spelling the name correctly. The VBA code would be stumped if the surgery
name was misspelled.
I don't know where you got the idea that you should set the cells to "Text".
From what you say about what you have and what you want to have, you should
leave all cells set to "General". Excel will automatically reset the date
cell to "Date" when you enter something that looks like a date.
If you wish, send me your file or an example of your file (I need just
the data layout, surgery names, etc.) and I'll set it up for you. My email
address is (e-mail address removed). Remove the "nop" from this address. HTH
Otto
 
Thanks, Otto.

It's way past midnight here now so, if you're okay, I'll try and set out
something tomorrow and send it to you. I haven't a clue about VBA, though,
so I hope it's not too difficult. At my age (70), steep learning curves hurt
like hell!

Best wishes,

Ed
 
Back
Top