enter

I was asked to help my boyfriend on a vlookup with multiple conditions. I know that requires using Index Match and using them as an array formula. However when he went to hit "enter" he didn't want to use "ctrl, shift, enter" as I told him but it still ended up working. At work today I...

Sorry - no idea how to explain this, let alone do it! Think it's an index/match combo but just can't get it to work... Anyway what I'm trying to do: On sheet 1 we enter all of the entrants names and some other details in A-D, then in cells E-Z you can type in what classes they're entering...

I using this code that formats the number as I type. I would like to make more dynamic to be able to choose the format base on a variable enter in another textbox. Currently the format is hard coded to two zeros after the decimal. I would like to enter (ex. 3) and the format would show $0.000...

Hi I have a sheet column C contains a formula +wo 1'!n1 this looks a cell on sheet wo 1 what I want to do id if cell B is blank enter 0 if not pull in n1 from sheet wo 1 thanks steve

Hello All, I have a formula that looks at 3 different sheets to validate if the value is in a range but I need help updating or using another method to enter the forumla. Here is what I got so far but its not all the way there. Formula: =IF(COUNTIF('Drama &...

Need help finding a formula for the following conditions: If AV14="Yes" AND AV76 is a number, then enter the value of AV76, BUT if AV14="No" then enter "N/A". Any help would be appreciated. Thank you!

Hi, I've had a search but can't find a similar question. I am trying to get whatever a user has just typed into a cell and copy it to a different worksheet. I figured this was best to run in the SheetSelectionChange section, the idea being someone types something into cell B4 (or any cell)...

Hello, I have the following code attached below that I have created and would like to copy the data that is input into the UserForm into multiple cells. For example lets say I have a textbox called TXTBX_Meals and I enter a Value of $12.00 I would like to populate the cell that is designated...

I have the following code below Sub Input_Data() Sub Input_Data () Dim myValue As Variant myValue = InputBox("Enter The net income amount") Range("B3").Value = myValue myValue = InputBox("Enter Tax rate") Range("F4").Value = myValue End Sub I would like the following amended...

I need to create a gantt chart that will draw horizontal bars when I enter start and finish dates. The user would enter the item description, start date, and duration (in work days). Questions: - To get the finish date...I add the duration to the start date. How do I format the resulting...

Hi Team, Thanks for your support !! Need a help in macro. My requirement is “ I need to open a webpage à Click on submit button à Enter the Request ID à Press Enter à Need to copy the data from the text box (it may be Read only or editable option) I am able to do the function till entering the...

If I have two Quantities and two Unit Prices, is the a formula that will forecast another qty? Qty 100 = $25.00 Qty 500 = 10.50 Is there a formula that would forecast Qty 300 or any other quantity I enter that is between 100 and 500 (Using a straight line)? Thanks

Looking for help with the below.... Basically, I want to track the status of an item. If i am to enter a date lets say in column C which is titled " Item setup date" i would like the status in column B to automatically change of i enter that date. But again, if i enter data further down...

Looking for help writing a MACRO to undertake the following. I have a spreadsheet with multiple tabs x 11 - these tabs have team names, for example North, South, West, East. My existing MACRO transfers all of the tabs to a Summary tab at the end. However I have found that when I do this I...

I have two columns one with heights (i.e. 6'6", 6'7" etc) and one with weights say column I and J. In another cell C2 I would like to be able to enter a height, while still displaying height, yet for a calculation use the corresponding weight.

Hi hope youcan help me please, I have attached the file below which I am stuck on, I havea user form ‘enter expenses’ but when I try to enter number/letter combinationin the boxes for Airfare, accommodation, ground transport and food and drink,the box goes red when I click on update and it...

I have a user form label that displays an ID tag. This ID Tag is also in a list in column AA. I would like to look up the Userform ID Tag in the list in Column AA and enter a number value adjacent to the ID Tag in column AB in VBA. Can someone assist a VBA code that will accomplish this...

I'm sure you've seen this subject before but I am pulling out my hair. Excel is getting worse and worse at hanging while I'm using it. I'm using Office 365 with a Windows 10 PC, stand-alone. I'm also using OneDrive and just a hunch that it is playing a part in what's going on. BUT it will also...

Morning all, Looking for assistance on setting up a Macro to update at a set time every evening. Currently our team has excel sets that perform data pulls every morning using a macro called "Update". I was wondering if I can enter a code into this Macro to run at 3am daily? Can anyone advise...

Hello All I am trying to automate a task that is completed every day on a spreadsheet. I have an inventory tab, which contains the stock details of some 1200 different products. Each day we consume some of these products and update the inventory sheet using the find function and manually...