# Return Cell Location: Of Several Items

Aug 27, 2008

I would like to return the cell location of names in column A as they are located in columns B and C, and return the locations in column D....

## Return Active Cell's Location/row

Apr 9, 2009

I'm having trouble identifing a way to return a location for the position of the active cell. I've searched Excel help with "Position, location, return, activecell, etc." and I can't seem to figure this out. I know that it's possible, so that's why I'm on here!

...

Ok, say the active cell is currently "F1", and I need the location "F1" to identify the ROW to be used in a formula later, how would I go about that?

The current contents of cell "F1"' will be "REPLACE", but I need to change the words "REPLACE" in "F1" and other cells labeled "REPLACE" in column F to the following formula (where the "1" in "A1" is is the current row):

## Formula To Return A Cell Location Not Cell Value?

Jan 31, 2013

Is there a standard way across all Excel formulas to have the cell location returned rather than the value of the cell itself?

In other words A33 instead of "52" (with A33 being the cell that contains "52")

## Sumproduct To Show Value Of Items Retrieved From Particular Location Per Month

Aug 1, 2014

I have a list of items in column A. Column B has each item's net price. Columns C-N shows the consumption of the items per month. Column O shows in which location the items are stored.

I need to do a sumproduct so that it shows the value of the items retrieved from that particular location per month.

If it didn't have to be by location, I would've simply done something like =sumproduct(\$B1:\$B10,C1:C10) and copied it across the columns. How do I tell excel to sum per location as well? I know there is a simple solution to this, just not seeing it...

EDIT: I tried =SUMPRODUCT((\$B1:\$B10)*(C1:C10)*(O1:O10=\$B1)) but it gives a #VALUE error

## How To Combine Selected Items Of List And Return In Cell

Aug 22, 2014

I have a global list in B column and I want to create a text about the list. If I put "1" in A column, I want my text to be on B11 for the selected items. So excel should do a loop for the selected range and combine the selected items in a new line and give me as an output.

You may see the picture Untitled 1.jpg

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.

## Save & Return To Last Location

Jun 9, 2006

User selects 'go to page B' on page A. They look at an object then click the object to go back to page A. Once back on page A they need to check data on page B, but in the same general location as where they just looked. This is over simplified, but pretty much sums up what I need to do. The code I have now is below, but keeps sending me to the last selection on my current page.

Public Sub SaveLocation(ReturnToLoc As Boolean)
Static WB As Workbook
Static WS As Worksheet
Static R As Range
If ReturnToLoc = False Then
Set WB = ActiveWorkbook
Set WS = ActiveSheet
Set R = Selection
Else
WB.Activate
WS.Activate
R.Select
End If
End Sub

Public Sub SetSaveLoc()
SaveLocation (False)
End Sub

Public Sub GetSaveLoc()
SaveLocation (True)
End Sub

## Return Cursor To Last (previous) Location

Dec 30, 2008

I am familiar with the codes suggested here: http://www.eggheadcafe.com/software/...-previous.aspx

I move the cursor with Hyper-Links or just by clicking another cell.

I wonder - is there something I can add/do in order to enable returning from ANOTHER sheet !?

## Search One Column For The Location Of That Value And Return The Row Value

May 8, 2008

I have a value stored in variable A. I need to search one column for the location of that value and return the row value. there is no chance for a duplicate entry. Is a loop my only option, or is there a find command in VB?

## Find Address And Return GPS Location From Another Sheet

Jun 3, 2014

I have a table with customers and their addresses (sheet2) and I need to find their GPS locations in sheet1.

I guess the logic would need to be something like this:

find CityName and StreetName in sheet1 where StreetNo is between minStreetNo and maxStreetNo return GPS X and GPS Y

with the formula or VBA code?

Example.xlsx

## Excel 2007 :: Search Box Function - Return Value / Text Not Location

May 15, 2014

I need code for a search box function, that returns the information recorded in a cell for example, "Barcelona" or "London" etc), instead of the location of the cells.

I will need to narrow it down to search only the information in the following columns:

Sheet2
I2:J10932

I am totally new to VBA coding and have stumbled my way through a few things, but everything I have searched for so far has had at least one error when transposing to Excel.

I am running Excel 2007.

## Compare Duplicate Items And Return A Value

Jan 19, 2010

if there is a way to find duplicate items in a list and return a value, if a duplicate exists.

Basically I have 19 buildings each with a separate bill of quantities. I'm looking to compare and compile a comprehensive list. So that duplicate items in different buildings can be compared side by side.

I have attached a sample of what I am trying to do.

## Return A Value Based On 2 Items From List

Jan 19, 2009

In Excel 2007, I need to be able to return a value (definition of something) based on what is selected in 2 other cells.

(See Attached)
If in cell C2 I select "competency 1" and in Cell C3 I select "Expert", I need to be able to return the definition for someone that is an Expert in Competency 1 in cell D2.

Then, if in cell C5 I select "competency 2" and in Cell C6 I select "Leading", I need to be able to return the definition for someone that is Leading in Competency 2 in cell D5. And I'll be doing this about 10 times on each sheet.

All the tables with info are in another worksheet. I can do a vlookup if I'm just using one thing to match, but how do I match 2 things to return the definition?

## Lookup & Return Multiple Items

Dec 21, 2006

I am trying to make a search form in Excel 2003 where I can lookup data for a specific value which may have multiple rows. I have several columns, column A Tracking Number, B Order number, C Item Number, etc.

For example; Order number S6001 has three item numbers on rows 1,2,and 3.

I can get the data on row 1 using the basic "LOOKUP" function but not rows 2 and 3. How do I have all of the line items (rows) returned for that order number.

## Loop Through A Column And Return Count Of Items Not In List?

Jul 16, 2013

I have data in range A2:E5000. Column D contains cost centers entered by users.

I also have a list of valid cost centers in range K1:K10.

What would be the vba code to check and return the count of the items entered in column D which are not valid, based on the list in range K1:K10?

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

## Searching A Column For Specific Text To Return A Number Of Items Found

Apr 28, 2006

on one sheet we have a summary of the main list, which includes totals of money recieved, totals of all the different sources (ie, where they heard about us from), the totals of the frequencies they pay (ie, how many donate monthly, quarterly...) ... etc. on the next sheet we have the "main" list of donors, their IDs, amounts, frequency, source ...

the totals on the first sheet are updated manually, but i want to change that as there are a great number of errors.

## Excel 2010 :: Find A Cell Within Range Then Copy That Cell To Another Location

Sep 26, 2013

(I am using Excel version 14.0.7106 and MS Office Professional 2010.)

I have a macro in which I have named a range of numbers in a spreadsheet, used the "find" function to find a particular number in that range, and now would like to copy some information into a cell in the same row as the found number. However, when I try to move over to the cell that I'm copying to, it only goes to the 1st row in the range that I have defined.

Here's the portion of code I think you need to see. Everything works...it finds a match...but then I don't know what to do from there to get the information to the correct row:

'Grab the 1st project number
Range("C8").Select
Do Until ActiveCell.Value = ""
If ActiveCell.Value "" Then
prjnum = ActiveCell.Value
Selection.Offset(0, 8).Select

[Code] ..............

## Search Coloured Cell In Worksheet And List The Cell Location

Jan 10, 2013

I have a worksheet size roughly 100 * 400 cell. there is roughly 100 cells filled with RED color and with different value.

When i used FIND ALL format - RED, I can locate the cell location and the cell value. And I wish to copy these 2 info onto a new sheet so that on the new sheet, I can create a hyperlink and easily access to the location of the RED cell.

However, in FIND and REPLACE, i have a list of results on what I want. But i cannot copied the information out. So is there anyway to copy it out or to achieve what i want?

For eg.
RED value
cell
50
A3
87
D71
251
AQ5

and so on.

## Finding A Cell In A Variable Location Based On The Contents Of The Cell

May 2, 2012

I am creating a macro to automate data analysis for work, but I've become stuck.

I need to find the coordinate of the first cell in a column with word "reserved" or "extended" contained in the cell, and then assign the row number of that coordinate as a variable to use for moving data around. Basically, I want something like VLOOKUP, but instead of returning a value, I want it to return the coordinate.

## Copy Cell To New Location Based On Criteria In Another Cell?

Jun 25, 2014

I've sent out a survey asking people to sign up for one of two groups, A or B. I have a table with a long string of responses, with the name in column A, and in columns B or C there is an X that shows whether they have chosen Group A (column B) or Group B (column C)

I am trying to write a bit of code where it would paste the names into a new table with the headers Group A and Group B. Here is what I have pieced together so far:

Sub Create_Groups()
For i = 2 To Range("B2").End(xlDown).Column()
If Range("B" & i).Value = x Then

[Code].....

## Return Row Index Of Selected Items In Multi Column Multi Select Listbox

Jun 30, 2014

I have a listbox with 8 columns. Multiselect is enabled, and it must stay this way. As part of my program, after the user presses a command button, I need to use the row indexes of the selected rows in order to copy the selected information into an array which is then placed in a different listbox, and then delete the items from the original list. Pseudocode of what I want to do:

[Code] .....

But my understanding is that .ListIndex does not work this way with multiselect listboxes. I've tried searching for a solution for a while, but I cannot find one.

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

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

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

## Finding The Location Of A Cell

Jul 10, 2006

i am trying to find the location of the current cell and use the information to print it to screen. For example, if the cell A1 is selected, i need to get the location A1 and use this value for a vlookup. is there a method that returns the current cell location "A1"??

## Move/Cut Cell To Another Location

Aug 23, 2006

I would like to how I can move the words "Total List Price" over to column "C" rather than have it displayed in column "A". If someone can please advise me as to what part of the code I must change in order to have these changes take place

Private Sub CommandButton1_Click()

Selection.SpecialCells(xlCellTypeFormulas, 16).Select
Selection.ClearContents
Range("A8").Select
Selection. Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(6, 9), _
Replace:=False, PageBreaks:=False, SummaryBelowData:=True
Application.Goto Reference:="models2" ....................

## Using 2 Variables To Return Multiple Items From Multiple Sheets

Feb 14, 2009

I have a need to populate a summary worksheet using two variables to find data in two or more other worksheets.

I find writing out what I want helps some times so let me try it here.

So my variables are:

Product (there are 22 products)
Supply Less than (inset number)

These are the two criteria I want to use to produce a result.

The next issue is I have 300 stores that carry said 22 products. Each store has a unique number 0001, 0002, 0003 etc. So in a separate worksheet I have a list of the store numbers, and then the products. So each product has the store's number to the left in Column A, Column B has the product name, Column C has the quantity on hand.

What i would like to do on the summary page is select the product, and then select the supply less than or equal to 'x' and then have the stores with the selected product less than or equal to x display below.

The last part of this is then to display (data from an other sheet) on the summary page which contains the quantity of the product selected available at the warehouse for that store.

## CountIf - Locating Cell Location

Apr 2, 2014

I have a column full of data like the below with relevant data on the same row.

I wish to locate the cells which have a specific section most importantly without the "cartridge only" so for example with the below

Word Academy (Nintendo DS)
Word Academy (Nintendo DS) (Cartridge Only)

This would show 2 given there are two with the specific text "Word Academy (Nintendo DS)" there will always be a cell without the (Cartridge Only) part so for this the formula =COUNTIF(D:D,"*" & D1 & "*") seems to do the job to simply count the cells with that in however I do not wish to do this.

What I need to do is locate the cells that have this in but match them together in a large sheet so basically I somehow need to be able to locate the two corresponding cells which both have one of the cells values of "Word Academy (Nintendo DS)"

The cells have data in the row which I need to tie together to create a total value.

For example

Title Qty
Word Academy (Nintendo DS) 5
Word Academy (Nintendo DS) (Cartridge Only)6

I need to locate the all the cells with "Word Academy (Nintendo DS)" in which would mean just the two cells "Word Academy (Nintendo DS)" + "Word Academy (Nintendo DS) (Cartridge Only)" in the above instance but I need it to then see the cell which has that in its title and add the quantity of the two together leaving me with the below

Title Qty Actual Qty
Word Academy (Nintendo DS) 5 11
Word Academy (Nintendo DS) (Cartridge Only)6 11

Which is basically just adding together the quantity shown on the spreadsheet in the rows with the containing text "Word Academy (Nintendo DS)" and as "Word Academy (Nintendo DS) (Cartridge Only)"

On the attached spreadsheet Column L is an example of the result I would be desire, I have put a basic =sum formula in to just represent the value it should be showing.

## Find MIN Location, Show Cell Next To It

Sep 23, 2008

I imagine this is pretty simple but for the life of me I can't figure it out. Here's what I want to do...

Find MIN in Column F
After finding the MIN in F (let's pretend F222 is the current min)
Show the text in the field next to it (in this case display text from E222)