enter

Hi, I am trying to write an array formula for median if statement. =median(if(A25:A223="End Customer")*(A25:A223="Partner"),G25:G223)) the hit control shift enter..for the array excel keep popping up there is a problem with this formula .. not trying to enter a formula.. ( I tried retyping...

My apologies to start off with. I am teaching myself and need some assistance. I have a table that has columns. what I want to happen is that when I enter new data into this table it will send it to my other table without having to enter it all over again. what formula would I use? I want it...

I have created a sleep/wake log for a sleep experiment where individuals enter in the time they went to bed at night on Row 2 and the time they got up in the morning on Row 3 for 7 days. I have a formula at the end of each row for those 7 days that gives me the average time in bed and average...

I have made a spreadsheet for my supervisor and he wants the ability to insert a custom signature file at the bottom of a sheet using the browse dialogue box. I already have two buttons that enter a signature each. The signatures are in the right position. Sub cmdJakeSig()...

Hello, I have a userform where someone can enter a multiplying factor (exchange rate). I want to use this number to multiply the contents of a range of cells (A1:A100) across all visible sheets. Can you help please! Thanks, Nick

I have Excel 2013 and I am trying to set up a formula that will compare if the total of cell A1*$14 is less than $500, then I want it to enter the $500 minimum. If it is more than $500, I want it to enter the larger dollar amount. I am wondering if this is possible with my version of Excel...

I am trying to develop something in Access when you press a button, it brings up a msgbox (fine) and you enter a reference number. This then launches Outlook, and in the subject field enters the number you just entered into the msgbox (again fine) What I then need is to reference a field in...

Hi, I've looked all over for a solution to this but nothing. I'm trying to pass a number as a parameter into a URL, keeping the leading zero's. Example: 000129832 When I enter this it gets passed as 129832 which doesn't work in the URL I have this: let SR=(ACNUM)=> let Source...

I have a filed on form that is formatted as currency with a default of zero "0". When the user enters the field to enter an amount, the cursor appears in front of the defaulted value of 0. So when they start entering a value - less say "17" it shows as $170 not $17. When they hit enter it...

Good Day I have the following which writes to a specific cell. I would like to extend the range for column H Thanks Sub Meet() If ThisWorkbook.Sheets(1).Range("H15:H15").Value = "" Then MsgBox "Please Enter a Meeting Number" Exit Sub End If End Sub

Hi There I have a list of postcodes and their 16 wards. I want it sowhen someone enter the postcode into the postcode column it astronomically picksthe ward relating to this postcode and fill in next column once the postcodebeen entered. Does anybody have any ideas how I could do this? Many...

Hello forum friends, I could sure use some help here. Two separate tabs from my workbook are included in this thread. The formula in question is on the ‘income analysis’! tab and the data is all located on the ‘rrif’! tab. The OFFSET formula on the ‘income analysis’! tab works as intended...

Hello, I have sheet (VAT registrations) where certain columns are populated by VBA with todays date (N and P), based on condition selected by a drop down list. I have another summary sheet with few SUMIFS and COUNTIFS formulas, with ranges the columns populated by the VBA (N and P). The...

<tbody> A B C D E F Multiplier Z 10 10 1 Y 50 50 10 2 X 4 4 10 3 W 10 4 </tbody> <tbody> Enter # SUM </tbody> When I write "B" in the field "Enter #", I want that it shows the sum of the named column, in this case sum=(10*1)+(4*3)=22. How can I...

Hi all, I have an issue that's been at a dead stop for 2 days now. Prior to my arrival at my job, someone wrote a python script to process some data files. What the script actually does is irrelevant. But the way it was written, the user would start the python exe and then copy>paste the...

Hi, I"m trying to create coding that says, filter column 3 for anything other than N/A's, if Payout is populated, enter Yes in those columns of AA, if Takeover, enter Yes in column AC. I don't have an IF formula either, but that's what I would like. When I enter the code below, it's entering...

not sure if this can be done, but every day I download data via an Excel add-in ("transfer data from iseries") which I beleive is a way to download data from AS400. Every day, I need to click the Excel add-in, enter my user name and password (which is painful) then i tell the admin to start the...

I'm currently trying to create a tool that will call/run another macro/sub when the enter key is pressed on cell B4. Cell B4 will be the search field. Whenever someone types something in this field and hits enter on their keyboard I want another macro called "searchcontains" to run I've...

Hello - i have an excel file that has numerous tabs. Each have a name, what i am trying to do is in the main sheet, enter in the tab name so that the info that is copied will paste to the correct tab. see code below - i get an error on the top line. The Tab will change each time i go into the...

There are many other posts with people looking to find the end of the data in a column so they can enter new data in the next empty row - That is Not what I want! I have many rows of data that I need to step through and enter additional info. I want to start at the first row of of my sheet...