multiple workbooks

I am fairly new with excel to some point, i know enough to be dangerous. Anyways, here is my problem. I have a master file spreadsheet that contains a ton of columns. The column headers i use to sort data is the same across the board on all spreadsheets and tabs. I have a unique ID field in...

Hi all, I have about 100 clients' excel report files,and I need to hide specific columns in multiple excel files if any cell in the columns match "AAA" or "BBB" or "CCC". I am looking to see if there's a way to quickly hide the columns if the above conditions are met, to all 100 excel files...

Hi, This is my first post here. I am an absolute novice when it comes to VBA. I am in need of VBA code that compiles a data from multiple workbooks into single workbook. Any help is greatly appreciated.

I have 57 data-points (per file) across 120 separate Excel files. Each point is in the same spot in each workbook. I have been searching everywhere for the past 3 hours on how to achieve this. I keep coming across the "INDIRECT" function, but not sure if that is the correct solution (and I don't...

Hi everyone. I am really new to Excel VBA and I am trying to automate some processes at work. Before we push out our products, I use workbook A (Source & the active workbook) to generate charts based on bloomberg data and given parameters which are keyed in. These parameters are keyed into...

I’m trying to create a macro to look through multiple workbooks that are daily logbooks and have the number in a particular cell from each work book be shown next to the date of the external workbook. Each workbook follows the same naming convention of Year_Month_Day Shift Log and the data I...

Ok, so this is my dilema, I am trying to set up a template that can copy data from a sheet in one workbook and paste it in to another. So why am I failing. The code is below. The first part opens the workbook that is designated in cell B3. Next I need to copy the data from that workbook on...

Hey, I am analysing data. Taking 3 columns, and putting them into a new workbook. Saving, then closing. the code works fine, but I can't get it to loop through worksheets. I've tried several of the suggested methods and none of them have worked on my system. I tested them using...

Can you please help me on this. How to rename sheet name in multiple workbooks in a folder to some other name. Ex: Multiple workbooks are in a folder. "Sheet1" is the common name in all the workbooks. This "Sheet1" to be renamed as "TaxCalc"

Hello, Would someone be able to let me know how I can edit this code to change the MyPath = "C:" to a prompt for folder location instead? Thanks FHPM1 Sub MergeAllWorkbooks() Dim MyPath As String, FilesInPath As String Dim MyFiles() As String Dim SourceRcount As Long, FNum As...

Hi, I have found a macro that is fetching information from several workbook and pasting it into one summary sheet. The problem is that it's pasting the fetched information into rows, when I would preferably like to have it into columns (see attached picture). I would appreciate any help I...

Hi I am attempting to compare 2 columns in separate workbooks, and if a match is found, to return the data in columns 38-40 from one workbook into columns 38-40 of the second workbook. I thought the best way to do this was to progressively loop through the values of the column in WB1, and...

Hi, Recently my boss has requested I take on a job which my predecessor used to do which is meter reading. I'm happy to do this as its a very simple task but it is very time consuming, this is because on the site I work on there are multiple tenants who require a separate workbook for their...

Hi folks, I am kinda desperate for some help since I am having a hard time manually encoding 200+ excel templates into a masterfile. A colleague of mine suggested that I should try to run a VBA/Macro for it however I can't really understand the language that much. The situation is I have to...

Hi all, The macro I run extracts data from multiple workbooks and I have set different ranges from where to copy & paste this data into one data sheet. Issue I am having is that when I run the macro it replaces the data from previous extract in my data dump sheet. Is there a way I can keep the...

Hi all, I'm wondering if it is possible to scan through a number(15) of different closed workbooks (containing 1 worksheet each). if the value "Fail" is found anywhere in the workbooks I would like to copy the entire row and paste it into the active worksheet, called "Summary". I have...

Hello All, Thank you for letting me join the community, I'm pretty new to building VBA script and am attempting to import a folder of 130 odd csv files in to an workbook and then with a second macro combine them into a single worksheet. The below code is what I am using to bring them into the...

<colgroup><col></colgroup><tbody> I have use a variation of this code and it will work but now I have to search for data in more than two worksheets and my variation does not work. Error starts in the first "If Not UpdateCopyPrim" Please help me identify the error in my code. Option Explicit...

The workbook that I am starting in is called "Rachael" The workbook that I am trying to copy into is called "Jessica" This workbook has two tabs that I need to paste into “Summary” and “Summary Fall” The range that I need to copy the information into is: X 8:61 - "Summary"...

So for my current work we are getting a new system to keep track of inventory. Everything we have saved in our current inventory is saved into a workbook in Excel. I was wondering if there is a formula that can determine a few things. so the basic formula i would want would be IF A2 through...