final

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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>...

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...

How do you do it?

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...

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...

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...

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...

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...

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...

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...