collating specific data frommultiple tabs to a single tab in same workbook

Question

Hi All,Apologies if this has been asked previously. I am trying to pull together a report that takes data from four different tabs into a single tab within the same workbook.&nbsp;I have managed to get the macro to work for two of the tabs but can't seem the information pulled from the remaining two tabs. Please see the attached.&nbsp;Any help much appreciated. I am just learning VBA and Macros.Tina

jkpieterse · Answer

It is because the layout of the third and fourth sheet is different from sheet 1 and 2 (check columns A and B)

katrina randle · Answer

Thanks so much. I have corrected that now it works perfect.

Forum Discussion

collating specific data frommultiple tabs to a single tab in same workbook

Share

Resources