populate duplicate data into a spreadsheet

  • Thread starter Thread starter Toni Marie
  • Start date Start date
T

Toni Marie

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.
 
You probably need a macro. You need to do two steps.

1) first rearange the data in table format

A B C D E
Qty Price Qty Sm Qty Med Qty Lg


2) Once you have the colunm format then create you multiple line output with
one blouse per line.

Maybe it would be better if you posted more lines of what you input looks
like and where is you input coming from? A text file?
 
Back
Top