Search results for query: *

hi, i work for a small offshore company we use a excel workbook offshore, we have multiple locked down cells within the book. however the offshore staff have been using an unlocking excel add-in called password.XLA to unlock the book. is there any way of stopping these types of unlocking tools???

hi guys im having a little problem using the vlookup function, what i have is two sheets (sheet1 and sheet2)on sheet one i have 3 columns. column a "ss numbers" a unique identifying number for each person column b name of employees column c job number on sheet sheet two i have the same...

hi there again, i am trying to replace a"." with a"/" in column A, i have used the recorder and it gave me this code: Selection.Replace What:=".", Replacement:="/", LookAt:=xlPart, _SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ReplaceFormat:=False when i use the...

hi there guys im having a funny problem inserting a piece of code. With Range(Cells(2, "A"), Cells(2, "A").End(xlDown)) lRowStart = .Row lRowEnd = lRowStart + .Rows.Count - 1 End With With Range(Cells(lRowStart, "B"), Cells(lRowEnd, "B")) .Offset(-1).Value = "WE" .Formula =...

hi guys i had a question on consolidation yesterday its along the same lines . if i have two columns the date and value of hours is it possible to loop through them adding up the values if the dates are the same leaving me with one date and one value i tried using the pivot info i have...

hi there again i am writing a macro in which i need to consolidate colums a colums b and colums c (a = WE , b=A type , C =Hours ) the problem is the macro needs to consolidate different depths of information every time ive tried a number of different things none seem to work. please help

hi guys in a macro i am writing at the momenent i am trying to tell a pivot table to use everthing on the page i cant use absolute reference because each workbook it will pivot is a different column depth there will always be 5 columns thanks

hello there i have a column in a spread sheet in excel called "hours" if the hours are equal to zero i want to delete that entire row can someone please help

i would like to know how i can find the depth of a column then use that amount to set the depth of other columns in excel. for example if my first column is (a2:a40) and i have a formula to paste in the next column that i only want to go to the same depth the reason i ask is because the...