big data

Hi, I'm pretty new to VBA and trying to figure out how to transpose 2000 rows of uneven batches of data. Here's an example: Column A & B need to become Columns D-H I would really appreciate some help! Thank you.

Hi, I have a large data ranging between 200k-400k row every weekday to analyze. I need to get result for Column P, Q, R, S, T, U , V, W, X, Y from Row 2 to Row 7201 (sometimes until Row 1441 , 481 ,241 ,121 depend on what kind of analyze is). Current formula I use is "...

Good day guys! I writing you because of my problem. I don't know how to write the macro witch will help me. Please help me with my problem. So situation is that I have several hundreds of data documents in .csv files with all text and numbers are inserted in A column and for outside of excel...

Hi guys, do you have some formula to VBA fore filter ? I don't want to press every time Filter Icon. If you knows that I will apriciate your help. Thank you.

Hi guys, I need some explaining in IF formula. How can I write condition with IF to automate check my Data Base from my table automatically? something like this: =IF( E3=F3 then past value from G3 in C3 cell) + =If( I already have value in C3 cell but it is not the same as in G3 then change it...

Hallow everyone ! Guys how I can integrate Schedule Standard (STD) in my excel to automatically check 3 cells in my DB ? This is original pdf file of Schedule Standard This is my DB and I marked by color only that places which match with my DB, I want control those cells automatically...

Hi Guys ?, I have a question to you about which formula can help me to show and collect all backlog in my Register. I will add two Mini Sheets to describe everything in a simple way. Note about trigger: The trigger should be activated only in one condition when I have request Date only and No...

Hello Everybody, I am myself an excel VBA programmer as well as programmer in other languages i.e. Java, JavaScript, Python and C++. Currently I got a project where I have a huge dataset (more than 20,000 records spread over 25 columns) and not only that I have to search each record, I have to...

hi Guys, I have a huge worksheet with a lot of code in it, but everytime i run it, it gives me an error saying the procedure is too large. Is there a work around it? the code is 4000 lines, but most of it is the same thing with the only difference being either the table name, column name, or...

Hi! I'm having a problem arranging a pivot table report in a simple layout. Can anyone help? So, I have a (quite big) set of data in this format: <colgroup><col><col><col><col span="48"></colgroup><tbody> Client Department Employee 1MAT 1H 1OT 1TOT 2MAT 2H 2OT 2TOT 3MAT 3H 3OT 3TOT 4MAT 4H 4OT...

Hello I'm using this board quite a few times but I never posted a question. I'm working on a special project in my company and for this project we use excel and vba code. We got a strange behavior. With VBA we import data from other workbooks into the main workbook. This tooks about 30s for...

Hello, I want to use scenario manager for my calculations but i have too many scenarios(around 1000) with 4 variables. It takes time to write scenarios manually. Besides i may change the scenarios over time. Is there a way to upload scenarios from excel spreadsheet? Or is there another way to...

Hi all, To give you an overview of what i'm trying to achieve. We have 280k of registered users (last 2 years regs) and we have a subset of 116k users that have opted into our marketing etc (this covers a longer time period). We have a massive service change and have a desire to tailor our...

So I'm new to VBA and am having problems with this one marco. I have written it in two different ways to get it to work and I cant. Both the codes work but just take about 10 mins and sometimes it crashes. I am trying to identify the last time an item was moved in our inventory by using the...

I have an Excel file (I don't consider it to be too big (88,000 KB) that also references one other data dump file so sometimes caches an extra 42,000 KB. When end-users are using the file and actually in the file, everything runs very quickly; however, I am starting to get complaints on how...

I need to import data from the census.gov website, specifically historical data. Building Permits Survey > Permits by Metropolitan Area This is the query interface for the website. It creates data sets that look like this. http://www.census.gov/construction/bps/txt/tb3v201401.txt I noticed that...

Hi, I am trying to identify rows in a table (Range A7:AD7445) that contain information that is not unique. Specifically, I want to test each row to see if the contents of its 1st Cell (Column A) are equal to the contents of any other row's 1st Cell. If someone knows a way to do this, please let...

Hi, I have a large data set (Range A7:AD7445) to which I want to apply conditional formatting. For each row, if the contents of Column A, Column U, and Column AD are the same; then the contents of Column W should also be the same. If the contents of the three columns are the same but the data...