multiple worksheets

I have worked several days to get my macro to work but itwill not fill down the data to the FinalRow of a referenced worksheet. Background: a person opens a workbook (wbPPM) and goes to a variable worksheet(shtReq) where the person kicks off a macro. The macro open another workbook(wbQC) with...

Hi, I've read so many threads and can't seem to find examples with similar structure to mine. Need help, please. I'm trying to sum data across multiple worksheets into a summary where it must match text from the row & the year from the columns and sum the amounts across all worksheets. Showing...

Hi, I am new to VBA and I want to create a dynamic line chart with a drop down for student name(name of the worksheets), to display one student at a time. The chart will plot total score over time by booklet number (1 – 18, 19 – 30). The chart range is A7 to Z column. The dates(x-axis) are in A...

Hello experts, I have a workbook with the same kind of data in about 30 different worksheet tabs. I want to make all of the rows with data in each worksheet be reformatted with a row height of 30, unless the content is larger than 30 then it needs the entire row to be autofitted. I have code...

Hey everyone! I am having some trouble writing a macro that will search sheet full of data, find cells that match a given criteria, copy other cells in the same row as the cell that matches the criteria, and then paste those cells in the same row on a different sheet. I need all the matching...

This one is starting to hurt my brain. I have a workbook with multiple sheets and the point of the book as a template for a questioner/form. Each tab has various items to fill out or answer. Some basic info, some with dropdowns, and some referenced via formulas. Each client will have their own...

Hey all! Seriously struggling here. See if you can help this poor soul out! What I am looking for: There are 7 worksheets in this book, 5 of which have same column headings (second to sixth worksheets). I want to pull selected rows from these 5 worksheets into the 7th worksheet (CAP) while...

Hey all! Seriously struggling here. See if you can help this poor soul out! What I am looking for: As you can see below, there are 7 worksheets in this book, 5 of which have same column headings (second to sixth worksheets). I want to pull selected rows from these 5 worksheets into the 7th...

Hi everyone, This is my first post on here so I hope I follow the procedure appropriately. Please feel free to offer any feedback if necessary. Despite hours of searches and reference material I have looked though, I cannot figure out why the following formula ends up in a #REF!. It seems to...

Hello, I am using the following code to copy/paste a range from one worksheet to multiple sheets. But, my code is only pasting the range onto the sheet that is currently open. Any thoughts on how to get it to copy paste to all sheets that begin with "Labor BOE"? Here is the line in my code...

Hi all, I am looking for a solution to a problem that has plagued me for a while. I want to insert a new page break/ new blank page to ensure that all of the pages that will print are even (e.g. 2,4,6,8) for any given worksheet in a workbook. e.g. If: <tbody> Sheet 1 Sheet 2 Sheet 3...

Hello everyone, I just joined the forum, and this is my first post. I am totally naïve to running macros and need your help to automate the consolidation of multiple worksheets. I have around ten worksheets - columns A to M are fixed in all the spreadsheet and rows keep changing as and when...

I am looking for an amazing solution to a problem that I am having printing. I want to insert a page-break at the end of each worksheet (I have 50-200 worksheets in one workbook). Each worksheet is different in length. The end of each worksheet can be identified by the first blank cell/row...

Let's say I run a parcel collection service. I've got three vans on the road. I've got seven locations that I need to collect from. Each van has got a scanner that collects data, such as date, unique location number, and parcel barcode number collected. Unfortunately, due to new members of...

I tried to search for a macro I could use but I'm not good at revising what's already available. I would like to: - Copy the same range ("A43:I53") from 31 worksheets (named: 01, 02, 03 ... 31) onto a worksheet named "Misc" starting from cell A9. Headers in row 1-8. - After this is done, sort...

Hello, I am not very good with coding but have managed to use what I find and tweak it to fit my needs quite often. However, in this case I can't seem to get what I need and can't find anything that will work for me. I would appreciate any assistance I can get. I have a work book with...

I'm trying to create a function that can be applied to multiple worksheets based on the worksheet name. I know what function I want to apply, but I can't seem to figure out how to organize the process Layout: You have 3 shapes in each worksheet (M1,M2,M3). M1 links to Sheet A1B1, M2 links to...

Off to a good start but need some help finishing this... Here's the situation: I am working between two workbooks; WB1 is used for the collection of data and although the workbook will have different data, the cells the data is entered in will remain constant, on WB2 I have 2 WSs (FPPI-Routed...

I have a workbook that has 6 worksheets. I have VBA code to print different names as a footer on each page of the first worksheet. I have the code disabled, however when I attempt to print a different worksheet on the same workbook, although on the preview pane it shows the correct worksheet...

Hello, I found a VBA code that prints multiple worksheets to one page. It works well but it also prints hidden pages which I cant use and it prints the whole worksheet. I need it to print just the areas that contain data. Can anyone help with this. Thank you in advance Sub PrintOnePage()...