Hello everyone,
I'm quite new to this forum and also not that good with excel.
I'm using excel 2010
What i want to do is save the changes made in certain cells and then copy the output of certain commands that come with that to another tab.
To further explain what i want, this is somewhat what it looks like.
It's a sort of exchange system for laptops which i need to make for school for my internship.
This is what the main page with the main info looks like
Student number - Student name - Student phone nmber -- Laptop brand - Laptop number -- Time - Date
I'm already so far that when i put in the student number, their name, phone number, the date and time will automatically be filled with their corresponding data.
For the laptops i have 4 brands en 10 of each brands
What i want exactly is that when i enter a student number, i want it to automatically copy the data of the cells for hte student number, student name, student phone number, dat and time to be copied to another tab called history.
Then when i enter the laptop brand i want it to automatically add that laptop brand at the end of that copy in the history tab.
That way i want to keep track of who borrowed which laptop and when.
But there's one more thing i want
When i remove a student number, all the corresponding info (except hte laptop brand and laptop number) will be removed as well.
What i want is that when i remove a student number, i want it to create an extra line of when the person brough said laptop back.
There are some more things i want to do which i don't know how to do but i'll leave that for later, this is currently my main issue.
I hope it's understandable and not too complicated.
Again, i'm not that good wth excel yet so if anyone can help me with this i would greatly appreciate that.
Thanks in advance!
PS: sorry if my English is a bit bad, i'm officially Dutch
Bookmarks