I use a Workbook with several Sheets. I want to be able to quickly move to the same cell (whatever cell is currently in use) up and down the Sheets. Ideally I would also like the chosen cell to be centered on the page as well!!
View 2 RepliesThere might be a really easy solution to this, I'm just having a tough time figuring it out. I have hyperlinks that link to cells on another sheet in the same workbook. I would like, after the cell is selected, for the selection to be positioned at the top of the sheet.
View 5 Replies View RelatedI have a dropdown list with names of different people: Bob, Jane, Joe, et cetera. I also have tabs at the bottom (sheets) for each of these people. Is it possible that when a name is selected from the dropdown box in column D, say Bob, the whole row (row 10 or whatever) is cut from main sheet and put into Bob's sheet, then the row is deleted from main sheet? If this doesn't make sense (because I stink at making sense), just let me know and I will try to clarify
View 14 Replies View RelatedI have one very large piece of data located in one worksheet that I use across ten other worksheets. I simply copy and paste this data into each worksheet each morning after the data has been refreshed. Is there any way to be able to simply have my master sheet update and then get coppied to all of my other sheets?
View 9 Replies View RelatedI have a macro that will open all the workbooks in a specified folder, regardless of the actual number of workbooks...All worked fine, until I tried to move a particular worksheet, from each wbk, into another specified wbk....The files open correctly, and copy / move the sheets correctly to the assigned wbk...but...it won't stop inserting sheets..it starts over and continues the process....?????
Option Explicit
Sub rbaOpenAll()
Dim x As Integer
Dim WB As String
Dim wbk As Workbook
For x = 1 To 100
WB = "G:ClaimsXtenTESTRBARBA " & x & ".xls"
On Error Resume Next
Set wbk = Workbooks.Open(Filename:=WB)
Worksheets("Current Rules - 1").Activate..............
I am working on a macro which transfers data from one sheet to another. The code starts by taking cells M1:P1 from sheet SL_Background and moving them to B9:E9 on sheet CreateSL. It then moves to the next set of four cells on SL_Background (Q1:T1) onto the next line down on sheet CreateSL (B10:E10). I am repeating this process about 180 times right now and it is all coded like this:
VB:
Sheets("SL_Background").Select
Range("M1:P1").Select
Application.CutCopyMode = False
[Code]....
So what I would like to do is to make something that automates this process and will eliminate more than 1000 lines of code.
Remember Lotus used to do this?
I have on one sheet - 600 rows of financial products by 100 regions worth of $ balances and on another identically formatted sheet the associated interest rates.
I just want to page down on the $balances tab and have interest rates tab move in sync - letting me eyeball the related info.
I've tried searching for an hour to come up with the right terms - split, freeze, etc.
Can someone help me i have a few columns of information i need to move over to a another sheet, but the problem is the information i need to move is the end result of a formula and when i move it the answers are gone how do i fix this,,,,, and both sheets are on the same work book as well
is there a vlookup formula to use,,,im not experienced in Vlookup up formulas
My code below is supposed to move filtered rows in 2 sheets ("BANK ENTRIES" and "GL ENTRIES")with "Y"/"y" character on column J which is manually encoded by user. The rule is, before they can move, the total amount in column I in both sheets should match. That is the reason why rows in both sheets should be moved at the same time. I was able to figure out this rule with the use of an If Statement and a message box.
My problem is, if I run the code where there is only 1 row remaining in both sheets, "BANK ENTRIES" would insert a blank row in the third line despite my if statement
[Code] .....
The second problem is, If I run the code on "BANK ENTRIES", my first header on the "GL ENTRIES" will be deleted. If I run also the code on "GL ENTRIES", my first header on "BANK ENTRIES" sheet will be deleted. There must be something wrong on my code. I am attaching my working file for you to have a clear visibility on my problem.
Attached File : xx_xxxx_xxx_Template2_2013-11-30v3.xlsmβ
Could some one amend the VBA below to allow a continous loop on moving to the previous sheet within a workbook. Currently when I move to the first sheet if I use the shortcut key I get a debug error.
View 6 Replies View RelatedI know that the shortcut for moving the cursor to cell A1 of an active sheet within a workbook is Ctrl + Home. However, I thought there was a shortcut (using just keystrokes) to do this for all the sheets within the workbook. Is there such a shortcut?
View 1 Replies View RelatedIs it possible to position a predetermined cell (e.g. A42) in the top left corner of the screen. (Not every screen users use has the same size)
View 3 Replies View RelatedI have an excel work book with 6 tabs. I would like to have Excel move an entire row from one tab to another tab (removing the row and inserting it in the other tab). I.e. Example I have a tab with items that are marked as "Open Actions" so if I were to change the drop down to close. Excel would move that entire row of actions to the tab with the "closed actions" and insert into the next available row. Now if someone were to come back at a later date say no it should be reopened than I would change the drop down to open and excel would move that row back to the open actions tab into next available row. I tried a PIVOT table and no good I played with few macro and not.
View 5 Replies View RelatedI have some cells with some spaces and then text where I want to find the position of the first letter. Do any of you know about any function I can use?
The example below contain 5 spaces and then my name. It should give me the answer 6.
" Magne"
Here is example... Explanation is in the title
Book2.xls
I would like to end a macro with a specific cell (e.g. E50) in the first cell in the upper left hand corner of the screen. How might I accomplish this?
View 3 Replies View RelatedI have a user who has created a spreadsheet and wants to fix the charts in a particular position.
When she places them in one position and saves the spreadsheet they appear to have moved the next time she opens the spreadsheet.
Is there any way to fix them in a certain position without having to protect the worksheet?
In cell A2 I have text with a lot of /, so I need formula that will return the position of the before last / in the cell. (Or the last if above isnt possible).
View 9 Replies View RelatedI've written code that involves adding a number of new sheets to a workbook. I want to specify that each new sheet is positioned to the right hand side of all other sheets in the book, so that the sheets are positioned in the order (when reading from left to right) that they are added.
I know about the Copy After:= thing but I only know how to specify copying after a particular sheet name. I could solve my problem by each time referencing the sheetname from the previously-created sheet, but I think there must be a way to it properly.
I have created a button in an excel worksheet that when clicked, creates new tabs each containing a chart. I have tried to modify the code to position the chart within a specific range of cells on each tab, however, I have not been able to get it to work. Below is my code. Please see the code following 'Add the Chart.
VB:
Sub AddCharts()
Dim lastr As Long, r As Long
Dim shname As String
Dim ltitles As Range, rng As Range, rData As Range, x As Range, tbl As Range, r2Data As Range
On Error Goto ErrorCatch:
Set ltitles = Sheet1.Range("A3:N3")
Set rng = Sheet1.Range("A4:A" & Sheet1.Range("A3").End(xlDown).Row)
[Code] ......
ErrorCatch:
'Debug.Print Err.Number
'Debug.Print Error
If Err.Number = 1004 Then
shname = x.Value & x.Row + 1
End If
If Err.Number = 20 Then Exit Sub
Resume
End Sub
Formula/code to change the position of where the subtotals are placed. I don't want them appearing at the beginning or end of the data set but in a separate column beside each data set. how to access the code so I can try and alter it myself.
View 14 Replies View RelatedA simple question:
I have a column of numbers, for example:
2
5
5
8
8
8
20
50
I would like to know the value that corresponds to (for ex.) 5th position from, of course, the beginning of the column, ie 8.
How to find position of lust number in column (non macro preferably).
2
3
1
3
2
1
3
2
1
For number 1 match will return 3 but I need 9 (and I can't sort column opposite)
I'm am trying to find some way to determine if a particular tab falls before/after/between other tabs in a workbook. For example, if I have a tab "Top" and a tab "Bottom", I want to be able to determine if tab X is between them.
View 14 Replies View RelatedI have an array that I want to go through several times. I want to try something like this:
[Code] ......
I cant just say "If Val < 7 Then" because it will spit out the string where "Val" is.
I know that I could create another variable like so:
[Code] .....
but this doesnt seem like an elegent solution...
How to know the position of third comma in the same cell.
I am aware that you can use Match to find the position of an entry in an array, and the following code works as expected, returning an index of 4:
View 2 Replies View Relatedhave an assignment to complete and one of the tasks I found impossible to complete. First condition is that it should be completed with a formula (not VBA). So here is the task - I have different cells with IBAN codes in them. The 14th position in the IBAN is used to identify the currency of the account. There are 3 possible numbers - 0, 1 and 2 and each is for different currency. So I have this table where I need to lookup the 14th character in the cell with the IBAN, from there the formula needs not only to check what the number is (0,1 or 2) but also to compare it to another table from where to decide which is the currency. I tried various combinations with FIND/SEARCH but can't find a way to do it.. and I can't find other functions/formulas that can isolate a particular character position in a cell..
View 3 Replies View Relatedif i have an array myarray=array("MA","PA","CA")
is it possible to go down a row and if it said "MA" then return 0 or if it said CA return a 3 the number of the array position
How do I insert a row using a macro button that insert the row beneath the row that the macro button is touching?
View 9 Replies View Related