surah79
asked on
Update Sheet depending on Main Sheet Data
Hi guys
I am trying to make a template in excel need help on that.
If I add data on the main sheet it will update the data on other sheet depends on the Team Name.
please find attached the sample template . The other sheets should be updated when we add or edit any data in the Main Sheet. It should updated according by team name in Column F in the main sheet.
thanks
surah
New-Template.xlsm
I am trying to make a template in excel need help on that.
If I add data on the main sheet it will update the data on other sheet depends on the Team Name.
please find attached the sample template . The other sheets should be updated when we add or edit any data in the Main Sheet. It should updated according by team name in Column F in the main sheet.
thanks
surah
New-Template.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks a lot for this.
You welcome Surah.
In the original source file, "AE" is followed by two spaces (value = "AE ") and the macro will halt because it doesn't match the sheet name.
The fix is easy:
1) Clean up your source data
2) Modify this line of the VBA code
Open in new window
with thisOpen in new window
Regards,
Glenn