View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wack wack is offline
external usenet poster
 
Posts: 1
Default Macro for Excel spreadsheet into Access table

How could I take a spreadsheet with thousands of records,
whose last column of cells has comments attached to that
cell?
Example
First Last HEight(comment like 5'8", 5'9", 5'10",etc.)
John Jones 5'10"

I'm trying to pull the comments with each record, possibly
repeating the record with a new choice from the comments
like a different height, say 5'8" for example.
Would this be a macro? and do I create it on the Excel
sheet or in Access? Thank you.