edit

I want to save the email in my local folder, and I saw this link https://www.mrexcel.com/forum/excel-questions/361751-vba-saving-email-only-after-send-pushed.html which basically use the class module to save the email after sending it out. However the problem is, the email saved is the preview...

I'm using this formula, which has been working perfectly... that is until it found 2 matches. How can I edit this so it shows the LAST matched value, instead of first??? =INDEX('Q3'!$F$1:'Q3'!$F$332,MATCH(K22,'Q3'!$AB$1:'Q3'!$AB$332,0)) Thanks.

I’m constructing an inventory file that’s ODBC linked. Said file will be handed off to a clerical assistant when finished. Can a user form be added to edit the query when adding client numbers, or will the user have to edit the actual sql script? If so, are there any tutorials that any of you...

I want to allow employees access to a workbook but not be able to edit anything in the workbook. I don't want them to have to use a password to open the workbook. If I protect the workbook then they would need a password to open the workbook. I don't want them to be able to change it from...

Afternoon, I have the code in use supplied below. You will see that the current range is G13:O17 but how would i then edit the code to include the range G27:O42 Private Sub Worksheet_Change(ByVal Target As Range)Dim C As Range, d As Range Set d = Intersect(Target, Range("G13:O17")) If d Is...

The data part of the macro I'm trying to create may be better suited for Access but it lays out better in Excel. I have 3 or 4 different data stores or the equivalent of tables. Very small business. Nothing to big. main employee list. A positions list they like to be able to edit. A training...

Hello folks, I have a worksheet that needs to be shared with other members of staff. The spreadsheet has been set up to have edit ranges that allow myself to edit the full spreadsheet and all other users to edit only portions of the sheet. The sheet is protected and shared to the other users...

I watched the amazing tips at this video posted at your youtube channel: <yt-formatted-string>Excel Magic Trick 981: 123.45M From Text To Number, 123,450,000 From Number to 123.45M</yt-formatted-string>but what if I have my table like this: 4m 284.6k 1.4m 10m 7.7m 698k 154k 2.7m 20k in case I...

I'm trying to graph two different data sets but the associated date range for each data set is different. When I try to edit the date range for each item is applies the edit to both. Is it possible to edit the data source they each have a unique date range? Thanks

Hello all, I have question I want to highlight cells to edit but not print in color en not send by email before cells are filled. I do not want to us black and white in the printing setup, because some features on the sheet must be printed in color. Hope somebody can help Thanks Steel010

Hi, On my excel sheet i press trl + K which brings up the Insert Hyperlink box. I have many Hyperlinks on my sheet and i wish to change the text that is in the the field named Text To Display. As opposed to going through each link & manually editing them is there a batch edit version etc. I...

I have an excel 2010 workbook which has a number of sheets whichhave two stages of protection 1 Fully locked for viewing only – Viewing Mode 2 Some unprotected areas for editing data - Edit Mode,selected by password protected button. I have a button for adding rows whilst in Edit Mode I wantto...

Good evening, I'm struggling with this one. I have given my sheet user specific permissions to edit the range of cells. After protecting the sheet, all users are still able to edit comments. I want to restrict all users from editing comments, and allow only those who I gave "edit"...

I have set up a gantt chart using excel formulas- with the start and end dates of activities, however I have been told that the activity only happens once every 2 weeks - can anyone help with the formula to edit what I have done so far.... =IF(AND(G$9>=$D18,G$9<=$E18),"X","") This is where I...

Hi, I was able to return multiple values into one cell; however, I am trying to figure out how to change my delimiter from"," to Char(10): For i = 0 To DEPListBox.ListCount - 1 If DEPListBox.Selected(i) Then 'If selected is True strTemp = strTemp &...

Hi, Could someone please help me edit this to make sure no duplicates are created? Sub RandPT_Ver2()Dim PT As Double, Num As Double PT = InputBox("Enter The Total Unique Names", "Enter a Number") Num = InputBox("Enter The 25% ", "Enter a Number") For X = 1 To Num Range(ActiveCell...

HI, I have set numerous range passwords to enable certain people to edit. for soe strange reason, once activated the cursor will not move around the spreadsheet properly, its all over the place? Any ideas appreciated...

Hi, I have allowed edit ranges for a number of different people. Once setup I have then locked the cells and protected the sheet. When I try and cursor around now, the cursor is erratic taking me everywhere but to the cell i want to change? Am I correct to lock the cells? I dont see how else...

Does anyone know why Microsoft has built Excel to where if sosmeone opens a file in read only, why I cannot open the file in edit mode? This is really frustrating, I need to edit the file and if I am not the first one to open the file, then I am not able to edit it and i have to go track down...

Hello everyone, I have this situation: =IF(Bdg!$B$9=1,Sch!AJ8+Sch!AN8, IF(Bdg!$B$9=2,Sch!AJ16+Sch!AN16, IF(Bdg!$B$9=3,Sch!AJ24+Sch!AN24, ..., IF(Bdg!$B$9=12,Sch!AJ96+Sch!AN96) where Bdg(B9) has the number of the current month and Sch(AJ+AN) have values to add up in a pattern of 8 rows apart for...