multiple workbooks

  1. T

    Is it possible to link pages in two separate workbooks

    Does anyone know if it is possible to link pages in multiple workbooks. I want to be able to click on a upc code in a cell and have it take me to the same upc code in a separate workbook. Does anyone know how to do this? Basically you would have to search by the upc code. I have done this in...
  2. M

    Pull data from multiple workbooks to populate new workbook

    Hi, I want to create a spreadsheet that will pull data from a form that my clients use. There will be many of these forms and each one will have a slightly different file name but be stored in the same folder (C:\Users\MWa\Desktop\VBA Test\filename) I want to copy the exact same cells from...
  3. A

    Find match through multiple workbooks and tabs and copy a cell's value to a another one

    Hello everyone, I was searching through the forum for a solution on using Index/Match but I didn't manage to find one solving my problem. I have two excel documents. The one of them contains information about participants of a quiz. Each week I have to retrieve the participants of the quiz and...
  4. R

    Creating summary file from multiple workbooks created on specific day

    Greetings all, I have an analytical piece of equipment that exports data for each sample analyzed into a separate .txt file. I would like to compile all of the data from analyses performed on one day into one summary workbook. All of the exports are in the same format but the location of the...
  5. E

    Consolidate One master excel file from multiple excel spreadsheets in different tabs

    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...
  6. A

    Hide columns in multiple workbooks without opening excel files

    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...
  7. U

    VBA Code to transfer data from multiple workbooks into Master workbook

    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.
  8. E

    Pulling data-points from different workbooks

    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...
  9. L

    Copy and pasting specific cells from one workbook to another through a button [VBA]

    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...
  10. E

    Macro - Insert Links in Multiple Cells to Multiple Workbooks

    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...
  11. S

    VBA Code to copy data from one workbook to another

    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...
  12. T

    Can't loop through multiple sheets

    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...
  13. V

    Rename Sheet Name in multiple Workbooks

    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"
  14. F

    Prompt for Folder Select when Merging Multiple Workbooks

    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...
  15. S

    VBA Merging Data from Multiple Workbooks in columns instead of rows

    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...
  16. K

    Compare cells in 2 columns in separate WBs and return data in Col 38-40 if there is match

    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...
  17. S

    Multiple Referencing Between Workbooks

    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...
  18. G

    VBA to retrieve last non-blank data in a column for multiple workbooks

    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...
  19. K

    Suggestions to paste new data on last row....

    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...
  20. D

    Finding data in closed workbooks with VBA

    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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top