Hi guys!
I'm quite new to VBA writing and I need a bit of expert help - thus far I have used the Excel Inquire tab to compare two templates (by template I mean a table [not the Excel object, just cells with coloured borders, if that makes any difference] that has 3 rows at the top containing the headers and 7 columns to the left hand side containing the definition of the row). Now I am no longer allowed to used this tab so I need a little macro to do that. My problem is that I don't even know where to begin.
My tables look like the below image. And I need to make sure that their structure doesn't change from one month to another. I have merged rows and merged columns, because nothing can be easy.
I will take any advice you have to share to help me create my little macro. It's difficult to do by hand as the tales have hundreds of rows and i also have multiple sheets
Thank you kindly,
Rina
I'm quite new to VBA writing and I need a bit of expert help - thus far I have used the Excel Inquire tab to compare two templates (by template I mean a table [not the Excel object, just cells with coloured borders, if that makes any difference] that has 3 rows at the top containing the headers and 7 columns to the left hand side containing the definition of the row). Now I am no longer allowed to used this tab so I need a little macro to do that. My problem is that I don't even know where to begin.
My tables look like the below image. And I need to make sure that their structure doesn't change from one month to another. I have merged rows and merged columns, because nothing can be easy.
I will take any advice you have to share to help me create my little macro. It's difficult to do by hand as the tales have hundreds of rows and i also have multiple sheets
Thank you kindly,
Rina
