usmanhussain13
New Member
- Joined
- Jan 29, 2019
- Messages
- 11
Hi All,
have been trying this for hours with no luck. Can you someone provide me a VBA code that will help with my issue?
To set the background:
I have a set of data, firstly I need the macro to insert a Row between the 3rd/4th row and then every 2 lines after. So in my data create a row between A3/A4 (row will become A4, then between A 6/7 and thereafter (up til end of data). I then want the row added to compare the cells in the previous to cells. So when A row was created in A4, i want it to compare cells A2 against A3 and write Difference in the cell if their is a difference, and No difference if there is no difference.
I then will create my pivot table for my other criteria and i want to identify the differences in the pivot table. So for instance if there is a diffrence between A2 and A3 and A4 populates with "Difference", i want the pivot table to recognise what the difference was based on the column header. So if its sock colour for example is column header in A1 and A2 has Green, and A3 has Red, A4 should populate with difference and i want the pivot table to pick up "difference in sock colour" for the clients which is something i will add into the pivot.
Granted this sounds very confusing, i wish i could attach a file to make it easier. Appreciate any help. willing to transfer some money to someone who can create a code for this.
Thanks,
have been trying this for hours with no luck. Can you someone provide me a VBA code that will help with my issue?
To set the background:
I have a set of data, firstly I need the macro to insert a Row between the 3rd/4th row and then every 2 lines after. So in my data create a row between A3/A4 (row will become A4, then between A 6/7 and thereafter (up til end of data). I then want the row added to compare the cells in the previous to cells. So when A row was created in A4, i want it to compare cells A2 against A3 and write Difference in the cell if their is a difference, and No difference if there is no difference.
I then will create my pivot table for my other criteria and i want to identify the differences in the pivot table. So for instance if there is a diffrence between A2 and A3 and A4 populates with "Difference", i want the pivot table to recognise what the difference was based on the column header. So if its sock colour for example is column header in A1 and A2 has Green, and A3 has Red, A4 should populate with difference and i want the pivot table to pick up "difference in sock colour" for the clients which is something i will add into the pivot.
Granted this sounds very confusing, i wish i could attach a file to make it easier. Appreciate any help. willing to transfer some money to someone who can create a code for this.
Thanks,
