I have a question : a small use case where we have an excel document and in that excel we have 3 different sheets named for e;g sheet1 sheet2 sheet3
Sheet 1 contains data of 10 persons who we need to automate for a sign up process that is like they have first name last name dob mobile number address email country state etc
Sheet 2 Contains more details of a person who was in sheet1 and here it has his salary his daily expenditure his travel area his and few more details we can look into
Sheet3 contains more details relevant to sheet2 and sheet1 here he has his food eating details let it be breakfast lunch dinner.
so for 10 employees, we have 10 different data
If someone wants to automate all that data for a single person in one go how can we do it.
if I go with for each loop but it will close after the first sheet is done and we are unable to upload more data about him which is in sheet2 and followed by sheet3.
I am a newbie I have tried nested loop you guys might laugh at it but I want to know how we can do it.