Vgabond
Board Regular
- Joined
- Jul 22, 2008
- Messages
- 191
Hi Guys
I've this worksheet that start from 1st of the month till end of the month and I've the last worksheet that will total up all the table so I have the monthly total for every table. I don't have any problem if I'm going to add all the table manually but my problem is on one of the table which is under Staff Name whereby the staff name will not be on the same column. hmm...I'm not sure whether you guys follow me or not..hmm let me show some sample so you guys can understand it better.
EDIT: Removed HTML image as it was blowing up the page...Try again with a smaller shot. Moderator
Under the table Staff Name, the name will always change whereby it will not be on the same row for every worksheet. So is there any formula or macros that will identify the staff name and will automatically read all the worksheet and find the same name and total up each of the table based on the staff name. Your help is much appreciated.
I've this worksheet that start from 1st of the month till end of the month and I've the last worksheet that will total up all the table so I have the monthly total for every table. I don't have any problem if I'm going to add all the table manually but my problem is on one of the table which is under Staff Name whereby the staff name will not be on the same column. hmm...I'm not sure whether you guys follow me or not..hmm let me show some sample so you guys can understand it better.
EDIT: Removed HTML image as it was blowing up the page...Try again with a smaller shot. Moderator
Under the table Staff Name, the name will always change whereby it will not be on the same row for every worksheet. So is there any formula or macros that will identify the staff name and will automatically read all the worksheet and find the same name and total up each of the table based on the staff name. Your help is much appreciated.
Last edited by a moderator: