Need to convert a chart list to a database listing.

**sampson20** · 07-24-2007, 11:46 AM

I am trying to convert a chart listing into a database type listing.

Please see attachment to see a visual of my question.

I have done something similar to this before but can't remember what I did.

Thanks,

**rylo** · 07-25-2007, 12:33 AM

Hi

How about some code.

Assumes that your data as shown is in the range A1:D4 (including headings) and the output can go to columns F:G.

Please Login or Register  to view this content.

rylo

**sampson20** · 07-25-2007, 08:48 AM

Rylo,

Thanks for the code it worked perfectly. My spreadsheet is much more elaborate but I think I understand the code you supplied well enough to expand it to meet my needs.

I have attached a copy of my results after I added an additional column of static data to test if i could decipher the code.

thanks again...

Need to convert a chart list to a database listing.

LinkBack

Thread Tools

Rate This Thread

Display

Need to convert column data to row data.

Worked perfectly!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions