How to Automatically consolidate table, frm diff. tables located in diff. sheet, using VBA

Good Morning!

Hmm,

No Response.

Can anyone help me with this Macro,which would arrange details to one table from different table located in diff. tabs of same worksheet sheet in same provided format.

Please find the attached excel file. Any doubt please feel free to ask.

Still waiting for the reply!!!!

Thanks in advance!

Regards
Ram

Only selected rows are transfered. What are the conditionas to pick particular Rows only from each sheet.

Originally Posted by kvsrinivasamurthy

Only selected rows are transfered. What are the conditionas to pick particular Rows only from each sheet.

Hi Srinivasamurthy,

Thanks a lot for reply.

The main Open Item table needs to PICK from the open items mentioned in 7 individual table of resp. currencies sheets; reason being those are yet to enter.

The 7 Individual TABLE we update manually, which matches our systems balance. The section we are trying to automate using macro, is where the Main Open items table needs to be updated, from these individual table DATA at the end. At times, items are 35+, so prone for mistakes. Really need help.

This first part, more eagerly trying to make it work.

Later, only if its possible, to get the dates picked up those entries to one column (B) of Main Open item Table;from Column G of individual Curr, by using the cell ref., that is +M (Row No.), used in individual table. Its tricky.

Any help is much appreciated. Please make use of excel file attached.

Awaiting for reply!!!

Regards
Ram

Hi Kvsrinivasamurthy,

Good Morning!

Have replied, for earlier post. Any other inputs needed, please feel free to ask.

Thanks & Regards
Ram

Pl see attached file with Macro .