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

VBA - Compare Table Header with Merge Rows

Submitted by ivandgreat on 28 January, 2013 - 11:41

Hi,

I have a master sheets with existing table, i wanted to update this table from other sheets for a specific columns. But this column having a merge header (2 rows).

How could i compare this column header with the master table sheets and update this data?

Could you please help me to have a vba code to check/compare and update the master sheet.

br,
ivandgreat

AttachmentSize
UpdateData_FmDiffHdr.xlsx13.22 KB
‹ VBA to copy heading when new sheet is created via userform Edit links ›
»
Almir's picture

Are worksheets structured in the same way?

Submitted by Almir on 29 January, 2013 - 08:56.

If so, you could create linked formula. Maybe you post both files here.

»

Please see attached sample file

Submitted by ivandgreat on 29 January, 2013 - 09:46.

Hi Almir,

I just attached the sample file i have.

here i have 2 sample sheets (Sheet2 and Sheet3) that will be update in Master sheets, but the header are different.

I just want to update the table based on there respective columns.

br,
ivan

»
Nick's picture

ivan - your problem seems to

Submitted by Nick on 28 January, 2013 - 18:12.

ivan - your problem seems to be one of design.

you should hold all data in a single sheet, and create pivot tables to report on individual sheets

»