stored

Hi all, I'm trying to get my macro to insert a formula into a cell. Basically, if the value in the column "Start Date" is found in the group US_Dates (which I've stored in AI2:AI60), then leave N9 blank. Otherwise, show "ERROR" It's throwing: Run-time error '1004': Application-defined or...

Dear members, I need to get amount and name stored in sheet2 by comparing id numbers stored in sheet1 Sheet2 values A B C H ______________________________ 1 1000000 DM 2 SS100148 DM2 350 3...

hi all ive seen many templates have a drag/arrow icon on the bottom of the last row or column. What ive seen it do is have data stored only when you drag the arrows down then more data appears how can i do that. Thanks

Hi All, I'm in process of wanting to create an Excel Spreadsheet which will have two input fields called "Collection Date" and "Delivery Date". The user inputs the date DD/MM/YYYY into these two fields and then clicks a button "Get Data". This calls a SQL Stored Procedure "EXEC...

Hello, I am trying to populate a combo box on one sheet with data that is stored on another sheet in the same workbook. The data is stored as a table. The data is a list of products with corresponding information about the product (ie Item Number, Description, etc...). Can anyone help with...

Log Files within an Workbook to track changesHi, I created a quotation template for a small business, I would like to create a log work sheet so that I can track or keep a count of all the quotes that was done. Eg. Lets say the Quote # is in Cell A1 and the Customer is stored in Cell B2 and the...

I understand that using ALT DEF changes "numbers stored as text" to numbers, which i do use almost daily . . . . but I just want to know WHY that works . . . . THoughts please?

Not sure if this is possible, I can't seem to figure it out. I made a custom ribbon menu, which is stored in the Excel.officeUI file. For one of the button labels (or description) I would like to have it display a variable in a stored xla file. Is there a way to do something like...

So I've got a bunch of cells going down column A with strings like the below examples and I would like to be able to use each number in an IF function. Is there a way to store each number in A1 as a variable that I can use in an IF function and then once all the numbers are stored and used, move...

Hi my head is spinning here a little im trying to compere 9 column number to find highest values (also this number will be expanded later) I want to return the highest number of these 3 Columns"J" "N" "R" result stored as variable double I want to return the highest number of these 3...

Hi, I have two variables declared as string and I am combining them using </code> Cells(lngrow, 27) = strSRowA & "," & strSRowB </code> So I have one cell as 1154 the second as 1155 I wish to combine as <b>1154,1155</b> but the value in the cell displays as 11,541,155 and is stored in the...

I have an excel sheet with 24K rows of monetary transactions. Each transaction is given a category; There are 6 different categories. I stored the transactions into an array. I want to sum each category and store them (category and total amount) into another array. How would I go about...

Hi Ive been struggling with a search loop today here is what I got: j = 4 x = 4 lr = Cells(Rows.Count, "C").End(xlUp).Row search: If j > lr Then Exit Sub End If Ateam = Cells(j, "Q") For i = 4 To lr If Cells(i, "C").Value = Ateam Then...

Hello, Does anyone have a readily code or function that determines the most frequent item in the array ? I think it will take me a while to come up with it. I created an array Dim ar(50) It stored up to 50 items, sometimes the items can all be the same, other times it could be different...

Hi, I have four integers stored in four variables. I need to sort these, and in a descending order put into appropriate cells (A1, B1, C1, D1). However, there also can be a string instead of one integer I managed to find the integers, and store them into variables. I also managed to identify...