View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roady Roady is offline
external usenet poster
 
Posts: 69
Default Auto pull 3 cells into 1 cell at different location? (Excel)

Hi:

If I have 3 cells (each in different column) and each with data, is it
possible to pull the data into one cell at a different location? In addition,
can you do this if one of the columns is a drop down selection? For example:

Column A- Star Wars
Column B- Luke
Column C- "I am your father"

On the cell it pulled to, it would look something like:

Star Wars; Luke; "I am your father"

thanks!