hi there
i am new at doing macro/vba and got assigned this thing to do.
basically, we have a spreadsheet, and there are 3 rows per group.
each group entry has to be copied over to a new sheet, but when copying the values from the source sheet, we need the values to be copied over to the new sheet - but on each line.
so for example, we have the first group, each group cell values must be on one line - when the next group arrives, it copies the values from that group to the next line and so on...
how do i go about doing this? i really need help!
thanks
i am new at doing macro/vba and got assigned this thing to do.
basically, we have a spreadsheet, and there are 3 rows per group.
each group entry has to be copied over to a new sheet, but when copying the values from the source sheet, we need the values to be copied over to the new sheet - but on each line.
so for example, we have the first group, each group cell values must be on one line - when the next group arrives, it copies the values from that group to the next line and so on...
how do i go about doing this? i really need help!
thanks
