workbooks

Hi I have a folder with 7 workbooks in it. All workbooks have 3 tabs in them and they are all named the same in each workbook. What im trying to do is merge all the workbooks together into one with all data from each tab. I.E all data in tab one in the 7 workbooks to be merged into tab one...

Working inExcel 2016 - I typically have anywhere between 5-9 workbooks open at one time,working in them all simultaneously. I amtrying to figure out how to not have them linked in a way where if I save one workbook that it doesn’t freeze up the other workbooks(showing the action of saving the...

Hello all, How do I go about with collecting data from a number of workbooks into a new workbook ShowInvoiceData.xlxm. I've got in every Invoice workbook two cells Date and Invoice Number which I would like to show in a list in ShowIvoiceData workbook. Then I shoud be able to select a Invoice...

I have two (actually more like 20) workbooks that are intended to have a lot of the same formulas in them, with different hand-entered data, resulting in different values for the formulas. Essentially, creating several workbooks from a top level template. On occasion, I have a need to update...

I have a medical vision issue because of which I am able to only use a dark background. Sometimes I get Microsoft Excel workbooks which are designed to be viewed on a light background. In those cases, I have to change the colours usually using the table style feature available in Microsoft...

I am new at vba. I need to locate the row number of certain employees in every workbooks Employee names are sorted differently and are in another column for some workbooks. Workbook names are located in column AC populated using dir(). From the code below, you will notice that $AC14 is static...

Hi I'm trying to copy data between workbooks, but i'm getting an 1004 run time error, on the range object that i'm using viz. Workbooks("Origin.xlsx").Worksheets("Data").Range(Cells(1, 1), Cells(lastrow, lastcol)).Copy Workbooks("Destination.xlsx").Worksheets("Copy").Range("A1") Please...

Greetings, I am creating a workbook to consolidate data from two other workbooks created by exporting reports from an accounting system. Here are examples from the two exported workbooks: WORKBOOK A <tbody> ItemCode InvValue A 0.00 A 619.42 E 3.00 G 289.56 C 4,459.33 C 44.59 I...

Hi All, my excel workbooks are set up in such a way that they are not linked to each other, i.e.if I open up two workbooks and try do vlookup across the two, it does not work. could you please advise how to fix it? thank you

With some great help from the forum community here, I have managed to use a macro that runs through a dropdown list and exports a sheet to a pdf in a user determined location Huge thanks to Yongle See this thrread for details...

Hi I have a folder with many excel workbooks Each workbook has multiples sheets - Each sheet is named from A to Z (Sheet A, Sheet B ....Sheet z) The header, sheet names are all in the same order and name in all workbooks I want to combine all sheets based on the sheet name from different...

Hello... My work computer was recently upgraded and Excel now is hiding workbooks that I have open. I'm not hiding them, but until I found out about how to find hidden files, thought I was losing them. When I Googled "excel hides my workbook and I can't get it to stop", I found all sorts of...

I am trying to automatically transfer data from multiple workbooks into one master workbook. All workbooks are in the same folder. The data is off various column and row size and contained on only one sheet in each workbook. There are a total of 6 worksheets in the master. Example of what...

I’m looking for some help in converting my current code into a range instead of a full sheet Instead of merging sheet 1 from multiple workbooks into a master workbook, I only need to copy a specific range on sheet one of each workbook and paste it within the master workbook. I need each sheet...

I need to extract specific rows from all the spreadsheets in a directory. I can use the Query editor to load all of the workbooks but the there isn't a quick choice to select certain rows. For example, I would like to keep rows 4, 53, 57, 71 and 57 from all of the loaded workbooks. I suspect I...

Hello! I have a workbook with connections to 4 seaparate workbooks. All of a sudden when I open the main workbook, it opens all of the files connected to it. This did not happen before. How could I stop Excel from doing this, while refreshing the connections as it used to? Cheers

Can anyone explain why I find it so much faster to run my workbooks created in Excel 365 in Excel 2003 compatibilty mode? Even with some complicated and very long VBA macros including colour sorting and also using Data Advanced Filtering I have not found anything that I use that will not work...

Hi I have a workbook with several sheets that I need to move into into new seperate workbooks. The sheet names change each week but the sheet code name remains the same (Sheets 4-8). The new workbooks will be saved in the same folder and take the name of the sheet. I have found the following...

Hi everyone, Not to savvy with VBA data gymnastics however I am more familiar with excel formulation. I have a bunch of workbooks in folder 'C:\Users\BCR\Desktop\TSA' i am only interested in one sheet 'Custom Award File' and only interested in columns A-I. The first row is row title and i want...

Hello, I have a workbook which has a named ranged which contains the full path to a number of Excel workbooks. I'm trying to put a macro together that can pull data (either by opening in each of the files in the background, copying and pasting and then closing the file OR using the OLEBD or...