VBA Code Used to Split off Worksheets and email them. Can I add text to the body of email
Excel Help Forum
by jartukovich
55m ago
Some years ago I was assisted by your site with the following VBA code which splits off excel worksheets and emails it to the email contained in cells K1:k2. This has been working for me for years perfectly! And an incredible time saver! Sub EmailReport() 'copy each sheet into a new workbook 'and email it to the address in cells K1:K2 For i = 1 To Sheets.Count Sheets(i).Select Sheets(i).Copy ActiveWorkbook.SendMail Recipients:=Range("K1:K2").Value, Subject:="DAILY STATUS REPORT" ActiveWindow.Close SaveChanges:=False Next End Sub Private Sub Workbook_Open() End Sub My question is: Can I ad ..read more
Visit website
Xlookup Help to produce a number if not found on prior tab
Excel Help Forum
by atoice
55m ago
Hello Community, I am looking for some help and I'm sure someone here knows. I am new to the Xlookup formula and I am trying to return a formula if result is not found. So, currently it sits as: =xlookup(d4,'2024'!D:D,'2024'!B:B, "not found",0) That works and returns "Not Found" when it cannot find the value. What I would like it to do is return the max number in a column +1. So, I tried =XLOOKUP(D2,'2024'!D:D,'2024'!B:B,MAX(B:B)+1,0) which returns an error. =XLOOKUP(D2,'2024'!D:D,'2024'!B:B,25000+1,0) which returns 25001 the whole way. =XLOOKUP(D2,'2024'!D:D,'2024'!B:B,B1+1,0) which wor ..read more
Visit website
Nested XLOOKUP help
Excel Help Forum
by ExcelDavid5
55m ago
In need of XLOOKUP help! Attached is the Sheet VENDOR NAME I am struggling to write an XLOOKUP formula that will give the desired outcome in Truck Template G2 through G4. The formula will live in column G of the Truck Template tab. I need it to take the Material Code in column A and compare it to Code column (column E on the Materials tab). I need it to find the correct line in the Materials tab and return the vendor name (Materials V1 through X1) with the value of 1 in V2 through X4. I tried to use =XLOOKUP(A2,Materials!E2:E4,(XLOOKUP(Z1,Materials!V1:X1,Materials!V2:X4))) Z1 is a referenc ..read more
Visit website
Runing a macro into another workbook
Excel Help Forum
by Sokol
55m ago
I'd like to build a macro in a workbook ( A) which does: 1) Open another workbook ( B) 2) Update some cells in (B) which are the parameters for a macro already built in (B) , called "get data" (Parameter one-> the path, parameter two -> name of the file with data) 3) Run the macro in (B) which upload the data in a spreadsheet of (B), 4) Save B and close it. If I open B and update manually the parameters ( specific cells in the first page ) and run the macro "Get data", it works perfectly. But if I call this macro from another workbook , it gives me "error messages ..read more
Visit website
Excel, counting work time with lookup function.
Excel Help Forum
by Gleisner2
55m ago
Any help is appreciated Only need help with the lookup function, Cells: D7 To add correctly D10 through D14 to add correctly I’m having formula trouble looking up and adding time worked in one day, a week, and a month. I’ve tried many formulas and formats but can’t get the correct time worked. Using named ranges, Formatting is as shown. Thanks, Attached Files Time2.xlsx‎ (43.1 KB) Download ..read more
Visit website
Complex (I think) calculation
Excel Help Forum
by ldoodle
2h ago
Hi, We have a price tool where we add a % margin to our buy price. Sometimes we need to sell something via an industry framework and if we're not on that framework we have to go through a provider that is. These providers charge us for it, usually a %. We send them a particular sheet that they copy the rows from into their own tool and add the %. So what I need to be able to calculate is an appropriate reduction on our direct sale price so that when the framework provider adds their % back on, it equals the exact same value as our direct sale price, AND I need this all rounded to 2 decimal p ..read more
Visit website
Dliminate a slope on an Excel graph for values that have not yet been inputted (0 values)
Excel Help Forum
by Excel_Struggler
2h ago
Hi! I have an Excel graph that receives weekly data input. Currently, the graph simply reverts to 0 or the lowest value on the Y-axis for the next point yet to be inputted. Is it possible to hide the slope until data is inputted for the corresponding week? Picture of graph: Sk?rmbillede 2024-03-27 kl. 19.59.52.png Graph data: Sk?rmbillede 2024-03-28 kl. 18.34.47.png Each of the cells has a formula similar to this, only criteria and week can change. I tried using NA or "" to make the graph ignore the 0 values but no luck. Code: =MAX( IF('Styrke, Uge 3'!B3="Comp Bench"; 'Styrke, Uge 3'!W ..read more
Visit website
Question about conditional formatting
Excel Help Forum
by xraymiller
2h ago
I have a column of numbers for every day of the year (365 entries). These number represent a Quality Control number. I already have a cell to calculate the average of the total population of numbers. At the moment I have each cell conditionally formatted to highlight the cell red if the number in each cell is 10% over or under the mean average. The problem I am having right now is that as the value of the QC changes over the year, it is retroactively applying that conditional formatting prior values, and I don't want it to do that. I don't want to retroactively change numbers that were once w ..read more
Visit website
Finding completion date from a waterfall production schedule
Excel Help Forum
by skagit07
2h ago
Hello all, I'm working with a production schedule where we're producing cars of different colors in a repeating sequence. I have a planned schedule, and a recovery schedule for when the plan is disrupted. Data is listed in Row 2 & Row 3 for Red Car #1. As more and more car builds are added to the schedule, I want to be able to pull the completion dates and place them into my "Completion Dates" tab in column C. I want the formulas for column C to look for the combination of text from column A & B and find them in the "Schedule" tab, and return the date in Row 1 that is listed for that ..read more
Visit website
Find another row in a table whose first two columns match and determine value of third
Excel Help Forum
by WrenchHammer
3h ago
My company's employee hour tracking program outputs absence information in a specific format which I then need to translate into another format for manual input into a second program. I am well underway in automating this translation, but I am having trouble discriminating between multiple absence codes for a single individual on a single day; I am required to only log the absence code correlating to the greatest number of hours in that day, rounded to the nearest whole number, but no less than 1. For example, if an employee uses 3 hours of sick time (absence code S) and 5 hours of vacation (a ..read more
Visit website

Follow Excel Help Forum on FeedSpot

Continue with Google
Continue with Apple
OR