entered

Hi guys. I'm creating a bank statement format on excel; but need help in the balance column. I want the amount to be displayed only if the value is entered in debit credit columns (either 1 column). A B C...

I'm trying to create a user form that opens up any time a cell in a table (or anywhere in a specified range) is selected, that will input data from the user form to the end of the table. I would also like data not entered in the user form to be auto filled in the same row, such as the current...

I am completely ignorant of all things VBA and would be unbelievably grateful if someone could help me with this scenario: I, along with other colleagues, complete 6 different tasks numerous times a day and capture each completed task on the relevant spreadsheet (6 spreadsheets in total - let’s...

I have entered Roll Nos in B2, B3, B4 and B5 (1706571, 1706572, 1706573, 1706574) and I want their percentages to be entered in column C2, C3, C4 and C5 respectively for which i have written a vba code. But this code is only showing value for cell B2 and not for rest data, moreover percentage...

Hi, is it possible to get a pivot table to display a text value (persons name) multiple times? For example, I enter a persons name, 'John Smith', and a number '225588'. If John smith or another John smith information is entered again the pivot table automatically combines the name as one, John...

Good evening all, I am trying to identify what the last communications are from a large range/list of data All I need is "Latest Communication" if the date from C12:F12:10003 and job from F12:F10003 is the last entered or if the only one entered Each job may have been communicated more than...

I've been working for sometime on creating an accurate payroll environment within excel, and I'm finally close, but ran into an issue I could use the expertise of this forum with. The workbook contains sheets for each month (January to December) separated by Quarterly sheets that populate from...

Hi all, I have a Google worksheet where I count the days from a manually entered date, column E. The number of days passed is then calculated into column N. E3 - Date (this is manually entered) N3 - Age (in days) using the following formula - =IF(E3="","",(Today()-E3)) L3 - Status - this is...

Using Excel 2010 & 2007 Windows 10 I would really appreciate some more help regarding a macro, please. I've had help to get this macro but, (as in a similiar issue with a macro to sort column in date order - since solved) when I run the macro to sort Column 'C', containing names, into...

Hello, I want a zero number in the cell A1 When a data was entered in the cell A1 I deleted it later The zero number is entered in the cell by default. Thank you in advance

We use Excel to fill out some preprinted government forms on a shared computer. Someone changed the font resulting in legal issues when the next document was printed out. How do I lock the font so data entered always uses a specific font? I can see how to do it in Word, but we have to use Excel...

I have a snippet of code below that is supposed to compare the date entered in TextBox4 with a reference date in TextBox16. If the two match, then it makes TextBox4 blank (this reduced clutter on a worksheet with mostly the same dates). My problem is that if "5/15/19" is entered into TextBox4...

For example I enter 01/05/19 The 1st of April 2019 in my userbox Exit the macro 05/01/19 is entered in the cell instead. Sheets("View").Range("B3").Value = Me.Specifictext.Value I can only assume this is a Microsoft feature that reverts the value to American.

Hi Setting up a document where I need to put in the total budget that each client had. Many will be, say, in the ilk of £120,000 whilst others might be £38.4m - is there a way to ensure that when the numbers are entered: £120,500 would be displayed as £120.5k £38,400,000 would display as...

<tbody> 1 1 15 2 16 27 3 28 41 4 42 53 5 54 66 6 67 78 7 79 91 8 92 103 9 104 116 10 117 128 11 129 141 12 142 153 13 154 166 14 167 178 15 179 191 16 192 203 17 204 216 18 217 228 19 229 241 </tbody> Looking for a formula for...

Hi I have the current date in column A1:a7, ( Automatically populated when excel sheet opens by vba.) In column C1:C7 I have invoice Value Manual entered. In column E1:E7 I have invoice due date Manual entered. In column G1:G7 I want invoice Value entered when invoice date equals the current...

Hello The helper or guide for excel no longer appears. For instance in the past I would be typing code and a "helper" would pop up. In a module, If I entered Columns. a drop down box with all the available choices would appear. Or if I entered Columns.Find( the properties needed for each comma...

I am looking to use format cells options to have a prompt that shows up in the cell to give direction such as "Enter Work Code Here" or " Work code Here" when there is nothing in the cell. Once its been entered, the messages is not long displayed unless the number and letters are entered...

I've created a box on my data entry UserForm for entering 1 of 5 numbers Once the "Submit" button is clicked, how can I make that number entered direct the data entries to the corresponding sheet? Example: UserForm. 2 is entered. Data is entered. Submit. The data is now listed on...

I'm doing a form that tracks data entered in real time. I've created a box where the user enters the day of the month (i.e. 1,2,31). I want to make that number refer to the corresponding sheet in the same workbook, where entered data entered will populate. It's not an elegant system by any...