james620
12-05-2009, 04:50 AM
I have a file (attached excel 2003 is what i use at work) which I am trying to do a couple of things with.
1stly I have written a macro (my first!!) to look down each colummn for a term, shown as 1-12 on my sheet. When it finds the term it goes across to the surname and places it in the corresponding post box at the top (still with me?) it then checks against a list of names within the macro to check their drivers or not and then colours them, so i know who are and who arent. it then colours any blanks with a blue so i know i have them
can anyone see how i could simplify this? and instead of it having to check each name individually in the list i have place 2 lists in a spare sheet which i then was it to check the top section against and colour silver(or yellow as it is now) if they are current, and stay white if they are expired, or if its a blank colour blue!
also id like to, to make life easier, copy across data from test 2 into test sheet. test 2 is a shift for the year, which i get, i then have to type them all in for the year. i've had to split the first sheet up into 2 sections as its too many days for 1 sheet by the looks of it.
Id like to be able to get all the data from the shift spreadsheet to transfer over into 1 row, from the 52 the data is displayed in?
im not that good at these macros yet, but i thank you for looking and for your time !!!
:banghead:
1stly I have written a macro (my first!!) to look down each colummn for a term, shown as 1-12 on my sheet. When it finds the term it goes across to the surname and places it in the corresponding post box at the top (still with me?) it then checks against a list of names within the macro to check their drivers or not and then colours them, so i know who are and who arent. it then colours any blanks with a blue so i know i have them
can anyone see how i could simplify this? and instead of it having to check each name individually in the list i have place 2 lists in a spare sheet which i then was it to check the top section against and colour silver(or yellow as it is now) if they are current, and stay white if they are expired, or if its a blank colour blue!
also id like to, to make life easier, copy across data from test 2 into test sheet. test 2 is a shift for the year, which i get, i then have to type them all in for the year. i've had to split the first sheet up into 2 sections as its too many days for 1 sheet by the looks of it.
Id like to be able to get all the data from the shift spreadsheet to transfer over into 1 row, from the 52 the data is displayed in?
im not that good at these macros yet, but i thank you for looking and for your time !!!
:banghead: