checking

I’m trying to query a value in a row/column and depending on the value provide an answer in another row/column. The data I’m checking against is a number sequence which needs to be queried to see if it’s between a series of more than/less than/equal to statements. Ive done these before for...

Hello, I have this sub from jmacleary found on this post but i thought i would be best to start a new post as the problem has shifted So the sub will grab sheets from an array and put the first column of each sheet into one sheet titled "Unknown" My problem is that the sheets are now generated...

Does anybody have any experience with using Box (www.box.com)? Specifically I am trying to use Box API calls for checking availability of Excel files, then opening them and checking them out, modifying them and saving back to Box and checking in. Their forum has limited information on the API...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; min-height: 14.0px}</style>MrExcel gurus, I'm trying to improve a workbook that helps manage spending well enough that it justifies...

Hey all, Still learning how to use excel, however I have a budget sheet I made I've been using for the past few years. Simple stuff, just my income vs outcome vs savings. This year I've added a "Wish List" Sheet to it, and I was wondering if anyone could help me with a formula. So I have...

Hi All Hoping someone can offer some advice, both my colleague and myself are far from experts with VBA. We have an excel workbook that collates multiple material lists using VBA and consolidates a final version for stores this is all working fine. We are now trying to add some error checking...

I have users who are using my file to generate a name in an approved format. This includes checking for the following characters that are NOT to be included in the name: | / \ : - [ ] { } * ? ' " ^ # I thought this was going to be a simple SEARCH function, but I'm getting results I wasn't...

Good morning, I now need to save the project I created in Excel 2010 as Excel 97-2003 so that my boss can try it out. Can anyone point me to a method or tool for checking compatibility of my current macros with Excel 2000? thanks much, Bill

Hi All, I have a spreadsheet with a formula I tried dragging down, and even though it copies the formula correctly, the results remain the same in the entire column. I tried F9 / checking formula settings were set to automatic but that did not sort the problem either. Anyone able to help? Thanks!

Hey i have a column full of dates that i need to arrange in the format dd-mm-yyyy. I do this by this code: Sub ChangeFormat() With ActiveSheet.UsedRange.Columns("D").Cells .TextToColumns Destination:=.Cells(1), DataType:=xlFixedWidth, FieldInfo:=Array(0, xlYMDFormat) .NumberFormat =...

Lets say whole ABCD is written in A column Row wise. I want to apply filter to show rows with only, A, C, U, K How would i go about this without manually checking these using simple filter option. Also suggest wildcard usage if for example I search for *A*

Hi, I have an array for example arr(1) - mackeral arr(2) - Tuna arr(3) - Salmon arr(4) - Salmon arr(5) - Cod arr(6) - mackeral arr(7) - Tuna arr(8) - Cod arr(9) - Salmon arr(10) - Cod I need to check the arr values for any matches. So for example check arr(1) against arr(2) to arr(10) and so...

Hi everyone, I have made a macro to add in a table a sub total from a filtered database. The sub total function being the only solution, because the SUM function is taking into account all the rows, and I only want the ones which are filtered. To do so, I have write this ...

Hello, I have the below code that inserts data from a text file into cell A1, if the text file contains the string "Checking for drops": Dim FileNum As Long, TotalFile As String FileNum = FreeFile Open "C\pete.txt" For Binary As #FileNum TotalFile = Space(LOF(FileNum)) Get #FileNum...

Hi I am using Excel 2013 and I want to use an IF AND statement to check the value of 1 cell and another. So I am checking: if B1=1 AND B2=100 is true I want to return the value "2" if B1=1 AND B2<100 I want to return the value "1" if B1=2 AND B2=100 is true I want to return the value "3" if...

Hello All, I am writing a code that does the 2 steps listed below, a total of 50 times. Below is a description of what the code does. Step 1) The code looks for a single cell to see if it is blank, or to be precise, if it is A1="". If the cell is empty (" "), then the code skips step 2 below...

I have scenerio in excel Job Nature, in Column T which have values (W), (F) (M) Days to check in Column S which have values "No. of Days" & Paid W/Card in Column N which have values True , False The Thing I want to check is, if Job Nature is (W) and No. of Days is <= 365 and the W/Card is Ture...

Hi, I am looking for help checking for a text match, so I can show a tick or a cross in the cell next to it. I have 2 sheets. Interface and Data. In Data it has, First Name, D.O.B, Postcode ect. In the interface the user types First Name into cell C10 and then it check the range of Data!B:B...