0

I want to copy data from one excel to other excel. I first used CTRL + C / CTRL + V and copied data, format and formula all. But I only need data and format. Any suggestion?

Lin
  • 31
  • 8
  • google your problem.. – Pathik Vejani Sep 18 '15 at 09:09
  • I answered something similar a while ago, maybe it's helpful to you. [VBA copy cells value and format](http://stackoverflow.com/a/25461657/1175077) – jpw Sep 18 '15 at 09:13
  • possible duplicate of [VBA excel - copy cells between workbooks](http://stackoverflow.com/questions/6287405/vba-excel-copy-cells-between-workbooks) – gpinkas Sep 18 '15 at 09:15
  • Also, it's not clear if you want to copy between sheets or workbooks. – jpw Sep 18 '15 at 09:15
  • @gpinkas i don't want to use macro, thx. – Lin Sep 18 '15 at 09:32
  • @jpw yes, copy data with format and paste to other workbooks, but without formula - for instance, cell A value is 1 and cell B value is 2, cell C get value using formula 'Cell A + Cell B'. I want paste 3 not the formula. – Lin Sep 18 '15 at 09:33

1 Answers1

0

i found a solution in support of office.

pls see: https://support.office.com/en-au/article/Copy-cell-values-not-formulas-12687b4d-c79f-4137-b0cc-947c229c55b9

Lin
  • 31
  • 8