ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

I make links to collect data from different sheet in one place. Now I want to update its automatically in date wise. So what function I have to use?

Not Sorting or Filter Function

user-image
تم إضافة السؤال من قبل Muhammad Younus Edhi , Accountant , M.A. Steel, Falcon Steel, Fortune Steel
تاريخ النشر: 2015/09/22
Ulavappa Jakati
من قبل Ulavappa Jakati , Ashok Iron Works (P) LTD

control +F the jhfdvfdvdfjnvdfjnxc

Rahul sivarajan nair sivarajan nair
من قبل Rahul sivarajan nair sivarajan nair , Auditor,Accountant,banking.Personal assistant , PT BASTIN CHARTERED ACCOUNTANTS

one option, we can consolidate the multiple workshet into a summery worksheet in excel

second option, we can use pivot tables

Taimour Saeed
من قبل Taimour Saeed , Implementation Consultant , Confluence

it depends when you say sheets do you mean different excel workbooks as if it was the same workbook the formula would update automatically. 

if it is different workbooks, there should be an update links when you open the consolidated workbook and that should update the formula

المزيد من الأسئلة المماثلة