View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toni Marie Toni Marie is offline
external usenet poster
 
Posts: 1
Default populate duplicate data into a spreadsheet

Is there a way to populate duplicate inventory data into a spreadsheet
without typing it?
For example...
Qty 10 blouses @ 9.99 2 Sm, 4 Med, 4 Lg Is there a formula available
so that the word 'Blouse' appears 10 times in Col A on lines 2-11
'9.99' appears 10 times in Col B lines 2-11
'Sm' appears in Col C lines 2-3
'Med' appears in Col C lines 4-7
'Lg' appears in Col C lines 8-11

I'd be grateful for any ideas and/or help. thanks.
--
Toni Marie