Pull specific data from different worksheets with identical format to one master worksheet

Hello all Excel Experts,

My query is;

I have 2 different worksheets having similar format (header rows/columns) but different data (values). I need to pull out these data based on their values, means if cell is blank leave that cell and move on, but if cell has some value then pull that value with its corresponding row & column headers to place into a simple table to further use it for PivotTable. The number of rows and columns are equal in both worksheets.

So basically, the proposed function will run a check on both worksheets within a specific range of cells for their values and if not blank, it will fetch that cell value along with its relevant row header and column header and place all these attributes into the destination worksheet.

Hope I am quite clear with my query. Can anyone help me with the required function to ease my life?

Thanks in advance.

Murtaza

Could you upload your sample workbook?

First Step: press "Go Advanced" button nex to "Post Quick Reply"
Second Step: find attach file button

Regards
Azumi

Dear Azumi,

Thanks for your concern and sorry for being late to provide you sample. Here I attached 2 workbooks named MN & RD with same header rows and columns but different values.

Now, I am looking for the macro which will run a check first on MN workbook for the range c2:cq290 and fetch data from non-blank cells like, cell c4 is first non-blank cell so it would take corresponding data as below;

Row Header Column Header-1 Column Header-2 value
10001-1 ALMAYA-LAMCY PLAZA KARAMA LPO 1-3-14 550

then next record as below
10001-1 ALMAYA-LAMCY PLAZA KARAMA GRV 1-3-14 120

and so on....

Above fetched data records will be placed in a new workbook lets say master with simple above format.

The same macro will run again for another workbook RD and fetch data in above manner and place in master book.

Anything I am short of explaining my requirement should please be asked.

I will be so grateful for the function made on above.


Thanks...

do I have too!!!

how do I get an answer to my question? new to this