Hi,
I have a very annoying and frustrating problem with a Excel ICT project I am doing, which is made even worse by me knowing it has to be in at the end of easter holidays (end of next week)!
So here it goes I have the beginnings of a database for a company, and I have the staffs names, wages, id etc etc. From this information I am now using a form for easy access and editing (as I have several sheets linked) so I highlight what I want and the first row which is highlighted it takes as the labels. For when the form appears.
But now I have to make a macro which will automatically bring up the form for editing data, and heres the problem I will highlight my data and the correct labels appear (this is when recording the macro) but when I play back the macro it takes what I want as labels and puts them in the fields as data?! I have tried several things but nothing has worked.
So basically I want to know how to make a row become the form labels.
Hope you can understand what I am on about!
Any help would be greatly appreciated!
Thanks
Lewis