View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gabbon
 
Posts: n/a
Default how do I insert a cell based on its match with an adjacent cell?

Hi,
There's got to be a way to do this (mail merge style perhaps...)
I would like to insert the entry/ies under a heading in a table in one
worksheet whenever that heading matches the data entered in a separate
worksheet.
Presently I can find no way to do this in Excel.
Please can you suggest a way to do this...
Thanks
G