created

I am working on converting an excel Master Sheet into a userform. I didn't create the Excel Workbook, which has about 16 worksheet in it, but I have to update it. Most of the information in each of the 15 or so worksheets are repetitive information, that is why the person created a Master...

Hello everyone, long time lurker and big fan of the site. It's helped me many times. I'm hoping you can help with a question Basically: 1) I've created a slicer for a pivot table 2) I created a "Custom List" through Options-Advanced to rearrange the order of the items inside the slicer to what...

Book1ABCDEFGH1VendorOrder RefCreation DateTotal PO AmountPO CurrencyDocumentPayment AmountPayment Date21000010034B111111112/24/2018191.78USD5100006334203.841/17/201931000010034B111111112/24/2018191.78USD00.0041000010034C11111112/4/2019400.00USD00.0056Desired output:78VendorOrder RefCreation...

Hello Everyone , I have created a macro to copy the active worksheet and paste a new one. I want to make a slight modification to it : The newly created worksheet to be pasted on the left side of the workbook rather than on the right (My team is used to this format). Dim sName As String...

Hi. There is a way to apply the same cell comment to new rows that be created using TAB key? Thanks for your time.

I have created 5 workbooks or sheets which have VBA and macros in them. I have created a new workbook with a userform in it . I would like to copy those other workbooks and sheet into the new one with all formatting and coding. tyvm

Hi, I'm looking for a way to remove time from a text cell so it just shows the other contents. EX: 07/02/2019 9:00:30 AM CREATED to 07/02/2019 Created Thank you for the help both in the past and now.

I have been looking for a VBA code that will basically take information from my worksheet and create a new sheet for every row. I have a template that I would like my data to autopopulate so that each new sheet is in the specific format I would like it in. anyone know how to do this?

Hey everyone its been a few years since I accessed the board. My question is I have a table that is generated through another program into excel. I created the Pivot Table off of this table. But ever time I generate the table the pivot table loses settings. How do I keep this static?

Hi All I am new to power bi so hoping you can help me I have created multiple pivot tables from different sources and have created a dashboard At the back of it ive created slicers which i need to now link to pivot tables from different sources which is now why ive created a bridge table...

Trying to create a measure that an end user could grab and not have to worry about filtering to get the numbers narrowed down appropriately. Sum of gl transactions measure below. Works, but end users would have to know how to manipulate the filters on Acct Fin Class Code, Acct Prop Class...

Hello all, It is been long time since i came here asking your help. I hope i can find once again help from you all. I'll put it by steps: Step 1: I need help to create a VBA that will copy a Template sheet to a new workbook (as many times the list has starting on row 2 until the last) the...

HI. I have created a tracking sheet which takes data from another excel sheet by refreshing links every 30 seconds (would use share workbook but function not enabled by my work). I have created a macro to play every time a cell in a range is changed to a value above 0 but it reads every refresh...

Hi I have created a pivot Graph using data from a table However i would like to make a few copies of the Pivot chart graph i have created and set it up so it shows different outputs using the same data. E.G - The graph i currently have created is a stacked bar graphs which shows the split by...

Hi everyone, I had created same thread https://www.mrexcel.com/forum/excel-questions/1098491-if-values-column-d-matches-then.html but as i couldn't view that thread i have created this. Here i am trying to check the values in column 'D' and if the values in column 'D' matches then in column B...

I connected to our oracle DB with 40million+ rows of data tied to over 110k+product. These data refers to medical services and copay info. 1product consists of 350 services/rows. To narrow it down, I created a query to pull product created 365 days prior to current date. Loaded it to the data...

Here is my existing code. I would like to NOT print the gridlines. I thought I could just add "PrintGridlines:=False", but that didn't work. <code> Else 'export to PDF in current folder wsA.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=strPathFile, _...

I'm new to VBA in excel and I borrowed this code from a previous thread that has worked well. It takes each value from column B in my main tab and creates a named tab with the format of the CONTROL tab and hyperlinks it in the original tab. My problem is that each tab, although correctly named...

Hi, I've created several different Macros for Filtering a spreadsheet for defined values (SKUs) but occasionally these values change. I was wondering is possible to create a macro in VBA that filters a spreadsheet based on all the values in a column on a different sheet in a different file? I...

I'm new to VBA in excel and I borrowed this code from a previous thread that has worked well. It takes each value from column B in my main tab and creates a named tab with the format of the CONTROL tab and hyperlinks it in the original tab: Sub CreateAndNameWorksheets() Dim c As Range...