Sunday 11 September 2016

How to copy fields from sheet1 to sheet2

For example we have sheet 1 (Column names A, B, C) and sheet2 (Column names A,B, C)

Assume you are in sheet 2
You want to copy Column B from sheet1 and put in sheet 2


On sheet 2
Just create or go to column D
Type this formula in column field .. this copy the field.

=’Sheet1’!B3

1 comment: