consolidate data

Hello Gurus, I'm currently working on a project and using below VBA codes. Sub Consolidate Application.ScreenUpdating = False Dim LastRow As Long, ws As Worksheet, desWS As Worksheet LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row If Not...

Good afternoon, I have an excel sheet that lists user names in one column and their access level in another column. I would like to flip the data such that the access level becomes a heading and user names become a value below it. Original data User A Access level 1 User B Access level 2...

I'm working in movies as an AD. I need to prepare a schedule and provide artist-wise dates to my team. Every time I'm doing it manually by checking the scenes. Can anyone suggest an idea or workaround which could make this work easy? If there is any way please let me know. Present template...

Hello All, Hope you are doing Fine. I have Excel data as shown in the below table. Can anyone help me to get the desired output? SCENE NUMBER CHARACTER NAME E01 SC 01 MICHAEL E01 SC 01 JACK E01 SC 01 ELIZABETH E01 SC 02 JOHN E01 SC 02 MICHAEL E01 SC 03 JACK E01 SC 03...

Hello, I am trying to rebuild and hopefully automate a very manual report that pulls specific sets of data that's housed in several different sheets in one workbook, onto a corresponding community sheet in a separate workbook. The community data I need is currently pulled by one report and...

Greetings, I need help building a macro that gathers information from 1 workbook with a variable name and consolidating it into a tab on a different workbook. For the source file the data I need is in cells (O11, O13, O17:O20, P11, P13, P17:20) on the first sheet titled "Valuation Detail"...

Hey everyone, this is my first post here since I'm new to VBA. I'm not good at coding but I will provide you with all the information I have right now. Summary: My goal --> Macro Step 2: Trying to create a macro to consolidate data from multiple workbooks / Suppliers into one Master-File...

Hi Guys, I have excel reference file named as Monthlies xxxx.xls format. Note that xxxx = date which changes every week. The file has 6 Tabs (Sheet 1-6). I need to convert the file first in binary then consolidated Sheet 1-5 on Sheet 1 as it normally consists of 300K lines when combined but I...

Hi Guys, Just wanted to ask if you could help me out on this. I have excel file with file name Monthlies xxxx on .xls format. Note that xxxx = date which changes every month. The file has 6 Tabs (Sheet 1-6). I need to convert the file first in binary then consolidated Sheet 1-5 on Sheet 1 as...

Hi everyone, I'm new to this forum. I need some help with pivot tables: I'm trying to consolidate payments Ids together, specifically payments which have the same ID but different payments need to be combines and totalled into one. I done a head-start with pivot tables. I comparing and...

Hi is there anyone who can help. I'm working on a project and I need a VBA Code to consolidate multiple rows based on a single column entry, then adding together the other columns. At the moment the data looks like this: <colgroup><col width="170" style="width: 128pt; mso-width-source...

I have VBA code which retrieves historical stock prices data for the last number of periods (days, weeks or months) up to the endDate specified by the user in the workbook. If I try to download data for more than 100 shares at a time, the speed of download progressively decreases. The only...

Hi All, I have 50 workbooks, all are with two sheets and every sheet have header and below that some data in rows wise. I need to compile all the 50 workbooks in one workbook with two different sheets. i.e., all sheet1 data into sheet1 and all sheet2 data into sheet2. Can any one help in this...

I have an excel with a list of paths: This list can change length--sometimes there are 100 .xlsx files, sometimes 4, etc. But always xlsx and always in the same sheet in my workbook (Project Specialist Compile, sheet ghgh). The paths are not fixed, they constantly change so though the list...

Hello all, I am new to the site and looking to learn how to work more efficiently using excel formulas. Need help looking up which client deposited funds to our account. In our BANK DATA we see the account number or a reference from whom the transfer is from and I usually just copy the number...

Hi all I have the following code, which I want to make transferable to other worksheets. Whilst it works perfectly for the worksheet its already in, it'll fail as soon as I try to run the macro in another workbook, because of the filepath. How do I re-write the code to omit the filepath and...

Hi, I need help in consolidating data from different excel files in particular folder. In all the excel files sheet name will be same, i need to bring all the data in these sheets into one excel sheet one after one. For Ex. File names will be on month name & sheet name in the each file will be...

I have a estiamte template that uses drop down boxes and Vlookup commands to fill in materials, unit measures, total units, unit cost, and total cost. All of this data across 80 tabs is collected on one tab called Bill of Materials. It works great as long as the drop downs are used; however, I...

Hi! I have a bit more than 100 tabs in my Excel workbook. All have peoples names in A column. Can I copy with some formula or script names of all those tabs to new Summary tab? Some names may appear on several tabs. I do not care if those names come to Summary-tabs several times. I can later on...

Hi All, I am working on a tool which involves parent-child data. Considering the two cases below, I need to consolidate data which is rolling up-to my client ultimately in a different sheet through a VBA code. In example 1 below my client is A whose parent is B and B’s parent is C. A has 4...