1. T

    Help copying data and transpose from one sheet to new sheet

    I have an issue. I told my wife I could write a script for this. Well its a bit out of my range. I thought it was easy but its not for me because I dont do this enough. I have a spreadsheet and lets say I need to copy A2, D2, and E2 to another sheet 20 times but I also need to transpose the...
  2. King Mustard

    Forecasting the next number in a list?

    Is there a formula that I can put next to the final date that will "forecast" the number? My car contract allows 12,000 miles per year and I'm checking if I'm estimated to hit it.
  3. T

    Automatic alphabetic data extraction macro needed

    I came across someone in the office today that has been spending huge amounts of time on unnecessary copy/paste/sort gymnastics and it hurt my soul to watch. I know you geniuses can help me/her out so here's what she's doing... She's working with 3 spreadsheets; I'll call them Initial...
  4. C

    Copy Multiple Columns and Paste to Different Sheets based on Header

    Hi All! I'm creating a dataset type of spreadsheet where I monitor data of three different types for example distance , velocity and acceleration. Each has its own sheet and results are logged for different years 2015,16,17,18 etc. Id like to program an input data tab where i can paste the...
  5. T

    VBA to Lock all Cells in all Worksheets

    Hi All I have an excel workbook with around 6 worksheets, when the final user presses a button I want all the cells in every workbook to be formatted to "Locked" and then every worksheet locked with a password. Basically once the final user signs it off the workbook can no longer be edited...
  6. T

    How would you set this up - building from scratch

    I'm building a Macro for a project. It's going really well but quite a learning curve. The project has about 20 outputs. The first steps for all 20 are the same, but at a certain point the process diverges for each, mainly in terms of producing a Pivot Table with different fields (but all from...
  7. R

    Count the character number behind a certain character

    I hope someone can assist with this question. I require to understand the number of characters behind the final '\' character. Example: Monday\Tuesday\Wednesday Answer in next cell = 14 (14 characters behind the final '\') Or is a possible solution to count where the final '\' is in a...
  8. J

    Formula help

    Hi,Some help please. I've looked at LOOKUPs, IF, ANDs and I can't seem to figure out the correct formula to use. Column A contains a half year score and Column B contains a full year score, Column C is the 'reference' for the final year score. I'm looking for a formula/way for excel to return...
  9. D

    VBA Google Maps to return the URL of the final Loaded Page

    Hi, Can anyone please help? I have the following code and I am looking to Google Maps to return the url of the final page. At present it is only returning the intitial load up url. Below is my simple code so far, Sub GotoAddress() Dim IE As New InternetExplorer IE.Visible = True...
  10. X

    Converting Formulas to Ultimate Cell References [IndexMatch, Offset, Indirect]

    Hi, I was wondering if it would possible to convert Formulas to the most final cell reference using VBA Macro. For eg. Let's say the formula in Cell H2 is as follows =IFERROR(INDEX($D$2:$D$7,MATCH($F2,$C$2:$C$7,0)),"") Now let's say the evaluation of this index match function directs us to...
  11. E

    Multiple IF selection formula

    Trying to come up with an IF formula that gets to the "Final Choice" selection in the last column (E). Choice #1 will always have priority over all other choices. Thanks. <colgroup><col span="4"><col></colgroup><tbody> <tbody> A B C D E 1 <tbody> Choice #1 </tbody> <tbody>...
  12. N

    Nested If Statement with AND

    I am hoping someone can correct my nested if statement belowto work properly. I am sure I am nesting incorrectly with using (AND( in themiddle of my formula. I could use the VLOOKUP but I am hoping to avoid it ifpossible. From what I have searched online it appears the AND or OR statementsseem...
  13. J

    Help please..... EXCEL VBA to split sheet and save multiple workbooks named as "date" & "S_no" +1

    Hi there - could someone please help me - I have been searching amongst many threads to come to a solution, but whilst there are many posts that help a little, I cant get the final result. I have a workbook that could have as many as 1000 lines. The data is formatted OK and ready to go...
  14. T

    How to use continuous If else loop in Excel with

    I have a data set with 4 columns - Original Bank , Acquiring Bank, Acquired Status ( Yes/ No) , Final Bank Name Depending on whether the acquired status is yes or no, I want to copy the bank name to column Final Bank Name. Following rules apply :- a) If the bank under column Original bank has...
  15. I

    Which formula to extract part of the text ?

    Hi there How to extract through formula just the numbers highlighted in red color mark ? Take into consideration sometimes the currency appears as "R$" and others just "R ". Thanks in advance ! <tbody> (VisaPlatin )Santander Informa: Compra APROVADA Cartao VISA final 0292 de R 38,90 em...
  16. H

    Summing totals from multiple tables

    I have a worksheet with 6 tables, each table ordered in date order, with a balance/total for each table in the final cell; and I want to sum those final balances and have that sum adjust dynamically as additional rows are added to each table. I am only interested in the final value for each...
  17. H

    IF column "I" contains certain text, move to cell below and replace the original cell with "Total"

    Hi all, So I'm stuck with getting my cut/paste vba to work as well as a separate question. Here are my criteria: Column "I" contains only one instance of the word "Final". Need to cut/paste "Final" so it moves 1 cell below. Need to insert the word "Total" into the original location of the...
  18. J

    Function for checking a cell and if it holds text "N/A" move right to next cell

    Hey everyone! I'm working through a little but of an issue. Trying to think of a way to write a function that will cause it to check the cell to the right of it and if it has "N/A" to skip that cell and move to the cell to the right of it check that cell if it has N/A then move to the right...
  19. V

    formula to derive district with maximum count

    Hi All, Need a formula to derive the final district by looking at the maximum count. There are duplicate accounts against which there are number of counts, the district with maximum count of these duplicate to be derived in final district column. In event of tie any one of the district can be...

Some videos you may like

This Week's Hot Topics