excal 2016

Good evening, I am building a supplier onboarding tracker in Excel and need a pivot table that shows only the supplier names (column F) using the data in column AG. Is this possible or is there an easier way? ABCDEFAG2VNIPACM_IDSM_ID - ARIBATILE SELECTIONSUPPLIER NAMETRR...

Hi This is just a question. Is there an access log that is stored somewhere on excel? to show who and when people open a file? I seem to think there used to be but with my memory I may have imagined it. Thank you

Hi, I have around 400 workbooks are named "1.xlsx, 2.xlsx....400.xlsx" in same folder, because they have merged cells I can't do VLOOKUP, so I need to pick this data manually by ='C:\Users\Documents\2023\Data\RawData-Mar\[1.xlsx]Sheet1'!$C$4 so, I need to file name be changed to match serial...

hi I need to search sender e-mail address excluding microsoft and no-reply@notify.aol.com for a date. This code work for microsoft only. Filter = "@SQL= (NOT urn:schemas:httpmail:fromemail like '%microsoft%'" & _ " And urn:schemas:httpmail:datereceived = " & daterec& "))" But when...

Hi Experts i was wondering if there any way to reset the value back to Zero if certian value found for example i have got an formula on excel whereby it calculate and add all the "S" from a range "B11:AF33" however is there anyway also back to 0 value if "ar" found within the same range...

Hi guys i need some help on VBA. I have range of numbers in Sheet 1 from cells A6:O29. Next i have specific numbers selected in Sheet 3 in Column "B" I want to loop throw each value in Sheet 3 Column "B" and find that specific value in Sheet 1 range "A6:O29" Next it should paste Entire Row...

ABCDEFG8NATURALGAS20JULFUT#DIV/0!#DIV/0!9NATURALGAS20AUGFUT#DIV/0!#DIV/0!10NATURALGAS20JULFUT0011NATURALGAS20AUGFUT#NAME?#NAME?12NATURALGAS20JULFUT0013NATURALGAS20AUGFUT#NAME?#NAME?14NATURALGAS20JULFUT0015NATURALGAS20AUGFUT#NAME?#NAME?F8F8=IF(ALGO!E24>1.8,"SE ",IF(ALGO!E24<-1.8,"LE","No...

So, I created a series of formula on a sheet called Extractor in a workbook called "Processor*". The filename of the workbook "Processor*" will usually vary, having other characters to the right of it. My intention is to copy the range covering all formula I created in a sheet named "Extractor"...

Hello, I have various sheets in excel approximately 30 to 35 sheets, basically one for each SKU i have a main sheet in which i will enter that days sales or purchase for all the SKU'S they should get posted in their respective sheets. I am attaching a sample sheet, Kindly guide me on how to do...

I have a pretty large workbook, with one main worksheet running quite a few formulas and arrays, pulling from various other worksheets in the workbook (that are essentially the reference databases) as well as one large worksheet that essentially contains thousands of replicated functions from...

I have the following code that works but it replaces the entire line. I need multiple ranges. I tried but when I posed something in column it overwrote all the other cell dates. I need each to be stamped individually so I missed something. I apologize ahead of time. I'm new - trying hard...