I need to copy a chart with a large number of formulas from one workbook and paste it into another. I want the formulas to pull from the NEW workbook, but the references are for the original workbook. I know it is possible to do this, but I'm not sure how. I'd appreciate any help!
Hi All,
I keep on opening a workbook which always asks for an update to an external reference. How can you delete the links to another workbook. I`ve gone through the help and as usual it doesn`t give any answers.
Please help as its getting on my nerves.
Thanks
James
i'm trying to find out the profit of some merchandise and it uses columns to find the 3rd column (profit). example:
10.20 10.50 1.25
10.20 10.51 1.26
10.20 10.56 1.35
10.22 10.50 1.23
10.22 10.55 1.28
10.22 10.57 1.31
first column is cost of operation, 2nd column is sell price, 3rd is profit. i need to be able to input this info below and outputs the profit:
10.22 10.55
3rd column would be a function to result in 1.28
vlookup does only 1 column. i need 2 columns.
thanks all! you've been a great help!
if I have the following
A1 = Table; B1 = Blue; C = 3
A2 = Table; B2 = Red; C= 5
A3 = Chair; B3 = Blue; C = 2
A4 = Chair; B4 = Red; C = 1
A5 = Bed; B5 = Blue; C = 6
A6 = Bed ; B6 = Red; C = 2
where column A = Itme; column B = colour; column C = quantity
(sorry about the agricultural way of showing my values...for some reason I still can't get my htmlmaker thingie to work )
If I want to find out how many red tables there are, how do I use vlookup (or similar command) to look up a match in column A and column B.
I think I have done this before I cannot, for the life of me, remember how to do it.
I would like to change the referencing in cells based on a date inputed once. The current code is:
Code:
'C:\Users\Garreth\Documents\Cell Feedback Forms\Other\[Cell Feedback Form - Durward S - 07 August 2007.xls]Feedback Form'!$D$12:$G$12
, and I want the filename to draw reference to a cell with a date in it, to possibly look something like this:
Code:
'C:\Users\Garreth\Documents\Cell Feedback Forms\Other\[Cell Feedback Form - Durward S - C7.xls]Feedback Form'!$D$12:$G$12
, but can't get the filename to draw reference to the cell where the date is. Please help.
Does anyone know if its possible to programmatically control the references one workbook has with other workbooks?
What I mean is this: In the VBA design environment you can click:
Tools > References
Then the pop-up window lets you select a from the list or browse.
I'm writing a spreadsheet app where the non-technical client may occasionally need to change the references over the lifetime of the spreadsheet (in years).
I'd prefer to let them do this through a friendly interface, such as a simple form which I can set up, instead of getting them to go into the VBA IDE.
Constructive help greatly appreciated.
Is there anyway to reference to a cell in the current workbook using the HYPERLINK function.
I would like to be able to create a dynamic link e.g.
=HYPERLINK(INDIRECT("L"&SUM(1+Variable)),"Dynamic Link")
Cheers...
I need a formula that will lookup two references and return a summation from a third column. I am getting stumped trying to figure out how to write it, but if it was just written, it would look like this.
(As written in cell B3 of Sheet 1)Lookup cell A3 AND cell B2 on Sheet 2, if you find both on the same row, return the summation of column B for all matches into cell B3. If you cannot find matches to both, "null". --Then the same formula would be written for every cell across and down on this sheet.
I have this working successfully in other worksheets so I'm stumped.
'=IF(ISNA(VLOOKUP($O$2&$G10,Dispatch,H$4,FALSE)),"",VLOOKUP($O$2&$G10,Dispatch,H$4,FALSE))'
Taking the & out and using just the one reference I'm good, but using both references I'm getting NA#??????????
What's wrong?
Thanks, Mike
hey,
im not an experienced excel user, but im working on following problem.
Imagine a huge data sheet, where the first column is used for the client number, the second for the month of the year, and all the other columns for a lot of data like total invoices, reassignments etc...i want to create a formula thats looks up for example total invoices of a particular month for a particular client. i already googled and looked in forums, but couldnt find the right formula so far. DGET is not very helpful, i aws wondering if somebody could give me an answer based on index(sumproduct) basis...but im not sure if that is the right approach.
would be very pleased to get an answer
andre
