uroy
05-28-2015, 10:55 PM
Hi all,
I have written a VBA code which will find the last available data in row of column C. After that I need some macro which will insert three columns right side of column C and shift the cell to right side. It's totally depends on column C's last data available. As per the given attachment column c has 4 line items, but later it can be increase or decrease. If it is increase to 10 line items then the selection will be D1:F10 and insert 3 columns right according to that current selection(not entire column only shift cells to right). Please find the attachment for reference.
This is the beginning stage of this macro later I will come up with more requirements.
Advance thanks
Uday Roy
I have written a VBA code which will find the last available data in row of column C. After that I need some macro which will insert three columns right side of column C and shift the cell to right side. It's totally depends on column C's last data available. As per the given attachment column c has 4 line items, but later it can be increase or decrease. If it is increase to 10 line items then the selection will be D1:F10 and insert 3 columns right according to that current selection(not entire column only shift cells to right). Please find the attachment for reference.
This is the beginning stage of this macro later I will come up with more requirements.
Advance thanks
Uday Roy