entry

Hi Friends, I have build a code to select the filtered data to copy and paste into another worksheet. However there is an issue with it. When there is only one entry found from filtered data, it throws an error coz it selects the data till last row of the sheet. Kindly help me to correct the...

Hi, My issue is this. I have a sheet where I would like the first few columns to permit any text entry, it is various serial codes. I would like coloumns D - P, be limited to what data can be entered. I have made drop down boxes and ticked the box to show error alert for invalid data entry...

Dear All, We have data entry from one spreadsheet (A) to another (B) as below: (A) <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> a b c d 1 99 99 81 54 2 67 69 66 94 3 50 64 91 57 4 62 59 91 57...

I have a worksheet that is used to make reservations for appointments in 1/5-hour increments. Occasionally a 1-hour slot is required, So, if a hour appointment is made, there is a second entry in these cell ranges B4:C10, B13:C17, E4:E10, E13:E17. I am trying to remove the second entry, &...

Hello, I have Excel for Mac 2019 und want to design UserForms in the VB editor. I can create new UserForms end edit them in the designer window but once the designer window was closed it cannot be reopened. With right click on the UserForm entry in the Projekt explorer there is no entry to open...

I am not certain if this is an excel issue or Citrix issue but it is worth a try. . . I am using Excel 2016 in a Citrix environment. When using the Data Validation list option I am unable to use the drop down if my source contains only one item. For example, I have a field where the only...

Hi, When i click on the drop down arrow to then show me all the customers in my drop down list the row after the last name is selected each time. Is it possible so when i click the drop down arrow i see it either at the top or the first entry.

Hello,<o:p></o:p> I am an Excel novice, but I need to complete this little tool ASAP, I’ve donesome research but realized very quickly I was either getting wrong or halfanswers. I’m hoping that the folks here can read the description of whatI want and lay out what I will need to...

Hi, I am trying to write a code where if Total row cell value is more than 4 so it should given an error msg box and restrict the user to do entry. i am using this code <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit...

Is there a way to set a passwordChar for an InputBox entry? I have been digging around for a while now. Can't seem to find anything viable. I want whatever i type into the InputBox look like asterisk just entering a password. Any help is appreciated

Hi I have a dynamic chart showing the last 90 days' entries and there are one or two spikes in the data that I want to comment on. Right now, the text box I added is fixed to where I inserted it in the chart so when the next entry is added it's out of position and therefore meaningless. Is it...

Need some help as my knowledge is limited and I’m struggling with syntax of my formula? This is what I have so far, Formula in K18: =IF(K16=0,"Select nozzle colour",IF(K17=0,"Select # passes",IF(AND(OR(K16="Red",K16="Blue"),"Select correct...

Hi all, I need a code if criteria is met with new entry last row entry Copy text data from cell to last row of another sheet example New entry in worksheet ("Shop") Column a "Car" is selected Copy and paste Column f to next blank row column ("D") of worksheet ("Report") then return to...

Hi, I am currently building a Rota in excel in which each colleague has their own "holiday" sheet. If there is an entry on the users sheet (want to reference the sheet by the name in cell D5 for example) and if there is an entry on their sheet or within the date in cell G3 for example then it...

I have a cell on Sheet1 which contains the formula =LOOKUP(2,1/(F:F<>""),F:F) This gives me the last entry in column F On Sheet2 and so on, I have this code in a module Function PrevSheet(RCell As Range) Dim xIndex As Long Application.Volatile xIndex = RCell.Worksheet.Index If...

At one of our facilities they desire to use Excel as an electronic version of a Log Book. The idea is instead of hand writing everything in a ledger, they would enter it into a spreadsheet. This would give us the ability to sort and report on entries based on date, day of week, key words...

Still trying to learn VBA and reached a stumbling block as I'm trying to build out a Mark to Market report. I have a 3rd party source that gives pricing which I'm wanting the user to enter into spreadsheet via input box. I have code that will allow them to just put in values going down the...

Dear Members, I would be extremely grateful if anyone could guide me in the right direction. I have appended two sheets using power query and made combined report. How can I make sure that if I make an entry and that entry is also updated in combined report ? So, I would like to enter numbers...

I'll try to state this clearly but that might be tough. I used to be able to enter a date in a cell by month/day enter and get the result month/day/current year. I'd type: 12/5 enter result 12/5/2018 Then I updated to MS Office 2016 and entered the date 12/7 enter and result 7/12/2018. I...

Hi, I have this code that searches for data entry of the process order entered in textbox1. What I would like is to expand the search to include previous years entries which are on another file and numerous worksheets. This is the other file: C:\Users\Dell\Desktop\PO Entry Copy.xlsm and the...