Excel column copy data

Help
, ,
1

hey
i want to copy previous column data (All values) and paste it into next column so how can i do that ?

2

Hey @Mayur_Pawar,
You can use

Copy Paste Range Activity

to copy and paste.

Thanks!

3

Screenshot (81)
Screenshot (81)1920×1080 77.5 KB

so in above excel i’m able to insert column but i want to copy all the property and data of column 2015 i.e previous column and want to paste into next blank column with name 2016 .

4

Do u need to copy all the properties of that column also?

5

yes coz that column has formula so i need to carry forward.
@suruchi120294

6

Use read range activity and provide the range of the column that u want to read and in the properties panel check the Preserve Format option. Then use the write range activity.
Try to use this.

thanks!

7

I suggest you to using invoke code to copy data like below.

yRange1.Value = xRange1.Value
xRange1.Copy
yRange1.PasteSpecial(Microsoft.Office.Interop.Excel.XlPasteType.xlPasteValues)