create

I have tried various approaches I've seen on the internet to no avail. I have a workbook with a worksheet named "Reformatted". In P1 I have the text: SUPER In the rest of column P I have 2-character codes. I'd like to loop through this sheet and create a number of additional workbooks, each...

Hey, together I have the following table in Excel, which I add in PowerPivot to the data model: <tbody> ID Created Started Finished 1 01.01.2019 01.01.2019 05.01.2019 2 02.01.2019 03.01.2019 08.01.2019 3 03.01.2019 03.01.2019 04.01.2019 4 03.01.2019 04.01.2019 08.01.2019 5...

https://1drv.ms/x/s!AvjBsEPEq12ngTpjIV0Ri5AcMKZa?e=0sU8cn I have a table of data. First column = company names. Other columns = invoice amount aging by days E.g. column B = 1 - 010 means invoices overdue between 1 day and 10 days. I am summarizing the info in a PV. Suppose I want to create...

Hi, help please with creating worksheets in a workbook Im using Excel 2016 I have a VB to create new worksheets based on a list of names on a summary sheet but I would like the new worksheets to be to set layout including column widths, formats and formula. Is the easiest way to do this to...

I am unexperienced when it comes to navigating websites using VBA (or any code). I have been able create code to open the desired websites but now I am trying to automate "clicking a link" to save additional time. I have an excel file full of various patent numbers. I have been able to...

Hello all- I have a VBA question. I have a large data set and want to create a new tab based on each change in salesperson. My data range is A3 to BN3000, with the headers in row 2. Salesperson is in column G, starting at G3. What I want to do is create a new tab at each change in...

I want to create a chart that has columns for days of interest (like a time line) I don't care what the Y value is, just so that the column goes to the top of the chart on a specific date. So the X values should be dates from 1/1 through 12/31. The Y value is just a marker that moves from left...

Hey folks, Suppose I create two queries for the two tables in my spreadsheet https://1drv.ms/x/s!AvjBsEPEq12ngTmYWfZW_bAjU4w7?e=9d2PBI Is it possible to somehow merge them as per my example?

Hi Folks, I have been given a workbook with 200 worksheets: each ws contains some data that wish to manipulate. Is it possible with VBA to loop though the worksheets; determine the CurrentRegion; and, create a dynamic table on each data range? Currently I use the below VBA to create a dynamic...

HI, I have an excel with 2 columns. Column A = Name Column B = 'URL' (www.google.com) Not all Column A's have URL field. some are blank. I want to create new tabs in the same excel and seperate out URL and NO URL data. Please advise.

I am new to creating macros on excel, and would like to know where to start. I need to create a workbook to pull information out of another workbook, and put it in different tables based off of the text. Are there macros available for stuff like this, or can someone point me in the right...

I want create new NFL schedule file. anybody have any ideas. Thanks You Thomas

Good evening, Is there a way using macro to create a month folder with a time stamp? The folder name will be the month name in cell B3 of sheet1 and can the time stamp be HH:MM:SS? Lastly can the macro create 4 additional folders within the newly created folder, if that is possible. The four...

Hi, I am trying to create a comment from the cell contents in an adjacent column (offset -1) for a range. The purpose is to create a popup comment that represents a part description when you hover over the part. <tbody> Part Number Part Description part 1 part 1 desc part 2 part 2 desc...

Hi folks, I didn't want to hijack another thread so I'll start a new one here. When looking at this thread (https://www.mrexcel.com/forum/excel-questions/1102928-modifying-code-send-e-mail-3.html) I like the way the code creates a formatted email grabbing a range from a worksheet. In my case...

Hi If i have two tables and if i create a realtionship between them (they could be two lookup tables, two data tables or one datatable and one lookuptable) would it be the same as using vlookup if i was using exel and i theory create one big table?. If this is true does candinality and filter...

Hello, I am to create a rank comparison formula. Can somone create a formula that tells me how many ranks a certain store has moved up or moved down? Example: Store has a decreased rank of 2 (from 1 -> 3). See below. <tbody> STORE NAME RANK 2018 STORE NAME RANK 2019 Store A 1 Store D 1...

Hello, When I try and remove a calculated item that somehow (user error) got added to my sheet, the following error pops up: "The pivot table field name is not valid. To create a pivottable report, you must use data that is organized as a list with labeled columns." Help? Thanks! -Ben

Respected users, Can we create a macro which would help us to create separate workbooks; for example, we have workbook named A, can we create workbook B and workbook C using a macro function in workbook A? If not, is it possible using excel related time saving tools? Thank you.

Suppose I have a workbook which has one sheet with a table (say Table1) of 20,000 rows of data. If I create a new workbook and use Power Query to create queries by sourcing Table1, does that make my second workbook for memory efficient to use? That is, dumping data into one workbook. Then...