Greetings,

I work in a company where the sales reports are filled manually daily. I have managed to do a Sales Report Table on first sheet called RES and I have 31 more sheets with names S01,S02,S03....S31. By the end of night the copy all the information from the app and paste on the sheet depends on the day of month. Can you please guys help me how to call a function of the total amount (Gross) column because everyday it is not on the same cell of sheet.

I will upload the content of a sheet just to see on what I am referring to.

Thank you in advance.

Test.xlsx