I have been recording different sets of commands then copying/pasteing them together to complete what I want. I have tried to clean it up as best I can but im sure it does things it does not need to. Is there a way to tell it to select all sheets in "Book2.xls" then remove the formatting (font color,comments,shading) rather than using the Array and naming each and every sheet?
What this will end up doing is openeing about 12 files, copying specific tabs from each of those files and pasteing them all to the same workbook (in this example it would be Book2). Then removing the formatting.
I have 2 workbooks. The workbooks have 36 tabs for each department. Workbook 1 are current charges for the departments and workbook 2 is the revenue for each department. I would like to take the top 2 rows from workbook 2 and add them to workbook 1 at the bottom of each tab. I was able to get it to work to a specific row but the workbook 1 has variable rows for each tab.
I use a workbook where new worksheet tabs are added and removed daily. Every day I use the second-to-last tab (2nd from the right) and the last tab (far right). What code would enable me to activate and reference both of these tabs individually? I believe it would be something like the code below but I can't figure it out...
I need the code to allow a user to select a column of their choice in an open workbook of their choice so that data can be lookuped up and changed. I am happy to create the code to do the lookup/changing, however the nearest I have found is the use of an inputbox which is limited to the active spreadsheet only. Some people have said the input box could be used over to another spreadsheet but I have not found that to work.
What I will need returned is the workbook name, sheet name and column. That will allow me to point to that and do the task.
This code could be used by 5 people and those 5 people could be running it on 20 different spreadsheets.
I thought this would be easy to find but it has eluded me. When using Excel normally, if you do a simple lookup formula, or create pivot function, excel prompts the user to select the workbook/sheet.
I have a Services Quote work book that contains many tabs only some of which may be used for a particular quote.
I would like to have a macro that I could assign to a button that would check the value of a particular field on each tab and if that field is greater than 0, then it should select that tab as one to be printed. Once all tabs are checked and either selected or not selected, the macro should print the selected tabs.
I am trying to do is write a macro that will pull two tabs labeled "XXXXMarch" "XXXXPTD" (the x's represent numbers) from each file within a designated folder and copy them into a master file.
I need to select all yellow tabs (color code 6) in a workbook with over 70 tabs and hide all empty rows within A1:I36 on each of these yellow tabs. the position of the tabs needs to be unchanged (sorting by tab color not allowed). I got this code from another excel forum but somehow it only works when i select one yellow tab and run it and the code only works on the one yellow tab i selected. can fix this code so that it can loop through all tabs (yellow and non color) and do what i mentioned above for each yellow tab?
Sub HideMT() Dim Ws As Worksheet Dim wsColor As Long
I have 3 workbooks with multiple spreadsheets (tabs) in each workbook. I want to open a blank workbook and copy various sheet tabs from the other workbooks into my new workbook. I need to keep the formatting etc when these are copied over. There are text boxes in some of the existing workbooks and macro's.
I use excel 2002 but some of my office are on 97, i want to add a small workbook open event code which works for me but debugs for the others?? The code is basically, go to a tab, on that tab and that range sort..
I have a workbook with several tabs. The top tab is the main spreadsheet were I enter all my gathered data. The other tabs are the same spreadsheet, the same data, but broken out by specific building.
Right now, I enter the data (alpha and numeric) into the main spreadsheet, then manually copy/paste it to the respective sub-level spreadsheet.
I can specify the "IF" part of the line item that would identify which sheet to copy it to, but is it possible to have a "THEN copy and paste [these cells]" to the other spreadsheets?
I have the code below and it runs a report for me but it puts the new tab to the left of my existing tabs. How can I alter the code to put the new tabs on the right?
If Me.cmbCat.ListIndex > -1 Then 'Add a new worksheet Set WSReport = Worksheets.Add(before:=Worksheets(1)) With WSReport 'Check sheetname and keep adding 1 until not found. If SheetExists("Report " & Me.cmbCat) Then Cnt = 1 Do
I am pulling my hair out in frustration with this right now. I have a .csv file that I am attempting to run a macro on. I will need to move between tabs, and want to rename a tab to remove the date as it is not consistent in format. I have tried numerous ways, and I don't get an error message, but the tab is not renamed either. Code I have tried is below ....
I have a workbook that pulls in data from other sources and contains 15 linked sheets. The data changes when different criteria is selected in the first sheet. The first 2 sheets are summary sheets and the tabs are named correctly.
I would like to be able to rename the remaining 13 tabs using labels found in the cells in the first sheet. These tabs should update or change when the first sheet is manually recalculated (F9).
I have used ActiveSheet.Name=Range("A1") but it doesn't apply in this case. Is there a macro that could run with something like Sheet1.Name=Range("A1"), Sheet2.Name=Range("A2"), Sheet3.Name=Range("A3"), etc.... or maybe something in each sheet that would change the name of the tab to a specific name off sheet 1 when the whole workbook is recalculated?
I have to prepare files of over 100 tabs in each. I have a list of numbers on a spreadsheet that must be entered on each tab. Am I making myself clear because I tried to do it manually and it's no joke?
I have a program that takes a templete, copies it, fills in some information and then renames the tab based on text in a cell on that sheet. The code loops so I end up with about ten tabs that are created from the Template.
I want to move these newly created tabs to a new Workbook.
is there a way (code) that will move all the tabs except ones delineated in the code - like the tab named "Template"?
Is there any way to arrange the tab easily instead of move back and forth and drag? I have a work book with 50 tabs and if I like to arrange it, I have to move the cursor pointer zillions time and than find and drag the right tab at the right place. Is there any easir way? Like you do in power point?
I don't know VBA code but i am familiar enough to know that a code can be written to separate out information into different tabs on a worksheet.
For example, I have a standard worksheet with say 20 columns going across and 20,000 rows going down. At each "name" change in row 1, I would like a macro to copy into a new tab. Basically the end result will have a tab for each name and the corresponding columns that go with the name.
I have a workbook with a list of names of up to 15 people in each of 5 rows. Each row then populates a row in a separate workbook with those names. Each person is identified by a number and each person then has their own worksheet in that workbook.
Is it possible in some way to auto-name the tab for each worksheet from the number in the name cell?
I need to extract two coulms (AQ,AR) from a workbook with 31 tabs, I want colated the same colums from each one and copy into a new workbook. I have been searching for hours but have failed.
I have created a Hlookup to read a workbook that has several tabs. How do I write the formula to read every tab. So if my tabs are labelled like this... FY 2012, FY 2012-2, FY 2012-3 - each spreadsheet is formatted the same, same number of rows and columns but I need the formula to look on every sheet and then bring back the information.
I have a workbook with 5 or more tabs. One of the tabs is a CONSOLIDATION of all the tabs put together. I have columns on the consolidation tab with the names of the individual tabs. To the left of these columns is a list of general ledger numbers with their respective names. For example:
East West NE South 6103256 –sales 6540000 -salary 510000-travel
I want a excel to look at the individual tabs, for this specific gl number and name and, if applicable, return a value. What formula would do this?
My columns are not showing up correctly. East,West etc are the columns. 6103256 - are the rows
