help me please

Hello all, I hope that someone can help me out with a VBA I am trying to write. I am hoping to create an input box that has four blank inputs 1) Description 2) Total amount 3) Amount paid 4) This period amount Then, once I run the macro, I want each of these inputs to fill into the next...

I need to fill the field next to 'Enter your TIN'(Highlighted in image) and Enter Mon... Following is the code I had written for entering the TIN... When I use the above code to fill the value, it is giving me a run time error '1004'...The cell or chart you are trying to change is on a...

I have a workbook that has many columns (A to BH). All of the cells from A3:BG2383 are locked and the whole column BH3:BH2383 is unlocked ( I need people to input info there). Is there a way that I can protect every cell except for the cells in column BH but still be able to filter and have...

Hello, Excel semi-noob here, I have a vlookup issue that has been driving me crazy. I am working from a sheet (in workbook A) that has a list of usernames in column E. These usernames also exist in column B of Workbook B but they contain an extra five or six charactes at the end of the string...

I'm having difficulty understanding a step in this Excel homework project. I've figured everything out up until this one step, and it just so happens that if I mess it up I will end up sacrificing 30 points (as the next steps depend on doing it correctly). Here are the instructions: 'Use the...

hi everybody, im getting my head around excel and ive managed to create a fully working dashboard for my company, however, i am now requested to put this "dash" on the local intranet. i have saved it as a web file, but when i open the web version, most images and buttons have moved to the right...

Hello all. I've been having an issue using =INDEX(array,MATCH(),MATCH()) sort of function. I'm using it to solve an inconsistency in my data file. Here is a link to where you can download: https://drive.google.com/file/d/0B2w1gR_HKEaYdWVHalNQNnJkbEU/edit?usp=sharing Viewing it there is crappy...

I am stuck. I am trying to add a multiple time stamps to a google doc spreadsheet. I have figured out how to add a time stamp formula to a blank column. I created the script below: function timestamp() { return new Date() } And added the formula: =IF(ISBLANK(F3),,TIMESTAMP(F3)) to the column I...

Hi All, I am very new to this and have been assisted to utilize VBA code for an excel spreadsheet. After a number of months using the code i realized that the intended operation was not happening and instead i started to loose data. The reason for the code that i have is to move a row of data...

I have written arrays to populate the following information: 1) the number in the 1st cell in the range containing a NUMBER to F5: {=INDEX(N5:AR5,MATCH(TRUE,ISNUMBER(N5:AR5),0))} 2) the number in the cell at the top of the page that corresponds with the cell found by this array to E5...

Hi, I'm new to this and I hope I explain this the right way. I've managed to write two index arrays, one to find the first cell with a number and the last cell with a number in a row range and populate each of these to a cell: range is N5:AR5 1st cell with number populates to F5 per array in...

i keep getting an error can some1 look at this and help me fix this code? or help me with the notes in this code Sub sendemail(what_address As String, subject_line As String, mail_body As String) Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application")...

<tbody> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> Button <here></here> column letters BA BB BC BD BE BF...

i want to type something in "B1" and then if it is in sheet 1,2,5 it will get delete and then adds the word "changed" the next cell to the right in "Column B" Private Sub CommandButton2_Click() For Each cell In Range(Cells(1, "A"), Cells(Cells(Rows.Count, "A").End(xlUp).Row, "A"))...

Hello, Here is what I need help with and I’ll use examples: on sheet1 I have Column A(names) and Column B(address) on sheet2 I have Column A(names), B(address) and C(state) if the names and address match on sheet1 and sheet2 I need to show C(state) on sheet1. If there is no match then it is...

right now I have in column A =worksheet2!$A$2 and column B =Worksheet2!$B$1 for the first 41 cells and then the next 41 cells I have =worksheet2!$A$2 and column B =Worksheet2!$C$1. and so on. Problem is I would have to type this over and over again for 100s of different cells. Is there a...

I have created a youtube video of my problem. Please help. All I need to do is drag down a formula to reference a new sheet. I can not figure out how to do it.Excel Help Please - YouTube

I'm hoping somebody out there can either create a macro, or help with a formula that will save me hours upon hours of work. This is a confusing stuff, but hopefully I can spell it out enough to get some help... :( I manage a bunch of data in a massive Excel spreadsheet. Unfortunately, I can't...

Hi, I need a formulae (if possible) for the following but I'm not great with excel so any help is appreciated. I have a list of cells in column A which have data such as ''TP101 0.00-0.10 1' which is together in one cell. (which for anyone that is wondering is a location, a top depth, a base...

How can I write a formula to display data as per the below? The 239.555 is cell C2. The months going horizontally start from E3, going vertically they start from B5. In E5 I am up to here with the formula (needs to be dragged across and down) so as to apply the pattern below to each row...