dataset

Hi there, New to VBA - have tried a few different bits of code but can't find one that achieves what I need. Trying to transfer a 2-axis dataset into stacked columns, removing zero balances. I want to populate adjacent columns with the headers along each axis. Below / linked image is an...

Hi all I've run into an issue when naming ranges within a vba routine, where the time it takes gets exponentially larger as the number of rows in the data to be named is increased. My dataset is 213 columns wide, i have a standard template which data (varying number of rows) is copied into...

I have a large set of data, with a lot of duplicate information that is associated with unique information. I need a way that a user can easily sort the data to find what they're looking for and it seems like Pivot Table is the way to go. The biggest problem I have is the values as it does SUM...

Hi there, I am very new to excel VBA and was struggling to do the following through codes: 1) Autosort by date. 2) Copy dataset by date and paste it in a new workbook. 3) Remove date column from new data. 4) Save the new workbook with date as naming convention for saving. I am giving the the...

Hi all, I've got a dataset which has been put into a pivot with various slicers linked. I'm looking to create an output table to show certain columns from this dataset, but only those which remain after the slicers have filtered out data. I this possible? Cheers!

Hi excelers, I am here to post a problem which is beyond my excel skill level. I need to plot a dataset within a 5x5 cell window made up of "1" (see attached screen). Criteria: The formula should be easily copy/paste down to calculate previous below rows of data, and be the simplest & fastest...

Hi I am trying to understand the code below which highlight blank cells. 2 parts I did not understand 1) what does this line do " Set Dataset = Selection "? 2) what SpecialCells() function does here --> Dataset.SpecialCells(xlCellTypeBlanks).Interior.Color = vbRed Thank you so much...

I have two sets of data which contain some (43) columns in common. I would like to refresh the shared columns in dataset 1 with dataset 2 (as dataset 2 will be updated daily) I'd like to be able to do this by clicking a 'refresh' button in dataset 1 which then has it's data refreshed by using...

Hello, I am kind new on VBA so please be kind :D I am trying to make a code that will loop through worksheets that have same name but different number exp Dataset 2(1), Dataset 2(2), Dataset 2(3). Then i want to have another loop inside that loop that will look for the last row from column A...

Alright, so this isn't (or shouldn't be) difficult, but it's just one of those things... I've already referenced several posts/sites along the same lines of this topic, but for whatever reason just can't seem to get this down. As the title suggests, I am (in VBA) referencing a dataset from a...

Hi, I'm new to making and using macros, I was wondering if anyone can help me program the following if its not too much work. I've tried making something similar with recording, but it doesnt come out right. Any help would be appreciated! Background: Dataset in 1 Sheet with ~200K lines...

Hi all, I have 2 worksheets: Extraction and Dataset. On the extraction sheet (where I want the data to be presented), if cell A1= "7500-2018", I want to extract from the dataset worksheet anything with 7500-2018 in column A. Within Dataset, I would want columns A to L copied across, if...

I have a performance question on how Power Query works. I'm hoping someone has an answer rather than me having to test on my 12-million row dataset and slow laptop. If I have (say) three Table.AddColumn commands, does PQ iterate through the entire dataset 3 times, or is it "smart enough" to...

I'm using an OLE DB Query to connect to a MS SQL Server Database to return a dataset to the workbook. I'd like to dynamically update the query and dataset by updating the SQL query with new code. I'm having a hard time finding the correct code to do this. I've done this before in prior versions...

I have a "x" in A2 and "x" in A3, again in A17/A18, again in A200/A201, etc. How do I count the number of instances throughout the column of cells with adjacent (down) values? And how would I do this for the entire dataset, which expands across from column A to column BT? Can this be done...

Hi all, I have downloaded a dataset and it is not consistent (in terms of how it displays the data) compared with other datasets I have. Does anyone know the most efficient way I could transform the data to look like the dataset on the right hand side? For example, I would want the years in a...

Hello, I need to remove the first two, and the last five characters of a string, but the length of the string varies. Can someone help me get started? The dataset has about 130,000 rows Thanks!

I need to find the maximum value present in column AC against multiple instances of variable X in column D, and populate the value in column F. For example (apologies, I cannot share a true dataset due to the confidential nature of the data): <tbody> Column D ... Column F ... Column AC 1...

I need a way to move data from dataset 1 to dataset 2 using a formula in dataset 2 that references dataset 1 via label (quantity, price, shipping cost per unit) and item code. Does anyone have any suggestions? https://imgur.com/a/CpVRn

Hello Everyone, I have a challenging one, I will try to be precise, but let me know if you need to know anything else. Basically, I have 2 sets of data (as below). I want to have those dates highlighted in DATASET 2 where the date has changed. This is not so easy, because a given item can...