copy paste row above when change in column data

Microsoft Excel 2010 - complete product...
February 9, 2018 at 08:36:47
Specs: windows 7
i have a table of customer information by date and Tier Status

col.A col.B col.C col.D col.E colF .......
cust MAY JUN JUL AUG DEC
cust1 T1 T1 T1 T1 T1
cust2 T2 T2 T3 T3 T3
cust3 T3 T3 T3 T4 T4

i would like to see a new row for every change in tier

col.A col.B col.C col.D col.E colF.
cust MAY JUN JUL AUG DEC
cust1 T1 T1 T1 T1 T1
cust2 T2 T2 - - -
cust2 - - T3 T3 T3
cust3 T3 T3 T3 - -
cust3 - - - T4 T4


Is there an EXCEL macro to copy paste row above when value changes? i can delete the dups between rows manually if that it too hard for EXCEL to figure out

message edited by kesha1118


See More: copy paste row above when change in column data

Report •

#1
February 9, 2018 at 11:55:54
Please click on the How-To link at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly.

Don't forget to use Column letters and Row numbers as shown in the example.

Thanks!

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •
Related Solutions


Ask Question