Need data in cells on one row extracted to multiple rows

[cooper.jeffrey.m]

I am very new to VBA, but I have quite a bit of experience in Excel.
I have data in multiple cells on one row of a spreadsheet that I need
to extract and place on multiple rows (in a new worksheet). My
situation is this: I get a "daily sales report" with one row for each
day. On each row are numbers from different sales categories. I need
to create an import file to get this info into the accounting
system...this requires me to take each of those categories and make a
separate row for each one but using the same date as the row from
which they were extracted. Does anyone know how I should approach
this? What function do I use? I just need a lead to help me get
started. Thanks.

 

[Joel]

Give more info on format of spreadsheet.
1)Which column has the date
2)Which columns need to be repeated on new rows besides date.
3) which columns have the sale catorgories.