Home » Forums » Open Source Learning Center » Question and Answer

Extract data from a Table

Submitted by rasika99 on 11 September, 2014 - 06:48

Guys,

I have a table containing the data of audits of companies by Rating Agencies (in last 03 years). My boss asks summaries of these audits. I attached the table and the summery report format.

Can u guys help me to do this?

AttachmentSize
Book1.xlsx13.63 KB
‹ Please Help modify macro to include additional columns Help creating a currency exchange formula ›
»
akmughal's picture

Hi, I prepared sheet for you,

Submitted by akmughal on 15 September, 2014 - 23:29.

Hi,
I prepared sheet for you, what I did
1) create list of your desired company names
2) Normalize your detail data in columns and rows (didn't change any thing)
3) create a unique identifier which help to pick the values from detail table
4) create vlookup in your summary sheet to pick up your desired information from detail table.
I don't know how to attach a excel sheet here. Share with me your email id I will forward you then, hopefully it works.
Thanks

»