Inserting rows & columns

[prshnthvn]

Hello Everybody,

I am comparing 2 sets of data's. The number of rows or columns will not be constant every-time when i run this comparison.

I want to know how to insert a row or a column when the data is missing/extra in either of the data. for e.g. if the 3rd column is missing in the 2nd data, i want to insert a new column in the 2nd data.

Thanks in advance,
Prashanth Vakkund

 

[machopicho]

Where are 2 sets of data you want comparing?
In 2 different sheets?