Hi
I'm currently working on a google sheet (excel file online) that census the income of 200 employees in 3 different countries.
I have four sheets created. 3 for each country and 1 that sum them all
I want to ask if:
-I could enter the number beside the name of the employee in sheet 1 (the sheet that sums all the employees), and then excel would automatically copy the number on the other sheets ? (the country sheets)
Is there any formula for this situation of I have to copy and paste each number for each employee on all the sheets?
I would be very appreciative for your answers
Bookmarks