Hi
need a macro to copy qty information from all columns, to a different worksheet to 1 column
original worksheet each column represents a week range {which is the header]
basically
copy
item no to column A
description to column B
qty to column C [most important]
date to column D
change column D to a meaningful DATE value either by using the beginning date, or the end date
see sample attached
Need to transfer all data from the SALES sheet to DESIRED sheet
[original file has more than 80 columns & about 400 items.....]
Thanks
need a macro to copy qty information from all columns, to a different worksheet to 1 column
original worksheet each column represents a week range {which is the header]
basically
copy
item no to column A
description to column B
qty to column C [most important]
date to column D
change column D to a meaningful DATE value either by using the beginning date, or the end date
see sample attached
Need to transfer all data from the SALES sheet to DESIRED sheet
[original file has more than 80 columns & about 400 items.....]
Thanks