works

Hello I have an Excel spreadsheet that will be used for data entry without userforms (to allow for Mac users). I intend on password protecting it to make data entry easier. It works as I hope however I found the code on the internet and whilst it works I don't quite understand one line of code...

Hi Trying to understand Cells property better. When I use Cells property below for Sheet1 it works, but when I try to then use Cells property against SHEET2 I get Runtime error 1004. It seems that Cells property is tied to Sheet1 somehow. Can someone explain what is happening under the...

Hi All! I am new to this forum. Need help. I need to separate units from quantities. i am not being able to do it because cells that are custom formatted and no text function works on these. When converted to text format, the units automatically disappears! Can you please help me out on this.

Need to compare last years old worksheet "sheet1" to current worksheet "sheet2" They have the same 12 columns, first column A is unique Request Job Number Both worksheets are similar but not the exactly the same size about 200 rows Completed job requests on old worksheet are removed from current...

Is there a way of ensuring a Excel 2010 Macro Enabled file works fine in Excel 2007 ?

I just bought the latest version of Excel and I use to be able to step through my macros with F8. It no longer works. Also My control buttons don't work. Has it changed?

anyone have an experience with offset returning a wrong data type error when increasing the height above 1? =OFFSET(A1,0,0,1,1) works just fine. =OFFSET(A1,0,0,2,1) produces wrong data type. Starting with a different reference doesn't seem to make a difference.

I have a macro which works perfectly for one search and will display the information correctly. This macro is then cycled by another macro to view other matches for the same sort information which works correctly. Problem is after (about 20 or more) cycles, the total program goes belly up and...

Good afternoon, When I use the following code to filter an Excel database to all rows where the date in the first field is less than or equal to the value in the named range "DeleteOldest" DODCriteriaString = "<=" & Format(Sheets("Database").Range("DeleteOldest").value, "yyyy/mm/dd")...

I have code that puts data into columns depending on weather or not the check box is checked. I also have code that checks the value of the cell and re-checks the box if >0 I Can't seem to get both codes to work, whichever on I have first works but the other doesn't. If I switch the order then...

It's a pretty simple function - just look down the column range and display the cell that is not blank... =VLOOKUP("?*",A2:A12,1,0) It works when there is text in the cell - but gives an error when the cell shows a number? What is the fix? Thanks for your help!

So I have this excelfile where I print labels to a Zebra printer. Normally I don't have the Zebra printer as default printer because I also print other stuff on a normal printer. Application.ActivePrinter = "Printer2 på Ne2:" I tried this and it works, but our server keeps changing the Ne...

hi, if anyone could explain why this is happening i would be very grateful I have a hidden sheet 'Exp' that is password protected, and automatically hides (veryhidden) when the user navigates away from it. This all works fine. The incorrect password message works too. But I am getting this...

I'm having issues with the last part of my formula. I have two sheets, a results page (where the formula is written) and the Database page where all results will be stored. When I write this formula out on the database page, it works exactly how I want it to, just need it to work on my results...

This formula works fine: =SUMIF(I30:I42,">="&I2,G30:G42) This formula gives me a "#Value!" error: =SUMIFS(G30:G42,I30:I43,">="&I2) I have under criteria for the SUMIFs which is why I can use SUMIF but it was erroring out so trying to figure out why.

hello all this is the formula i have which works great which references a worksheet but i also need it to perform the same commands and keys but from another worksheet IFERROR(INDEX(T_LEAVE56[TYPE OF UNIFORMS],SUMPRODUCT(--(T_LEAVE56[EMPLOYEE NAME]=$B9),--(T_LEAVE56[START...

I am using office 365 and when I do a sumifs formula and I reference a entire column for my criteria I get either a zero or a #SPILL ! error. It only works when I reference the specific cell. This used to work in older excel versions. Can I no longer reference a full column for my Criteria...

I have a sheet with a formula to grab numbers from a string from this formula =iferror(mid(A6,find(320,a6)+4,6),"") in the H column. i have the formula =sum(H:H) in the N column and always get 0 for a response instead of the total. I have this same formula on other sheets and...

Hi, I am trying to change some formula in my file with VBA calculations, but as the formula is bit complex, have troubles expressing it in VBA. Result of the formula should be count of all projects started this month from 2 sheets different than the one it is present in. Formula in sheet works...

Hello all, I need help with this problem. Spreadsheet works fine in my computer and another colleague's computer. Our computers are not networked in any way. However, it is also opened in a computer using Chinese regional setting and language is when the formula became broken. For example...