12
Views
1
Comments
[Advanced Excel] How to copy columns value with formula from one sheet and paste on another sheet?
Question
Forge component by Carlos Freitas
69
Published on 27 Aug 2019

Hi all,

    As title, and source sheet and target sheet are in different excel, anyone knows how to do it?

Regards,

Zhou Shuai

Rank: #2500

Hi Zhou Shuai,

Check out this AdvancedExcelDemoCopySourceDest_v1.OML  based on AdvancedExcelDemo

with sample button "Copy from source to dest" which 

will copy the content of all rows of columnExtra ( col with formula)

from a source excel file named Source_Categories.xlsx

to a Destination Excel file named Demo_DestinationFromSource.xlsx

In provided eSpace I have 

1.Added to resources

Source_Categories.xlsx -  

with columns 

Category Name,Description,columnExtra (with a formula - simple concatenation of columns A and B )  , 

and in column D1 with formula - =ROW(OFFSET(A1;COUNTA(A:A)-1;0))

to determine number of rows in worksheet 

check details about 

https://www.exceltip.com/other-qa-formulas/get-the-row-number-of-the-last-non-blank-cell-in-a-column-in-microsoft-excel.html


2.Destination.xlsx - blank excel


Best regards,


Alexandre Yip


AdvancedExcelDemoCopySourceDestv1.oml