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 =...

i have the results linked to a graph so i have to give coordinates for the graph to read from a consolidation works best but trying to code it for a macro to work on different machines was a bit strange thats why im looking for a chunk of code that just cycles through adding up hours for...

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...

thanks guys im off to follow the wizard

the info from the consolidation i just need placed in columns e-g thanks

column a column b column c WE A type Hours 1 dd/mm/yy Pedd 1 2 dd/mm/yy Pedd 2 3 dd/mm/yy Pedd 3 4 dd/mm/yy Pedd 4 5 dd/mm/yy Pedd 5 6 dd/mm/yy Pedd 6 this is how my un consolidated info appears...

is there any way to code the consolidation?? without using a pivot table?? the reason is the info from my consolidation is picked up from an external graph page which reads in 3 other pages and produces a graph of actual, predicted and also produces an s curve can i still easily link this if i...

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

i am working with a download from sap when i import the information i have to move a few things about then insert a couple of formulas. the problem im having is column b is empty i need my maacro to call the column "WE" then input a formula and autofill to the same depth as column a. You see...

not sure how to use this code SkipVought

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

thanks pullemall ill give it a try

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...