Vlookup And Location...

Mar 10, 2009

I have a VLookup function setup but I would like another function to tell me where in the table array the value is located.

View 2 Replies


ADVERTISEMENT

Interpolation Given A Variable Table Location & Location Of Data Within

Oct 6, 2009

I am trying to develop a spreadsheet that will calculate a cost based on a matrix. I am attaching a sample of the calculation created so far. The end result is in cell M13 and is highlighted in yellow. I kind of layed the formula out in a few different cells, so hopefully it would be easy to follow.

simplify this process with maybe another formula that I might not be aware of, or maybe show me how to get this done in VB code. I think VB code would be the correct way to go just not sure.

View 6 Replies View Related

Return To Last Location

Jul 6, 2007

How do I write a VB Script to take the user back to where they came from.

Example:

User is on Sheet 1 and clicks a macro that takes him to Sheet 10.
I need a macro that is on Sheet 10 that takes the user back to Sheet 1.
BUT if the User is on Sheet 5 and clicks on a macro that take him to Sheet 10
I need that same macro on Sheet 10 to take him back to Sheet 5.

View 14 Replies View Related

Lock Tab Location?

Nov 16, 2011

Is there a way in excel to prevent someone from "re-ordering" tabs in a workbook without using a macro?

I am using a sum formula that goes across multiple tabs, but noted when I rearranged the order of the tabs, that the results of the formula changed. After some minor research, I noted that I had moved a tab outside the "sum range" inadvertently.

View 1 Replies View Related

Defined The Location

Oct 10, 2007

If Worksheets(FirstSheet).Cells(Counter, ColtoMove) = MoveIf Then
'i didn't add the THEN PORTION becasue it errors at the above statement.

the problem is that when i go to the defined location (Worksheets(FirstSheet).Cells(Counter, ColtoMove)) it shows the correct/or same PO number as when i put the cursor over the "MoveIF"....this leads me to think that it should not error.

Could it be a correct statement to say how the MoveIf is defined?

I have added a list of all of the potential values that can cycle through this statement.

how these entries could cause a problem in the above code? I am trying to keep it simple (outside of the long list below that is)

PO Number
3840
4247
4260
17467
21012
38125
90495
132284
133291
133453
133840
135496
135816
4500016105
0026974
0027060................

View 9 Replies View Related

Reference Location

Jan 13, 2010

Is there a formula that will return a specified location (column and row) for a text item within a worksheet?

View 9 Replies View Related

Saving In More Than One Location

Jul 22, 2006

I would like to create a button on a toolbar to save my spreadsheet in 2 locations (always going to be the same, just the file name will change).

View 5 Replies View Related

Allow Save As With Different Location But NOT Name

Aug 26, 2006

I have the following code allowing the user to save a file using a custom macro button. However, I do not want to let them change the name of the file, just the location. How do I do this? ...

View 9 Replies View Related

How To Know Location Number Of Min Value In Range

Mar 31, 2014

A1 cell: 9
A2 cell: 6
A3 cell: 2
A4 cell: 4

i want to know location number of min value in range[A1:A4].

the result: 3

View 7 Replies View Related

Adding Numbers Together That Are From Same Location?

Dec 31, 2013

I attempting to develop a forumla to account for 50 locations I am responsible for that will add different numbers together based on a specific location.

For example, if the location says "Los Angeles", I need the formula to look for all instances of "Los Angeles", the quantity of items sold and add them up for me in one spot.

View 3 Replies View Related

Offset From Location Of Another Cell

Jan 15, 2014

Is there any way to use the offset formula in reference to the location of another cell?

Here is a simplified version of my problem:

Sheet1!A1 refers to Sheet2!A1.
Sheet1!B1 refers to Sheet2!D1.
Sheet1!C1 refers to Sheet2!E1.

Is there any way that I can say that Sheet1!A1=Sheet2!A1 and then use the offset formula based on the location referenced in Sheet1!A1? The cells being referenced are merged cells one column wide and varying rows long, so there is no real pattern to follow except that the corresponding cells (the ones that I want to use the offset formula on) are all taking up the same amount of rows and are an equal amount of columns over (Sheet1!B1 refers to 3 columns over from Sheet2!A1, Sheet1!B1 refers to 4 columns over from Sheet2!A1). The spreadsheet is a fairly complex one and it would be much cleaner and less likely to have any mistakes if I was not referencing each cell individually.

View 2 Replies View Related

Excel Backup Location?

Mar 29, 2006

Excel has a function, everytime when I save the file, it will create a backup. how could I specify the location for my backup file?

View 8 Replies View Related

Default File Location

Mar 26, 2007

I have had my server removed that I had my default file location, when I go in to change any of my options the first thing it does is go look for this file location and brings back an error stating it cannot find the server. I cannot find anywhere else that I could change it.

View 9 Replies View Related

Move Every Second Cell To Another Location

May 20, 2014

I have received a spread sheet with all the data in column A. It follows the format of A1 = Name, A2 = Email, A3 = Name, A4 = Email, etc. for over 800 entries. What I need to do is etract all the email addresses and place them in column B alongside the Name. I don't have any experience with Makros and tried to use one but kept deleting the wrong data.

View 5 Replies View Related

Search For Name Within Many Location Tabs

May 27, 2014

Attached I have my document that I am trying to create a search engine for. I want to be able to search for a name within many location tabs. I want to be able to search by name only, bring over the information, and be able to jump to the persons name. If at all possible i would like to be able to search for all that have been billed but not paid.

FluClinicBilling.xlsmFluClinicBilling.xlsm

View 1 Replies View Related

Popup Calendar Location

Jul 4, 2014

I followed this guide for a popup calendar

How can adjust this so the calendar popups to the right of the cell thats called it. At present it just pops up in the middle of the screen.

View 1 Replies View Related

Sheet Not Saving To Location

Feb 3, 2014

In the attached sheet in module5 I have a save macro with this code

HTML Code: 

ActiveWorkbook.SaveAs Filename:="D:Picking Logs" & _
Replace(sFile, "/", "-"), FileFormat:=52

-This saves it to my computers D drive and works fine.

Then I also have the following code whice is suppose to save it to the public drive which is U: drive, but this computer does not have direct access that that drive so i save it to

HTML Code: 

ActiveWorkbook.SaveAs Filename:="wcrsan1
owley public1 picking logs" & _
Replace(sFile, "/", "-"), FileFormat:=52

-The wcrsan1 is the path i use to save it to th U:drive.

My issue is the code runs fine, but it does not save it to wcrsan1 owley public1 picking logs. If i save it manually it works but not when the macro runs it.

VBA is password protected.. The password is Kayley98 the sheet password is go

ho.xlsm

View 2 Replies View Related

VBA To Create Pie Charts For Top 10 Of Each Location

Feb 23, 2014

Basically I want to have a macro to loop through and make all the pie charts for each location but only for the top 10 of each location.

I also want the legend to be more precise for example, for London the first one in the legend should show:
Column C + "-" + Column I + "-" + Column J

Which would be: London - Rol9 -13

Instead of it being: London data rol9 13

Attached is the document in question where I've made the graphs manually : Example_Pies.xlsx‎

View 3 Replies View Related

Saving In Wrong Location

Sep 25, 2006

I have the following code which saves my worksheet with a name extracted from particular cells:

Public Sub SaveAsMaximoWO()
ThisFile = Range("AC5").Value
ThisFile2 = Range("E3").Value
saveName = ThisFile & " - " & ThisFile2
ActiveWorkbook.SaveAs Filename:=saveName

End Sub

This (for reasons I don't understand) saves the file to My Documents by default.

What I would like it to do is save to another folder within my documents as default.

View 14 Replies View Related

Copy A Picture From On Location To Another On The Same HD

Jun 8, 2009

First of all, I would like to thank all Excel Forum Moderators and Members especially Andy Pope for the great effort they exert to help all members.

Lately, I viewed the thread available on the following link and I admired the great perfect work and codes provided by Andy Pope so much,

http://www.excelforum.com/excel-prog...-userform.html

My request is similar to the points discussed in the above mentioned thread, but, it is a little bit different ..

Instead of inserting the picture to the worksheet, I want the picture to be copied from one folder on the HD to another folder called (Employees photos), which is located in workbook's path.

In other words, I need a code to copy one jpg picture from one location to another.

View 6 Replies View Related

Default GetOpenFilename Location

Sep 10, 2009

I have the following code, is it possible to direct to a default directory that the file might be in? So when I open the dialog box it will automatically redirect a directory that is stored in VBA.

View 4 Replies View Related

Insert Row At Variable Location

Dec 3, 2009

I had a quick question for something that should be simple but I can't figure it out. I have a column of sorted values, it goes

A
A
A
A
A
B
B
B
B
B

and I want to insert a row to separate the A's from the B's. But there will be a random number of A's. I can figure out how to count where the A's end. But I can't figure out how to insert a row. Any suggestions? I tried the two below but they don't seem to work. The for section is counting the A's, and it works, it's what comes next that's giving me a headache!

View 2 Replies View Related

GOTO Contents Of Location

Dec 17, 2009

I have this code that works, except, for addressing with the Goto - I need to go to the CONTENTS (new row,column) of that location which is being changed elsewhere and I can't figure it out

View 6 Replies View Related

Repeating Code In A Different Location

Jan 2, 2010

I have some code that copies and pastes data from one cell into a range. The one cell is B4, and the range is A6:A10. This same action must be done every 30 lines (so the next time the cell is B34 and the range is A36:A40).

What do I need to do to make this action repeat/loop every 30 lines?

View 3 Replies View Related

Set Autorecover Save Location In VBA

Feb 2, 2010

I have a macro which performs the auto save function perfectly. I'm looking at possible enhancements.

1. How to set autorecover save location in VBA? I know how to do this on the front-end i.e goto tools/options/save tab and set it there As i have disabled save autorecovery feature, autorecover save location is greyed out

2. How to create a backup of my workbook? So that my workbook will perform autosave and when i close this workbook at the end of the day all the latest changes are added to the backup and saved

View 2 Replies View Related

Get Current Folder Location In VBA

Apr 20, 2012

How to query the current folder location in VBA?

The macro will need to import text from a file (file.out) located in iteration folders (iteration_001, etc) but I need to start by seaching the location that the excel file has been saved in.

View 5 Replies View Related

Change Cell Location

Aug 7, 2012

I have a row b1, b2, b3, b4, b5 etc. I need to change it to c1,,c2,c3,c4,c5 etc. Is there a fast easy way to do it. I know about $ but I'm past that.

View 6 Replies View Related

Change The Folder Location

Dec 14, 2006

which part of this macro I need to edit to make it open a folder I want?


Sub OpenFolderRequest()
YesNo = MsgBox("Would you like to open the folder to see" _
& vbCr & "which files are currently there?", vbYesNo + vbQuestion, "Open Folder?")
Select Case YesNo
Case vbYes
myval = Shell("c:winntexplorer.exe c:winnt", 1)
Case vbNo
End Select
End Sub

I have tried changing the (c:winntexplorer.exe c:winnt) to the location name of the folder I want to open (S:Stock ControlSTOCK CONTROLOrder Confirmation)but it doesn’t seem to work.

View 9 Replies View Related

ActiveChart.Location Error

Feb 1, 2008

I am writing a macro to place a graph into every worksheet.

View 9 Replies View Related

Formulas In A Central Location

May 17, 2008

Is it possible to have the formula written in one remote cell, so that any modification done in this formula is reflected on all places where its refereced to?

z26 : Formula A

A1 : Formula A
A2 : Formula A
A5 : Formula A
A6 : Formula A
A7 : Formula A
A9 : Formula A
A11 : Formula A

in this example i store the formula in z26 and variety of cells in A are using it (not all of them)Suppose if i change anything in z26. I want it reflected in all the cells that are using this formula?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved