stuck

I have dates that are formatted a: 1012019 1022019 4012018 What I need to do is to take those dates and minus 1 from them: 1012019 = 12312018 1022019 = 1012019 4012018 = 3312018 I have a formula that I figured out below (It works but do not know if it the best solution)...

Hello all, I hope that someone more experienced than I in here can help me where I have gotten stuck :) I have the following workbook: In this work book, I have a list of sales in different categories, and I am trying to show a ranked list for a selected Category, what the Sales and the...

Hello, We created a macro to send out personalized emails to our customers with each individual email having an attachment of that certain customers invoice. When running the macro I seem to keep getting stuck where it says : MyAttachments.Add(attachment). Not sure if there is some way to...

Please help i have to combine these 2 formulas each has the criteria I need just stuck on putting them together. =SUM(COUNTIFS($P:$P,"<> / /",$D:$D,">="&$B9,$D:$D,"<="&$C9,$A:$A,$D$5)) And =AND($T:$T>=EDATE($P:$P,-2),$T:$T<=EDATE($P:$P,2)) Any help most appreciated ?

Hi all, New to the forums, keep up the good work. Getting stuck on getting a cell with a value of 1-10, separated out into its individual values i.e 1,2,3,4,5,6,7,8,9,10 Another example is 50-60 again, i want to separated the values out like: 50,51,52... and so on... Can anyone help? I...

I am trying to create a pivot table with multiple sources (I have 4 tables). It is stuck on loading data model. Can someone help? I have several worksheets that I have pivot tables that I have done this with, that also all of the sudden, will not load.

Hello Guys, Searched net way too much and could not find solution to my problem. Will try to explain as clear as possible what I am trying to do. I tried to do simple weighbridge userform with simple stock control but I am stuck... Since I cannot add any photos, I will try to explain what I am...

Hi all I have been stuck on this for some time now and would appreciate some expert advice... I have column A and B which both have a very simple formula in all the way down to row 500 which simply pulls in the data from another worksheet within the book in this case it is a name. The...

Hi all, This forum has always helped me when I get stuck with excel vba. I need help again. I am trying to copy a worksheet named "Work" as "Job" in same workbook and trying to protect "Job" sheet. I came up to following code and I am stuck. Please help. Sub RenameSht() Dim ws As Worksheet...

Having a brain cramp.... In Cell A3, I have a formula that is based on A1 and A2 Cell A4 should display 0 if A3 is greater than 0, but should show the absolute value of (A3 x5) IF A3 is negative Tried a few things, but I am stuck.....much thanks in advance for the help. In the meantime, i...

I am creating an Incentive plan in excel . Need help. I would suggest a call instead of message. I am stuck at if else statement. Regards, ID

Hi there, recently been trying to use Query function in google sheet. What I'm trying to do is combine certain data from all the tabs into 1 Master Summary for easy review. However I'm kind of stuck at the part where I need put multiple tabs in the formula, much appreciated! <style...

Hello, i am trying to change all my existing formulas which were recorded into vba code, rather than paste it in and copy to last row which the current marco does. to be honest , i am stuck on how to write the following as VBA code, could anyone help me...

Hello, I have a list of data in which I would like to delete the entire row if the text on column A is in lowercase. I am stuck to write a VBA for this one, could anyone help me with this please. Thank you.

Hi all, i have an issue, i collect data from a site and each page is associated with a url that contains a date, the problem i have is i am getting data that is stuck on one date, it's not clearing the old data even if i clear it and change the date.

Dear Excel Community, I currently have a sheet with data resembling this: <colgroup><col><col></colgroup><tbody> Plan Days Intended 13 Unintended 12 Intended 14 Intended 15 Intended 16 Unintended 8 </tbody> As the conditional formatting function does not allow...

Hello, I would like to call a Sub anywhere in my workbook to delete all columns containing "*" in the header of one specific worksheet "data". several postings I tried work ok on a few columns, buy my 'data" sheet contains about 200 columns (so the sub gets stuck and I have to abort...) I...

Hi all, I need both the list and the value of a combobox to update from the macro initiated from another combobox. So imagine I have a Combobox called "Region". And another combobox called "Countries". Both are defaulted to "All" as the selection until an action is taken. If a user selects...

Hello, I have several columns which contain numbers. I'd like to use TEXTJOIN with IF so that if, say column J includes the number 1 and column M also contains the number 1, then the column headers will be concatenated/joined (so the result would be "J, M". I've made various unsuccessful...

I currently have a form where sheet 2 is being filled by a cell reference and the following formula: **=IFERROR(IF(E1="volume",INDEX(Sheet1!$B$14:$B$9999,SMALL(IF(Sheet1!$B$14:$B$9999<>"",ROW(Sheet1!$B$14:$B$9999)-ROW(Sheet1!$B$14)+1),COUNTIF($E$1:E1,"item...