Hey guys,
So I am working with HP Quality Center to extract data from a database to format into an excel spreadsheet. I extracted most of the data that I needed and used the "Record Macro" function to come up with something really simple. However, this is hard-coded for only one line of data and there could be multiple lines of data.
I'll try to explain how the data is initally put into the excel sheet:
Row 1, Col 1, 2, 3, etc. : Has all the headers (Person responsible, project, project ID, etc.)
Row 2, Col 1, 2, 3, etc. : Has all the data for each of the headers
I am creating an engineer report, so there will only be 1 person responsible, but multiple projects, which extend down sequentially in the next row.
How can I check to see if data/text exists in Row 2, Col 2 (checking if there are multiple projects)? I want a function that can increment a counter inside of it as well so that when I format it all the data nicely, I can just use that variable to establish new ranges so that it is not hard-coded.
I don't know if you guys can visualize this so if you have any confusion about how it looks, just let me know.
Thanks a lot!