hat
Sa a sèvis piblik ka ede w byen vit ranpli referans selil menm soti nan fich plizyè nan yon Fèy travay. Ou ka ranpli yo vètikal oswa orizontal. Sipoze ou gen yon workbook ki gen plizyè fich, e kounye a ou vle ekstrè tout referans yo selil menm (A1, pou egzanp) soti nan fichye lòt nan yon fich travay, ak fonksyon sa a, ou ka byen vit jwenn rezilta a = Sheet1! A1, = Sheet2! A1, = Sheet3! A1, = Sheet4! A1 ... nan yon Fèy travay mèt.
eng
This utility can help you quickly to fill same cell references from multiple worksheets into one worksheet. You can fill them vertically or horizontally. Supposing you have a workbook which contains multiple worksheets, and now you want to extract all the same cell references (A1, for example) from other worksheets into one worksheet, with this function, you can quickly get the result =Sheet1!A1, =Sheet2!A1, =Sheet3!A1, =Sheet4!A1… into a master worksheet.