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.

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.

" wrote:

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.