I'm trying to figure out how to create a macro/button to print 2 worksheets, out of the several worksheets that exist in my workbook, but printing them under some conditions;
1. If cell S19=TRUE, and If cell P13=TRUE, then print 3 pages of each both worksheets.
2. If cell...
As usual I have no idea where to start on this one.
I have a workbook with a number of sheets in that I want to perform a sort on all of them.
I would like to sort the data in A29:K100 (No headers) by column B (ascending) across all worksheets in the workbook. I don't know how many...
I'm new the forum and have very limited VBA experience. Would really appreciate ANY help with my issue.
Right now, I have 3 different sheets of data, with different number and order of columns. I need to create 1 master list that combines the data from 3 of these sheets, thought not...
I have a code here(please find below) and was wondering if you could help out.
I am using this code to delete all the blank rows in a worksheet , and this code works fine.
The problem I am Having is that, when I run the code it only does it for the current worksheet I am on. I...
I need some help in making this code short and simple. Is there a way to do that? Thanks in advance.
Here's my code:
.Range("A2", .Cells(.Rows.Count, .Columns.Count)).ClearContents
I have several hundred files, each representing a different date and each containing roughly 500 rows and the same columns. I would like to sort each of these files in the same manner (while adding a few extra columns with calculations) with the ability to then compare and analyze the sorted and...
I am trying to create an auto-filter on the first page of my workbook, the worksheet is named Index. I have created a dropdown box on this page with criteria that I want to filter against, on 8 different sheets in the workbook. I can't figure out how to reference the drop down cell on the...
I have one workbook with several worksheets, however when i run it, it only run on one worksheet. Can anyone help me to make this code also run for other worksheets in the same workbook?
Here is the code:
Private Sub Workbook_Open()
Dim LRow As Long
Dim LName As String
My name's Oliver and I'm currently writing my university thesis and need help with sorting out a lot of data.
Have several worksheets, where every worksheet contains between 1000-7500 columns with headers and data below. I want to delete the columns that contain certain texts (like...
I am trying to consolidate rows from tables on multiple worksheets into one table in new master worksheet. Tables have the same amount of columns from A to J but not same amount of rows. Condition for rows I want to consolidate to new table is the blank cell in column F. In...
I know that this question has been asked a thousand time before, but I can't find the perfect one for me. I'm looking for a VBA that takes all my rows and separate them into multiple sheets in the same document. Here's exactly what i'm looking for:
- something that keeps my...
We're using MS Office 2013 and Windows 8. Every time we open a new excel file, it opens to a new workbook. It would be nice if we have the option to open a file on the same workbook (to easily put them side-by-side) or open it on a different workbook.
We prefer to have the files look like this...
I'm struggling with the formulas across multiple sheets.
I'm presently trying to run about 10 worksheets on 1 excel save.
I need to be able to keep running totals across these sheets.
So for example, I need the total of Sheet 1 C47 + Sheet 2 C47
I then need the total of Sheet 1 C47...
Hey folks, this is a bit of an oddball question here. With much help from trolling this forum and others I've learned a lot, but often I just modify what I can find and make it do what I want :)
I'm wondering though, if anyone has any opinion or advice on my formulas I'm going to post, because...
I have a macro that splits my data by column x and pastes it into new worksheets for each unique item in column X. However, while the formatting is preserved I lose all the formulae. Is there a way of preserving the formulae while I do this? Or would I need to create a separate macro to...
I have three worksheets in a workbook all listing the same values, but in different sequences. I would like to highlight a cell/value on Sheet 1 and have that same value, wherever it appears, highlighted on the other cells. Essentially, these are working lists and when I switch back and...
I have about 90 worksheets in a workbook that I want to copy 2 certain cells. The cell is different in each workbook depending on what the data is on each workbook. I know which row the cell I want to copy but not the column. Bascially I want to take the last cell in row 23 that has content in...
I have two excel workbooks. One workbook contains one worksheet with all the data information. Another workbook containing 35 plus worksheets is what I need to populate. Let's say each worksheet pertains to each individual state (ie. California, Texas, etc.) in the US. The information I...
I have something of the following :
Shee 1 (Name Range : Code)
Column A -------- Column B
School ----------- 1
College ----------- 2
Cell A1 = (Search for "College" in Name Range Code and get the Value of "2" as code. ) So value of 2 should be present in...
I have multiple workbooks containing a different number of worksheets with budgets in the exact same format. I would like to add a sheet (in the same format as all the sheets) in each book that sums up the other sheets in that book. In the sum-up sheet, however, I would like two cells to hold...