back

Hello, I've built a program in excel VBA that creates emails and attaches invoices based on a distribution list. The program creates drafts of the email and saves them for review before we manually send them. The issue is that every single e-mail came back undeliverable. This is the e-mail I...

Hi, I have data in this format: <colgroup><col><col><col><col></colgroup><tbody> CID "C-00001" "C-00002" "C-00003" Name Alexandra Van de Vyvere Nathalie Pouradier Duteil Thomas Raguenaud Waist 75 79 88 Half Waist Front 39 40 Half Waist Back 37 39 Hips 92 98 104 Half Hips Front...

Hello, My apologies if this has been asked before. I read through several threads and can't seem to find exactly what I need. Basically, in column A, there is a list of locations in groups of two that the names in column B are assigned to in pairs. The list in column B is larger than the...

Hello. I have done this a thousand times before (well maybe hundreds) w/o issue. However, for some reason I can get anything to return on the following: =INDEX('Flood Report'!$X$2:$X$15000,MATCH($A22,'Flood Report'!$AN$2:$AN$15000,0)) If I do a CountIf('Flood Report'!$AN$2:$AN$15000,$A22)...

Hi all, Workflow below ALL Code resides in sheet "Super Automation" Information is gathered on "Ads" tab and brought into "adstemp" Advert Data is opened and relevant tours gathered Advert Data closed, tourlist is loaded into Automation Hub Several spreadsheets are now opened (Regional Press...

That's it really. I don't want to be having to use passwords to protect a sheet in any way so want to use just VBA. I have to apply this to N5:N5000 so that no one can edit, delete, cut, remove the formula that is in there. I did find great code for this once but it was years ago and I can't...

Hi I want to take out a loan for 25,000,000 at 7% annual fixed interest rate and make month end monthly repayments. I want to take out the loan immediately "month 0" but not start paying it back until month 7... because I won't have any income for 6 months. I must pay the whole lot back by...

NoTours:Resume Skip Skip: ads.Activate ActiveCell.Offset(1, 0).Activate WB.Save For some reason after I hit WB.Save, it goes back to "NoTours" and just goes over and over. Do I need to insert something after the WB.Save to stop it returning to NoTours? Thanks.

In column G I need to see the SUM of column D from the row i'm currently on up to row 3 is there a way to write a formula that when i copy it down it automatically expands the sum cells? so if i'm in G20 it sums D20 all the way back to D3 and then if i drag that formula down it automatically...

I have simple table below that will work out return and place into E1 if a W is placed into C1 Back Odds W/L Formula Result 15.00 2.5 W =IF(C1,"W",A1*B1 37.50 how can I change the Formula to also check if a L is placed into C1 and show the result as a minus figure...

So this has happened now 2 days in a row -- I administer an Access DB with 12-15 users -- each user has an .accde copy of the front end on their desktop and the back end is on a shared server. I got a call saying that all of a sudden nobody could add a new entry to the db. I look into it...

Hi everyone, I would like to find a formula that will calculate how may cells back when a digit appeared. For example, A1 = 2 B1 = 2 C1 = 2 2-2-2 9-7-0 8-1-3 1-4-3 7-3-5 9-2-9 6-6-8 2-0-7 1-4-8 7-7-2 Step1: Count how many cells back until the 1st digit 2. In this example the 1st 2 is 5...

Hello, I have a spreadsheet that's giving me a very strange issue. Sometimes when I paste special values, or change a number being used in a calculation, I get a partial overlay from a different tab on top of my current tab. Here is a screenshot showing the issue: https://imgur.com/a/YG1mfUF...

Hello I want to use back references and regex with Search and Replace, is it possible? Thanks!

I am trying setup an index match but I have 2 of the same value. How can I setup my index match to bring back the second match? thanks

Hi, We export data into a workbook, all of the product codes are 4 digits but they are in text format. When i go to do lookups they dont work unless I paste the product codes into notepad and then back into word again. So 2 questions here I suppose: 1. Is there an easier way to do this rather...

Results to show in columns F,G and H. Please if possible don't use VB scripts I would like excel to look at the days number in column A (7/6/2018 = 6), then go back that many days (including the day). For example: In Column A, If today is the 6th, then go back 6th,5th,4th,3rd,2nd, to the 1st...

When I import or export modules from the VBE, my default path was where I wanted it until this past week when I somehow hosed it, and now I have to navigate to get back to it each time I restart Excel (it remains stable in each session). Does anyone know how to change the default path...

Hi everyone. Seven years ago I wrote a large workbook as a favour for a friend. I protected a lot of cells to avoid accidental corruption. He has just come back to me and asked for some changes. I gave him the password but as hes never needed it he's forgotten it and my email storage doesn't go...

Hi, I'm trying to use a Vlookup to use different ranges within an existing Vlookup depending on what's in column B. =VLOOKUP(A2,VLOOKUP(B2,StaticData!$A$2:$X$21,24,FALSE),2,FALSE) I'm getting an #value because the range is coming back with speech marks around it... Any help appreciated...