Attendance Tracker V5 (version 2)sample.xlsxHow do I make a sheet come up with a name in a cell from another sheet with a click of a cell that has a different name then the one i want put on the other sheet. But the name is in the same row as the cell i just i clicked to go to the other sheet? here is the sample and i have wrote comments as well.
Last edited by ltjohnson; 06-04-2012 at 07:56 PM.
Please amend your thread title .Use concise, accurate thread titles. Your post title should describe your problem.
may i suggest "hyperlink to different sheet"
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Attendance Tracker V5 (version 2)sample.xlsx I've done the hyperlink already. I just need the cells with the hyperlink to bring up the sheet with the name that is in the same row as the hyperlink to come up in a cell when you click the hyperlink. I had the IF statement to do it for one name but it wouldn't work for the other names. Now i deleted the IF statement and don't know how to do it again. I attached the sample in and wrote comments.
Last edited by ltjohnson; 06-04-2012 at 07:55 PM.
post a sample workbook.
i just put a sample up with comments on the workbook.
Hello
i think you are after a mail merge for each person as "warning for being tardy etc.
i think vba can do what you want.(i'm not good in vba - maybe someone could help you with that.)
my suggestion is to create a list/ maybe a pivot report that will get all the names of the person that received 1 to 4 ("warning/violation")
from this list maybe you can generate a some kind of mail-merge linked to the Report Tab.
vba logic is: when hypelink is click - get the name from column A and display it in the target area(report tab cell B1)-to generate report for printing.
a possible sol'n:
Database sheet module
Please Login or Register to view this content.
Ben Van Johnson
where and how do i put this in?
it only worked for the first 2 text but yes that is what i need so how do i do that for the rest and how do i put it as the master.
In the present effort, I have modified the hyperlinks to point within the "database" sheet. The code will, if the name in column A does not exist, create a new sheet with that name. If the sheet already exists, the data from the database is copied to the next line in the summary area.
Please Login or Register to view this content.
if its possible can you do it for the absences row, and i don't want to have the sample name in another sheet just to show up on the reports sheet. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks