Quick Replace On Many Tabs
I have two spreadsheets, each with about 50-60 separate worksheets in them, and each spreadsheet has simarly named tabs. I am trying to replace the values in column Q on spreadsheet 2, and move them to column O on spreadsheet 1, on each worksheet.
Is there a way to do this quickly, or will I have to copy-paste many times over?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Quick Way To Add Tabs
if there is a quick way to add any number of tabs to a spreadsheet. ie one particular spreadsheet i need to have 32 sheets (tabs) but am getting seriously bored to right click insert worksheet time after time. there must be a quicker way?
View Replies!
View Related
Creating A Quick Label
I am doing a "Lost and found" spreadsheet project for a hotel. Each row contains the lost items with all the necessary info in separate cells (Room nr, found by, reference nr, client name, etc) Every item is being bagged and then a label is put on it. ( has the same information but its just arranged prperly. (Like a label ) What I would like to do is to have a column in each row that has a "print" button. What would happen is that the macro would create a label in sheet2, print it on the default printer and then erase everything on sheet2. (I am kind of new to macros so I dont even know if I need to use the sheet 2 for it). I have already done a kind of a template for the label and set it up on sheet2. I would probably manage to get the print function working with the online tutorials(if not i'll be back) but can't figure out how to do the first bit of it.
View Replies!
View Related
Recursion (Quick Sort)
I've been having a play with sorting integers in A1:I1 (because that was the example in Wikipedia). I've got some code that kind of works, but the recursion is entirely manual. (I know it's only a mickey mouse example, and no practical use!) Sub quicksort() Dim iPivotIndex As Integer, iPivotValue As Integer, iTempValue As Integer, iStoreIndex As Integer, i As Integer Dim iStartNumber As Integer, iEndNumber As Integer 'how do I give it the original iStartNumber and iEndNumber iStartNumber = InputBox("Start") iEndNumber = InputBox("end")........................................
View Replies!
View Related
Quick Auto-Numbering
Auto-Numbering just an example:- 56 57 58 59 60 The Column above is the first column on a selected sheet. i will select 56 and from there (End-Shift+Down arrow) which selects all the values from 56-60... My question is from here on if there is a shortcut key or 'vba macro' that can autonumber from 1. Thus giving output result of.. 1 2 3 4 5 i want to record the solution for above problem in a macro recorder for different numbers that is why i have to do (End-Shift+Down arrow)
View Replies!
View Related
[VBA] Quick Copy / Paste
The goal of this code is to check between two sheets, if it finds a match between both sheets (somewhere in column A) then it should copy E,F,G columns from Sheet2 to Sheet1.. The Sub Test() aLastRow = ActiveSheet.UsedRange.Rows.Count ' last row of active worksheet; assume master is active sheet .....
View Replies!
View Related
Winzip - Quick Way To Zip Up Files From Different Path
I have a folder that contain a list of files in shortcut type. So that i can just click it without going to different drives and paths to open those files and it really save my time. After updating those files, i need to zip it up. There are many files to zip up and it takes time by going to its path one by one. Do you guys know is there any method to zip up those files without going to its relevant drives and paths?
View Replies!
View Related
Catching Errors When Using The Find / Replace Function / Replace All
Need assistance with the code for catching errors when using the find / replace function in excel? In particular, I am trying to write code to break to an error message when the value or string searched for isn't found in the find / replace. At the minute I have just copied the standard code using a macro and all this does is return a message box saying X entries replaced.
View Replies!
View Related
Quick "msgbox" Question (Visual Basic) / Allow User To Respond With Text ? []
I have searched the 'net and read MSDN msgbox but I cant find what I am looking for. Maybe msgbox is not the correct function to be focusing on?? I want a message box to ask a question, and the answer is dumped into a variable, much like you can do with yes/no/cancel, but (much like a pop-up textbox) I want to be able to respond with text in a textbox. [This of course is part of my Excel spreadsheet] (I think with C++ it was something like "msgbox = ?$-" or something like that, but I don't know what to look for with VB.)
View Replies!
View Related
Find, Replace With And Then Replace Adjacent Cell
I am trying to create a macro where it finds a a certain word in a column for example C. What i want it to do is find anything that says FWD_EUR and then replace that cell (e.g C2) with CASH_EUR_FWD and after it has done that it replaces the adjacent cell (e.g. D2) with EUR_FWD. I then want this to do the same with FWD_USD to CASH_USD_FWD and adjacent cell to USD_FWD.
View Replies!
View Related
Old Tabs Not Behaving Like New Tabs
I'm using Excel '03SP2 on Win 2000sp4. I believe I have a case where old tabs originally written in Excel ' 97 behave differently than new tabs in the same workbook, which is saved in 2003 format. Specifically, the formula ="PLAN" & budyr-1 where budyr is a named range on a different tab containing 2008 . This formula yields PLAN 2007 on a new tab and #VALUE! on an old tab. How do I get Excel to update the old tabs so that they behave as Excel 2003 tabs?
View Replies!
View Related
Search And Replace Replace The Whole Cell
I have over 16000 cells with different information in them, each cell is unique. There are parts of these cells that have similar information. I am looking to search part of the cell, and replace the whole cell with my new description, so I can run pivot tables on it.
View Replies!
View Related
Replace, Copy Then Replace Again
I used the following code to replace " characters to !%. Then I copy the selected cells, and replace the !% back to "-es. The copied cells contain the "-es. When I comment the second replace, the function is working correctly, the copied cells contain the !%. What's the problem of my code? Selection.Replace _ What:="""", Replacement:="!%" Selection.Copy 'Selection.Replace _ ' What:="!%", Replacement:=""""
View Replies!
View Related
Tabs Within Tabs
Is there anyway to have tabs within tabs? Right now there are only two layers...workbooks and worksheets within workbooks (tabs). Is there anyway to have more than two layers? So right now: 1) Workbook a. Worksheet b. Worksheet Can we get to: 1) Workbook a. Worksheet i. ? b. Worksheet i. ? ii. ? No?
View Replies!
View Related
Moving To Certain Tabs
I have created a simple button that I want to take me to a certain number of tabs. I have about 24 tabs. I can't see them all. I create a button that will take me to a specific tab from my main page. This works fine till I rename the tab. I want the code to read a sheet number or something like that instead of the specific name. Sheets("JobList").Select Range("A8").Select This works till i change the name "JobList"
View Replies!
View Related
New Tabs From List
I have in column M ( starting at M2 and going through to M273 ) a list of names I wish to have new Tabs automatically made for. There are some cells in this column that are blank and therefore have no name. I need each new Tab to be a copy of a template sheet called 'DataTemplate'. I am currently using the following formula, and I have it pasted in the sheet code of the worksheet where the list is found .... Sub test() Dim r As Range On Error Resume Next For Each r In Range("m2", Range("m" & Rows.Count).End(xlUp)) If r.Value "" Then Application.DisplayAlerts = False Sheets(r.Value).Delete Application.DisplayAlerts = True Sheets.Add.Name = r.Value End If Next r End Sub However, the new Tabs are not being generated. I've tried saving the file, exiting and coming back in, but still no new Tabs. What am I doing incorrectly ?
View Replies!
View Related
Printing Tabs
i have included an example spreadsheet, hopefully someone can help me i want a print button that when pressed with always print 'tab 1' and will print 'tab 2 3 4 etc... if a certain cell in 'tab 1' is greater than zero please see my example spreadsheet and hopefully my problem will become clear if ive not explained myself very well.
View Replies!
View Related
Tabs Disappeared
I am unable to view my tabs in excel - the tabs are there, they just can't be clicked on per say. I have double-check the tools option and verified the correct box is check to view tabs, however, I can't view the tabs. I tried to color a tab and it colored it red, but I can't really view the tab. I can see a red line underneath the directional arrows when I am working on that particular worksheet, but again, I can't view/click on the tab.
View Replies!
View Related
Searching Tabs
I have a workbook with 100+ tabs(not in alphabetical order), and am constantly scrolling back and forth looking for tabs, is there a quicker way to search tabs? I have also right clicked the arrows to pull up the box with all tabs, but not the best option either.
View Replies!
View Related
Converting Many Tabs To One!
I have a PDF document that is one single table but it is long so it takes up 30 pages. When i convert from PDF to Excel (Using a converter) it gives me one tab per page I.E. 30 tabs. I need to do calculation on the data, and need them on one page. Is there a way to merge tabs, or a macro that will do it for me?
View Replies!
View Related
Naming Tabs ...
To automatically make the name of a sheet tab the same as in cell A8 of the same sheet, I'm currently using the following code ... Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next ActiveSheet.Name = Range("A8") End Sub however, I find that if I change the name that is in cell A8, the tab name doesn't change accordingly. I need a code that will name the tab whatever is in cell A8 but also be fluid enough to change the tab name if the contents of cell A8 changes. I do not want this code to operate all sheets, but only a few.
View Replies!
View Related
Cloning Across Tabs
I got a excel file with quite some tabs. And i have 2 questions about it. 1 is it possible to "clone" a button with some macro? Lets say i create a button with a macro on tab number 1, is it possible to clone the button onto the 50 other tabs so i dont have to add the button 50 times? 2 i have a value on tab1, how can i make a formula (on tab number 2) that simple says: previoustab A1 + 2. So when in tab1 A1 i have 1, the cell in tab2 would give 3? I know i can refer to a tab in a formula, but is there a way to just refer to the "previous" tab instead of using the tab name?
View Replies!
View Related
Formula Across Tabs
I have a workbook with roughly 100 tabs and a summary tab for the data within the 100 other tabs. on the summary tab I have column A with the name of each tab, i would like to copy a formula down column B that pulls the data from each tab on cell C5 for example, maybe even look up other info too, but that is another question. What i need to know is can i write a formula that uses the tab named in column A and pulls the cell C5 from that named tab without having to manually change the name of each tab in the formula? The basic formula would be ='17003.05'!C5 however since i have 100 tabs, i did not want to have to go in and edit each tab name.
View Replies!
View Related
Workbook With Several Tabs
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?
View Replies!
View Related
Password For Tabs
I have a workbook where each tab represents a 'base.' You can select which base to view by selecting an option from a drop down box on a menu page. The data for each base is of a confidential nature so I would like to password protect each tab so that it asks for a password BEFORE the page opens. I don't think Excel has the functionality to do this unless I make the pages 'Very Hidden'?
View Replies!
View Related
Email Two Tabs
I currently have the following code below set up which sends out two seperate emails to the same person out of excel. I'm trying to combine this to only send out one email with both tabs:
View Replies!
View Related
Grouping The Tabs..
Is there a way to group tabs? For instance, I have 3 tabs that go with one section and 3 with another and so forth. Is there a way to group them? Also, can you change their color?
View Replies!
View Related
Producing Multiple Tabs
I am looking for a macro or a formula that can give me multiple tabs, what i need is jan 01 to april 30,the next 2 books i could do by copying of course i have looked at the macros on here and no nothing about them ....
View Replies!
View Related
Rename All Tabs In Workbook
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?
View Replies!
View Related
Hide Tabs According To Cell Value
I was wondering if it is possible to hide workbook tabs according to cell value? Take for instance, if cell B30 in sheet "Fee Schedule Finder" is blank then the sheet "ES Schedule" is hidden. I know it would be some sort of VBA code but I am lost on this one. If I didn't explain well enough please let me know!
View Replies!
View Related
Password Protection On Tabs
I have 1 workbook with 11 worksheets. Is there a way users can be prompted for a password when a tab is clicked? if wrong or no password is entered, then show sheet 1 only. 1 main sheet, and 10 sub sheets. Any of the 10 tabs that get clicked need to be prompted for a password, each different.
View Replies!
View Related
Create 3 New Tabs, Name Them, And Use Template
Well I am here at this fork in the road again. I need to create 3 new tabs... 10,4, and 1 I have tried this and it creates the worksheet, but does not copy the "sheet1" as its format. I need to do this 3 times. For i = 1 To 1 Set ws = Worksheets.Add ws.Name = "10" Worksheets("Sheet1").UsedRange.Copy wsnew.Range("a1") Next i
View Replies!
View Related
Sheet Tabs Count
I know excel has a built in function for this. But it won't do what I need for this below. Say, I have 9 worksheets open. In cell N7 on sheet 1 I need it to count the worksheet tabs. But the dilema is to only count the tabs that will equal sheet 1, sheet 2, sheet 3, sheet 4, sheet 5, Notice, I have a space before the number. Other sheets have a specific names to them which I do not want to count. So if sheets 1 thru 3 are visible with the other named sheets visible cell N7 will count 3
View Replies!
View Related
Password Protecting A Tabs
I'm new to the message board so I'm not sure if this question has been addressed. I am creating an excel workbook that two groups need to provide data for, but I do not want the two groups to see each other's tab for inputing data. I know how to protect a sheet in the workbook, but a viewer can still see the contents on the sheet. Is there a way to show the tabs, but when you click on them, it automatically asks for a password before the tab contents can be viewed.
View Replies!
View Related
Macro To Generate 3 Tabs
I am badly in need of a macro that will create 3 tabs using a value in sheet1 cell a1.The tabs created should be unique in the workbook and no sheet has to be duplicated or cancelled.After creating the tabs the macro should also create a list of the 3 tabs created in a sheet called list.
View Replies!
View Related
Worksheet Tabs With Same Cell Name
i got a question for anyone to help me with. i need help in figuring out how to type in a cell (A1) making it changing the worksheet tab as well. I watched Episode 452 of mrexcel's podcasts, but i cant see the text that he typed in. Can anyone help me with this problem or link me to another post where this same problem has already been answered.
View Replies!
View Related
Arranging The Workbook Tabs
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?
View Replies!
View Related
|
TRACKER
