Jan 18 2022 06:41 PM
Hello,
I have an excel file that is used to update the payroll journal entry allocation. we use the ADP data from a second sheet to update the journal schedule. As of now it is updated manually twice a month. how do i create a formula to using maybe the staff name or employee ID, to pull the amounts and update automatically as soon as the new data is dumped?
please help, thank you :)
Jan 19 2022 12:54 AM
That could be any lookup formula (XLOOKUP, INDEX/MATCH, etc) depends on your Excel version. But that's better to discuss with small sample which illustrates how data is structured.