Hello All,
I have a project where I am comparing two worksheets.
For example, if I have 12 columns and 12 rows on two different worksheets. I want to compare my initial number in column c6 in worksheet 1 with my updated number in c6 of worksheet 2.
In worksheet 2 in column A row 20, I want to add a line of text comparing the two numbers of how much in increased or decreased. Now if I make a different number change lets say in column 6 row 10, I would like the next formula or vba code to put a text description of the change in column A row 21.
I'm trying to get the text to show up 1 line down from the next. Is this possible? Or should I create a formula for each cell then have a macro or vba code resort the list to take out blank spaces?
Thanks in advance.
I have a project where I am comparing two worksheets.
For example, if I have 12 columns and 12 rows on two different worksheets. I want to compare my initial number in column c6 in worksheet 1 with my updated number in c6 of worksheet 2.
In worksheet 2 in column A row 20, I want to add a line of text comparing the two numbers of how much in increased or decreased. Now if I make a different number change lets say in column 6 row 10, I would like the next formula or vba code to put a text description of the change in column A row 21.
I'm trying to get the text to show up 1 line down from the next. Is this possible? Or should I create a formula for each cell then have a macro or vba code resort the list to take out blank spaces?
Thanks in advance.
