Program Picks 2 Values From The Same Cell Locations

Jan 10, 2008

The thing is that i have alot of sheets (more than 20) and my program picks 2 values from the same cell locations on each sheet. This leeds to more than 30 arguments in my formula. I am gonna use this for alot of excelfiles constructed in the same way, but with varying order and names on the sheets.

View 9 Replies


ADVERTISEMENT

Excel 2010 :: Display Cell Ranges From Multiple Locations Based On 2 Cell Values?

Jun 4, 2013

I need to display a set of cells based on the value of two drop down cells i have. As I am not very good at english and worse at explinations, I'll try via screen shots...

I have two dropdowns (C4 and C6) that will indicate what table to use (Second sheet / screenshot). I want that "table" to display in the yellow box on the first page. To complicate matters, some options do not have a CLA option - those starting with X. As there are 24 different outcomes and each is 3x9 if/then statements just dont seem to cut it.

P.S. I have excel 2010 and windows 7

View 1 Replies View Related

Turning Locations In Cells Into Values

Aug 4, 2009

I am looking to do find the latest date in a list of dates but have several problems:
1) The dates are all in one column on worksheet 1, but are sourced from other worksheets. So even though it looks like '8/7/09', the value of the cell is 'Worksheet2!B4'. This is making the MAX function not work

2) How to deal with the blank cells in the MAX function?

View 12 Replies View Related

Pull Unique Values From 3 Locations

Nov 19, 2006

I would like to create a macro which will look at columns A,B and C. Based on A,B and C, I would like the macro to return only the unique combinations. At the same time, I would like columns D and E to perform a sum.

This is the original sheet:

******** ******************** ************************************************************************>Microsoft Excel - Trial19.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutE1E2E3=
ABCDE1A1YES1032B2YES1013C3NO1034D4MAYBE1015D4MAYBE101NJSS*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

This is what the sheet will look like once the macro I would like to create is executed.

******** ******************** ************************************************************************>Microsoft Excel - Trial19.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutE1E2E3=
ABCDE1A1YES1032B2YES1013C3NO1034D4MAYBE202NJSS*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

As you can see, the highlighted areas denotes the changes that were executed through the macro.

View 9 Replies View Related

One Cell Reading From Different Locations

Dec 1, 2008

the attached workbook, I am looking for M19, N19 & O19 to read from different locations depending on how many cells are called on when info is entered in P8.

View 10 Replies View Related

Same In-cell Dropdown In Two Locations

May 21, 2012

I made an analysis table that shows a list of prices on a certain company. I have a table on one worksheet and I made a chart (from that table) on another worksheet. I'm using an in-cell drop down list on the table worksheet to change to different companies. Is there a way that I can put the same drop down list on the chart worksheet? Essentially, I want to be able to switch the company on either worksheet and have it change on both worksheets. I'd like to keep the chart and table uniform and running together.

View 6 Replies View Related

Highlight Specific Cell Locations

Nov 28, 2007

I have a spreadsheet (70 columns numbered 1-70 x 200 rows (1-200) and I need to highlight specific cells using the respective co-ordinates i.e. row x column which I have in separate columns.

View 9 Replies View Related

VBA Cell Select Button To Jump Around To Standard Locations In Each Worksheet

Sep 25, 2009

I'm using a button in my sheet to jump around to standard locations in each worksheet. Generally in the active worksheet I have these three buttons working perfectly.

However I have one button that takes you from the worksheet into the dashboard. The problem is if you had scrolled the dashboard around you may be put at your last place. I want the screen to jump to and center on R1C1

View 4 Replies View Related

Nested IF Or Range: Only Picks Up On The First Two Characters

Sep 11, 2009

I'm having difficulty creating a nested "if" or range formula that basically only reads the first two characters of the data in a given cell. See attached spreadsheet.

In column "A" I have listed the product ID. If the product ID has the first 2 characters 'DV' then it should yield the result of Dryer. The main issue is creating a formula that only picks up on the first two characters.

View 4 Replies View Related

Picks Up The Drifferences Between Low And High Numbers

Jun 5, 2009

picks up the drifferences between low and high numbers for example 1-10 is low 11-29 high and 0 is a alternate so say i start typing in 1,2,3,11,15 in the top cell they start decending down the rows automtically and the program has 2 boxs indicating 3 lows and 2 highs and wen i type in a 0 it resets the two boxs to 0

View 5 Replies View Related

Macro Or A Formula Which Picks Up The Workbook Name

Jul 10, 2009

I have two workbooks kept open - ABC and 123.

I need a macro or a formula which picks up the workbook name - ABC

Simply I will always run a macro in the workbook 123. So i should get the workbook ABC automatically

View 8 Replies View Related

Change The Content That Ctrl+x Picks Up

Nov 14, 2009

I want to be able to define on excel 2007 what gets cut when I cut and paste

cause I just want text, comments, and font formatting, i dont want the fill of the background or border when I cut and paste

View 9 Replies View Related

Lookup: Picks Up If A Variation Number Has Been Entered

Aug 11, 2009

I have been working on a spreadsheet with 3 sheets and have done everything except the last function which I just can't work out. Data is entered on the first sheet in a list with an item number, description, dates etc and then finally, if they are a certain type of item, a variation, a 'variation number' in a column.

The next sheet is then called 'variations' and here starts my problem. I want to have a formula that picks up if a variation number has been entered on sheet one in the 'variation number' column and if so, add that item into this sheet, in order.

So to summarise, I need sheet 2 to search on sheet 1 in a specific column for numbers 1-30(ish) for a series of items. I then need sheet 2 to list each of these in order, copying over each item that goes with the number from sheet 1 in the same format.

View 5 Replies View Related

Macro Which Picks Out Dates And The Data Relating To Them

Oct 29, 2008

At the moment all our work is logged by codes eg. A1Misc, B5Change, N9Important. As well as the codes, we enter the date in the column next to the code along with another Column to show the amount.

I need a Macro to look at the date column and only take dates which have Sept then go to the column next to it and pick up the codes individually and sum up all the amounts for the codes.

I have attached an example which shows from A13 downwards what I need the macro to show when finished.

View 3 Replies View Related

Conditionally Program A Cell...

Jun 2, 2009

Can I program column B to show a certain value depending on the presence of a string of text in column A? For example, if A1 contains the word "Barbie", then cell B1 shows the value: "Ken"

View 5 Replies View Related

Program Not Picking Up Cell Value

May 3, 2007

I have a simple program that picks up an ID on sheet1, finds that ID on sheet2, picks up the information in one cell from sheet2, and brings that information back to sheet1.

The program works fine until for all IDs above row 570. After row 569 something strang happens. The programs is still able to find the ID but when it tries to pick up the one cell value it is saying it is blank yet you can physically see the data is present.

In all my years of VBA programming I have never encountered anything like this. Especially, where things work fine on half the worksheet and not on the other.

I am posting the code below, but I don't actually believe it is in the code. I cannot post the workbook because of the information it contains...

View 9 Replies View Related

Display Popup When User Picks Item From List

Dec 6, 2007

I have a group of validation list boxes, all with the same choices, that when a user selects a certain item from them I want a popup box with extra info in it to appear. Is it possible for the user to click on the popup box once to make it disappear again?

View 6 Replies View Related

Running A Program Command Within A Cell

Jun 8, 2006

This is the command I want to run from a cell:

c:windowssystem32mstsc.exe /v :<servername>

This will allow me to click on a servername in a column and RDC into it.

View 9 Replies View Related

How Do I Program Multiple Conditions Within A Cell In Excel?

Jun 3, 2009

Trying to program cell C1:

If A1 is between .81 and 3, AND if B1 is Adult, then C1 is Priority Mail
If A1 is greater than 3, AND if B1 is Adult, then C1 is FedEx Ground
If A1 is Less than .81, AND if B1 is Adult, then C1 is First Class Mail
If A1 is Less than .81, AND if B1 is Child, then C1 is Hold for Inspection

etc.

There will be a list of ~45 conditions that will populate a specific value in C1. Can this be done? If so, how?

View 6 Replies View Related

Text To Columns Function Picks Wrong Number Format After Conversion

Jun 16, 2014

Using the text to columns option on a comma separated file in csv format leads to the right preview in the text to columns wizard.

The column titled "ATTIC: Zone ..." shows the desired format in the preview window. Please look at the screenshot 1.jpg.

After pushing the finish button to obtain the result the number format gets suddenly changed and differs from the preview.

Again check for the "ATTIC: Zone ..." column as reference: 2.jpg

Is there a menu where one can look up, or specify how to format data to force the right comma placement? What settings might be wrong?

View 3 Replies View Related

VBA Program To Sum Values In One Column If Another Column Holds A Particular Value?

Mar 5, 2014

I am trying to use the SUMIF statement to add one column if another column has a specific part number...the issue is that I cannot use SUMIF directly as there are random gaps in the columns.

For example:

Column 1:
Quantity
3
6
2

4
2
1

Column 2:
Part Number:
884
124
884

124
884
124

The spreadsheet needs to be able to add the total number of parts produced and output that number in another cell.

View 8 Replies View Related

Set Locations Using VBA

Dec 5, 2007

I have to manually cut/paste each excel doc which belongs to a specific Store folder, and copy then into their own shared directory, so for example:

Lets say my company has 10 Stores, and I know their online folder locations, the first step I guess would be for me to map the locations of each store, I am not sure what the best way to do this is, would I use the Case select ? to make the set = ?

So for example, Stores 1 - 10.

Set 1 = Dir("Z:Northwest1")
Set 2 = Dir("Z:Northwest2")
Set 3 = Dir("Z:Northwest3")
Set 4 = Dir("Z:Northwest4")
Set 5 = Dir("Z:Northwest5")
Set 6 = Dir("Z:Northwest6")
Set 7 = Dir("Z:Northwest7")
Set 8 = Dir("Z:Northwest8")
Set 9 = Dir("Z:Northwest9")
Set 10 = Dir("Z:Northwest10")

I am not an expert on Case Select, but was thinking:

Select Case myStores
Case Is = 1.......................

View 9 Replies View Related

Backup At 2 Locations

Dec 15, 2012

The code below works. Now I need that while it does the backup file in the same location, we also took into C: Backup_Contabilidade. Finally also put the date and time.

VB:
Private Sub Workbook_BeforeClose(Cancel As Boolean) With Application
.CommandBars("Cell").Reset
End With

Application.DisplayAlerts = False

[Code] .....

View 3 Replies View Related

Counting In Different Locations

Dec 14, 2011

i am counting hotels in different area of 1 city

city area hotel_name hotel_name hotel_name
NY st-1 A001 B001 C001
NY st-2 B001 C001 D001
NY st-3 D001 E001 A001

count by checking NY and see how many branches A001 is having in all these areas. (i should get answer 2)

View 6 Replies View Related

Backup Spreadsheet In Several Locations?

May 13, 2014

I have a spreadsheet on a server, password protected, and certain columns, rows locked...

This is shared with 6 others and can only be accessed one at a time.

If It so that when the user saves the spreadsheet it saves over itself on the server it's located AND on the individual users computer as backup; how would I go about doing this!?

View 3 Replies View Related

Resetting Shape Locations

Apr 12, 2012

I have many spreadsheets that use shapes such as arrows and other symbols. The process for these spreadsheets is to move the shape (arrow for Ex) to indicate a specific location of pain or something like that.

Once the arrow is in position, the spreadsheet is printed to PDF and and a snapshot (in adobe) is "taken" and the picture (with the arrow) is pasted into our application.

My questions is how can I move the shapes back into position when you want to do it all over again.

When I have a few shapes I use

PHP Code:

Set sShape = ActiveSheet.Shapes("Right Arrow 6") 2
    With sShape
       .Top = 220
       .Left = 91
       .Rotation = 20
   End With 

For each shape

But if I have lots of shapes, 50+, it's a bit more cumbersome.

Can I loop through the shapes when I enable the macros to pick up the current positions and use that information when I do a reset (loop back again to move any shape that were touched back to where it was when the spreadsheet was opened?

Currently I have them close the spreadsheet without saving and just reopen.

View 3 Replies View Related

Determine Net Displacement Between GPS Locations

Oct 20, 2012

I'm trying to determine the net displacement between GPS locations and am wondering how I can easily code this in Excel. As far as I know, you need to calculate the distance between Point B to Point A, Point C to Point A, Point D to Point A, and so on. The following is the formula that I would use:

A
B
C

X_Coordinate
Y_Coordinate

123456
3700000
Point A

123460
3700010
Point B

Using the following formula (or setup), this is how I would calculate net displacement:

(123460-123456)^2+(3700010-3700000)^2 = (16)^2 + (10)^2 = 256 + 100 = 356

I assume if I want net squared displacement, I would square root this value SQRT(356) = 18.867

If my formula is correct above, I wonder why Excel gives me an answer for the following net displacement formula (same as above just using Excel formula): (A3-A2)^2 + (B3-B2)^2 = 116

Using this same formula, I could incorporate SQRT in as follows: =sqrt(((A3-A2)^2) + ((B3-B2)^2)), which results in 10.77. This value is clearly different than the value above (18.867) thus I wonder if I'm just mis-calculating something in Excel.

View 4 Replies View Related

Preset Tab Locations In Workbook

Sep 10, 2007

i have a User form that i'd like to add preset tabs command locations to.

For example,

on open i'd like the active cell to be on cell M3. and as the user presses the tab button jump to the following cells locations:

P3
Q5
P7
Q7
P9

View 9 Replies View Related

Moving File Locations

Mar 5, 2010

I have to select about 200 odd files from a folder, and move them to a different folder. The problem is, I have to manually select the 200 files from a list of approx 10,000 (not in order).

I have a list of the filenames (with extension) in an Excel Spreadsheet, and I'm wondering if there's a way to automatically move the files using an Excel macro or something?

example:

File location = C:EBDumped
and I need to move the 200 files to C:EBSent

So I would need to move ONLY the files where the file name is in the Excel list.
The file type (extension) is always the same, but the name (and length of the name) is different.

Is this possible using Windows XP with Excel XP?

View 9 Replies View Related

Average Formula For Multiple Locations?

Mar 30, 2014

HTML Code: 

=100*($I2/AVERAGE(IF($B2=$B$2:$B$38129,$I$2:$I$38129)))

I have the above array formula which I wanted it to calculate the average of all products selling in each store, but it seems to be calculated each?

In column b I have the store number, column I is the sales, I want to average all the sales in column I for each store.

I have probably over complicated?

View 3 Replies View Related







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