Jun 03 2021 10:52 PM
Hello,
I need your help guys,
I have a Excel file which is daily debitor report. This file has two sheets . Sheet 1 and Sheet 2.
So, I want the data in the sheet 2 (here sales and bank) to be added to sheet 1 automatically. One of my friend applied a VBA code for this and it works ( attached file possess this VBA code). However, I want it with formula (not with Pivot table). I hope anyone can help me with this situation.
Jun 04 2021 12:48 AM
Check the Sheet 1 in range I14:J19 I've applied an array (CSE) formula,,, and you need to copy it for other dates,, but be careful.
My observation & suggestions:
Jun 04 2021 03:05 AM
Jun 05 2021 04:59 AM
Jun 07 2021 11:19 PM