I have a project that requires me to do some looping or {cursor} on a worksheet. [I have attached a mock up of this] I am not completely certain on how to proceed with this......if it was a database I would do a select and cursor the selections but I am not that comfortable with VB. Let me try to explain what I am needing to do and perhaps you gurus can suggest a direction or block of code I can build upon.
rawdata worksheet can contain thousands of records..........
first action copy rows from A:D to a new worksheet (Formated Data) starting at A2
Select all rows that contain a value in column E (rawdata)
Copy values A:D and paste at the bottom of Formated Data worksheet
Add the the E1 header value as the value for Formated Data column E all new rows.
Add the corresponding value from the Rawdata column E to the classvalue column in the formated data sheet.....
This must happen for 180+ attribute values.......some may be filled in some not. So I have to cusor through the rows that have date fill them in and go on to the next column select those values and do it again..........
At the end I will resort by the item number so the data will be grouped by the item number.........
I am just not sure how to accomplish the cursor.....loop and past portion.
any ideas anyone............
I hope I explained this well enough..........and in the right section.
rawdata worksheet can contain thousands of records..........
first action copy rows from A:D to a new worksheet (Formated Data) starting at A2
Select all rows that contain a value in column E (rawdata)
Copy values A:D and paste at the bottom of Formated Data worksheet
Add the the E1 header value as the value for Formated Data column E all new rows.
Add the corresponding value from the Rawdata column E to the classvalue column in the formated data sheet.....
This must happen for 180+ attribute values.......some may be filled in some not. So I have to cusor through the rows that have date fill them in and go on to the next column select those values and do it again..........
At the end I will resort by the item number so the data will be grouped by the item number.........
I am just not sure how to accomplish the cursor.....loop and past portion.
any ideas anyone............
I hope I explained this well enough..........and in the right section.