VBA - Compare Table Header with Merge Rows

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
Almir's picture

Are worksheets structured in the same way?

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

Please see attached sample file

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

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