Excel 2010 :: Hyperlink - URL Has Two Values In Which To Input Data

Feb 24, 2012

I wish to use a formula to grab data out of cells A1 & B1 and use that data to complete a hyperlink URL in cell A3. The base URL never changes but the last two variables do. For instance:

URL Format: http://www.test.com/XXXX&page=XXX

Example data:
Cell A1 = 1234 (always 4 digits)
Cell A2 = 567 (always 3 digits)

Desired Final Result, hyperlink: [URL] .........

I cannot seem to figure it out.... my formula i have gives errors:

=HYPERLINK("http://www.test.com/"(A1)"&page="(A2), "Linked")

This is Excel 2010

View 2 Replies


Excel 2010 :: Copy Hyperlink To Other Cell?

Nov 21, 2013

how can I copy and paste only the hyperlink of one cell to the other cell with the same worksheet or workbook? I am using Excel 2010.

View 9 Replies View Related

Excel 2010 :: Hyperlink With IF Statement - Cannot Open Specified File

Aug 30, 2012

I Have a CheckBox Thats Linked with CA22

In Cell CB22 I have the Following Formula:


In Cell CC22 I Have...

=IF(CB22="1","RM-4E ADD1",HYPERLINK('RM-4E (Add - 1) (2)'!A1,"RM-4E ADD1"))

The Sheet namne its supposed to Hyperlink to is called

RM-4E (Add - 1) (2)

When the Check Box is Unchecked it Changes CA22 to False and Puts in CC22 Text: RM-4E ADD1

When the Check Box is Checked it CHanges CA22 to TRUE and is supposed to create a Hyperlink to that sheet...Only when i click it it comes back with

'Cannot open the specified file."

I even went as far as typing out the Word Hyperlink( clicked the sheet and selected Cell A1 on that sheet but it still comes back with the error!

Excel 2010

View 9 Replies View Related

Excel 2010 :: Loop Through Row Of Data Testing Values

Dec 25, 2011

I am running excel 2010. I have set up a variable " testvalue" type variant

I would like the prog to step through a row of data which can contain text or numbers. If any number is greater than 3,000,000 I want exit the do. However, if no number is greater than 3,000,000 I want to record this as a "bad file". I have the follow code which trips at the first "case".

testcol = 1
testrow = myTextRows - 1 'penultimate row
Do While Len(wbText.Sheets(1).Cells(testrow, testcol)) > 0
testvalue = wbText.Sheets(1).Cells(testrow, testcol).Value
Select Case testvalue

[Code] ........

View 3 Replies View Related

Excel 2010 :: Paste URL As Hyperlink Or Format Existing URLs

May 16, 2013

Using excel 2010 on PC.

Paste URL as Hyperlink: I just want to paste a bunch of urls into a spreadsheet and have them automatically formatted as urls. i've checked my auto-correct options, and i have selected the checkbox that says: replace as you type/internet and network paths with hyperlinks.

See attached. if you copy and paste a url into the spreadsheet, it will be formatted as text.

Format Existing URLs as Hyperlinks : the attached spreadsheet contains urls that have been copy & pasted. is there a way to format them as hyperlinks all at once?

View 1 Replies View Related

Excel 2010 :: Pulling Cell Values Into URL When Using Get External Data From Web?

Feb 20, 2014

I am using Excel 2010. I am trying to make a spreadsheet where I can type in a date (02-19-2014), and pull in box scores from a basketball website. I have everything set up so that the date is parsed into (3) cells (02 19 and 2014) so that it can easily fit into the URL:


As you can see, the month value in the URL is "02" the day value is "19" and the year value is "2014". What I want to be able to do is type in any date I want and return the box scores from that day in a new tab. I have everything done so that the new tab is automatically created and named, so my only issue is that I can't figure out how to input the day, month and year values automatically into the code for the Get External Data pull:

'Import from www.basketball-reference.com
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.basketball-reference.com/friv/dailyleaders.cgi?month=02&day=19&year=2014" _
, Destination:=Range("$A$1"))
.Name = "dailyleaders.cgi?month=02&day=19&year=2014"

View 2 Replies View Related

Excel 2010 :: VBA Input Box For Range Selection

Sep 6, 2012

Excel 2010. I have a macro, stored in a workbook.

The macro is: collecting data from another opened workbook,processing the data,saving the processed data in yet another workbook.

The workbooks' names it is operating on are hardcoded in the macro. I'm trying to make it more flexible, that is to allow user to specify both source and target workbooks along with the data columns.

The workflow follows:

User opens both source and target workbooks,User opens the workbook with the macro,User runs the macro (with a button for example),Macro prompts the user to select range in the source workbook,Macro "memorizes" the range and the source workbook's name from user's selection,Macro prompts the user to select range in the target workbook,Macro "memorizes" the range and the target workbook's name from user's selection,Macro processes the data.

I found out that this can be achieved with Application.InputBox("Select cell(s)", Type:=8) method. However there are some issues that I was not able to solve playing with the returned value's methods:

The .InputBox defaults to active workbook. I was able to select another opened workbook only with Ctrl+Tab combination, but it will not work with the end users - they are too poor with these tricks. Is there a better, more intuitive way to allow user selecting a workbook?I was not able to get the workbook's name from the .InputBox returned value property. I was trying with .application.caption and .application.activeworkbook.name - none of these worked. They returned name of the workbook with macro, not the one with selected range. How to get the workbook's name from given cells range?

View 2 Replies View Related

Excel 2010 :: Data Validation Won't Accept Start And End Date From Cell Values?

Mar 16, 2014

Data validation in an Excel 2010 workbook.

I want the date input to be restricted a start date and an End date specified in two cells on the sheet. However, when I set up the Data Validation, ANY date will be accepted.

As an example cell Z1 contains the date 1/3/2014 and Cell Z2 contains the date 31/3/2014, so in the Data Validation box, the Start Date is referenced to Z1 and the End Date is referenced to cell Z2.

But I can enter 1/9/2020 and the Data Validation happily accepts that date.

View 12 Replies View Related

Excel 2010 :: Pulling Data Based On Multiple Criteria With Duplicate Values

Mar 14, 2012

I have a sheet (see Sheet 1) from a report we run which lists the following information: Personnel Number, Amount, Wage Type. This is generated for 1000's of employees, with each personnel number being repeated several times in column A.

I am trying to pull specific data to another sheet (see Sheet 2), which would ideally generate the sum of "Amount' for a specific wage type for each personnel number. The issue is is that there may be dplicates of the wage type for each ID number (which is also repeated).

For example, the total salary amount on sheet 2 for ID#12345678 would be 0, while for #9876543 it would be 1250. Is there a formula I could use on sheet 2 column B that would generate this?

Excel 2010 ABC1Personnel NumberAmountWage Type212345678550Payment312345678400Overtime412345678300Overtime512345678250

Excel 2010 ABC1Personnel NumberTotal SalaryTotal Overtime212345678398765432

View 3 Replies View Related

Excel 2010 :: Formula Based On YES / No Input In Another Cell

Apr 30, 2014

Two formulas which I need in Cells E74 and E75.

Basically the formulas will depend whether the entry in D73 are Yes or No

in cell E74, IF D73 = ‘No’ then E74 = D74 + E70 ELSE IF ‘D73’ = ‘Yes’ then E74 = E70

in cell E75, IF D73 = ‘No’ then E74 = D74 + E70 ELSE IF D73 = ‘Yes’ then E74 = E70

Excel version 2010

View 4 Replies View Related

Excel 2010 :: Use Input Box To Enter Email Address?

Nov 3, 2011

I have a macro that will email a link of the worksheet.

the problem is I may have different email addresses to send it to. I want to be able to have an input box come up, and the person to enter in an email address, click ok and have the macro continue to email.

Sub Make_Outlook_Mail_With_File_Link()
'Working in Office 2000-2010
Dim OutApp As Object
Dim OutMail As Object
Dim StrBody As String
If ActiveWorkbook.Path "" Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)


View 2 Replies View Related

Excel 2010 :: Conditional Formatting - Highlight Values Based On 2 Columns Of Numerical Data

Apr 12, 2013

I'm having issues with Excel's 2010 conditional formatting. Seems easy to use, but I'm trying to highlight values based on 2 columns of numerical data. Example:

Column F:

Column L:

I would like Column L to highlight values that are greater than Column F in green. If they are less than Column L then highlight them in red.

Seems I was able to do this with Excel 2003, but I don't understand the 2010 version.

View 3 Replies View Related

Excel 2010 :: Macro Design For Serial Number Input

Dec 8, 2011

Excel 2010 O/S XP Macro for serial number input all serial numbers have JTC0. Any VBA code to place in macro to have a cursor appear after the four characters in the macro below?

Example: JTC0| < cursor ready for input

Sub Macro2()
' Macro2 Macro
' Keyboard Shortcut: Ctrl+s
ActiveCell.Offset(1, 0).Select
ActiveCell.FormulaR1C1 = "JTC0"
End Sub

View 4 Replies View Related

Excel 2010 :: Convert Multiple Columns To Rows Depending On Input Value

Jul 6, 2014

I have lot of data in Excel 2010 which I wish to bring in Columns using a Macro depending on the input value which the macro should prompt me. For E.g.:


If I select data from A1 and J1 (in practical it will be more Columns) the Macro should prompt me how many Columns would be the output on Master Sheet. If the input is 2 then it should create an output Sheet "Master" and should show the following result

.. ..
.. ..

It after selection I run the macro and input 3 then the output should go in three columns (A1,B1,C1) one below other. If 4 is Input then 4 Columns (A1,B1,C1,D1) will come below each other so on and so forth.

View 6 Replies View Related

Excel 2010 :: Input Multiple Cells Based On Master Cell?

Dec 9, 2011

I am trying to create a UserForm in Excel 2010 that will look for a part from our database (or on a specific Sheet, possibly a hidden sheet), then add specific data from that part's row into a new line.

More Specifically:

| Part # | Description | Category | SubCategory | Cost | Labor Hours | Weight | Etc |

I want to be able to input the Part #, and have it automatically add specified information to sheets 1 and 2 and those two differ. 1 is our Quote Sheet, and 2 is our bill of materials.

Also, I need each piece of information to go to a specific column (ex. Cost always goes to Column K)

What I have now is a broken UserForm that references a DOC file with a Table, but I need something a good but more complex.

Ideally, what I want is to have 4 ListBoxes where you choose Category --> SubCategory --> Make --> Model then have several CheckBoxes below that would determine whether to add a part (Cost, Labor, Weight).

The reason for this is because we have no need for the Cost or Labor Hours in our Bill of Materials, but need that information for our Quotes. And we generally don't need Specific Dimensions in our Quotes, but DO need them in the Bill of Materials...

Can I make it so that it will insert Pre-Specified information into both sheets at the same time?

View 1 Replies View Related

Excel 2010 :: Create Checkbox That When Ticked Shows Additional Area To Input Information?

Jan 10, 2014

I'm creating a basic form or templateusing Excel 2010 where the user will fill out information (See attached screenshot) I'd like to incorporate two a check boxes, that when ticked, change the display of the second table, either adding, removing or splitting of of the current columns in to two?

Is this, or any variation of, possible using Excel 2010.

View 2 Replies View Related

Excel 2010 :: Produce Unique List Of Key Values With Second Values Concatenated Together

Sep 15, 2013

I have some data with recurring key values and differing values in the second column, I need to produce a unique list of key values with the second values concatenated together.(See below)

The data can be 10 rows to 5000 and I can have anything from 5 to 150 sheets (Separate data sets), a macro would go a long way to keeping me sane.

Sample data Required Output
A | B Z
1| 10 | a 10,a,b,c
2| 10 | b 11,a
3| 10 | c 12,a,b
4| 11 | a
5| 12 | a
6| 12 | b

My system is Windows 8 Excel 2010.

View 7 Replies View Related

Comparing Input Value From Set Of Values 1 And Output Data From Set Of Values 2

Sep 28, 2012

Got a road block on one of the trackers which I am trying to create which compares some of our agreements. Basically we need to compare current production with our contracts and then bring the tier level they are at in order to then calculate how much in overrides we receive. Belwo is an example:

Input Value = 140000
Out Should be = 1.5%

Set of Values 1


In a nut shell it will look for 14000 in set of values 1 and pick T3 to then go in set of values 2 and display corresponding T3 which will be 1.5% in above example as output.

View 2 Replies View Related

Excel 2007 :: Userforms - Input Cell Value (via Text Box) And Output Corresponding Values From Resulting Row

Jun 24, 2013

I have a simple spreadsheet of an inventory. Each row on this spreadsheet represents the data related to an item. I would like for a user to be able to INPUT a serial number via a userform. Then, I would like for the program to OUTPUT some information about that particular item (a few cells that should be on the same row as the serial number).

I attached an image diagram that may better represent what I am trying to do.

View 9 Replies View Related

Excel 2007 :: Data Validation To Hyperlink Won't Follow Link

Aug 22, 2013

I have a worksheet with several data validation dropdowns that each link to a series of hyperlinks. When you click the dropdown and select the hyperlink, it opens up that particular file. All of these work, except for one of the dropdowns. Even though I can see and select the names, the link is NOT activated.

Is there some obscure excel feature that I am not aware of that is preventing this one from working? Why would this be?

Excel 2007.

View 1 Replies View Related

Excel Data Using Cells Input To Filter Data And Producing Database Style Reports

Aug 6, 2013

Trying to use Excel Data List to create a database style report. IE. Originally blank sheet, which is only populated by data containing data matching "filters" input into cells ( say A1 & A2 )

I.e. A1 = Delivery week to be filtered by, and B1 Manufacturer Name

So if I type week "1" into A1 & Manufacturer "Microsoft" into A2, it will show a table only containing data Microsoft, Week 1, and associated data for those lines across the screen.

Week 1

PO number : Date Ordered: Address 1, 2 3 etc....

0011 01/01/13 Somewhere
0015 02/01/13 Anywhere
0213 05/01/13 Nowhere

I know this is much easier with a database, however my manager insists a database cannot be used, and it must be in a spreadsheet format !

View 3 Replies View Related

Excel 2010 :: Highlight Same Values In Different Worksheets

Jul 26, 2013

I have "Worksheet1" with Columns A and B for IP Addresses, then Column C is for a device name.

I have "Worksheet2" with a range of IP Address from F5:I260

When I enter a new device and assign it the IP addresses on "Worksheet1", I would like the IP Address to highlight in "Worksheet2"

This way I can keep track of which IP address I have used. Excel 2010

View 7 Replies View Related

Excel 2010 :: Sum Values Between Two Dates In Tables

Jan 27, 2014

Jan-14 Feb-14 Mar-14
Salary 10,000 20,000 30,000

Salary 30,000

I have a table above (in red), as an example, my actual table goes out 60 months.

Where the Green Value is, I need a formula that will reference the two months above it (They could be any of the 60 months), that will then sum the salary from the table between the selected two months (including these months)

I have tried,

tblCluster[[#Headers],[Jan-14]:[Dec-18]],">="&'Cluster Analysis'!$I$51,

View 2 Replies View Related

Excel 2010 :: Replace Values In A Cell

Apr 24, 2014

In Excel 2010 I am attempting to replace values in a cell, the right two values with "00", but am having difficulties with the correct '=replace' function.

View 2 Replies View Related

Excel 2010 :: Looking Up One Value And Need To Return Multiple Values Horizontally

Mar 28, 2014

I have in column A duplicate values and in column B different responses (Sheet: Lookup). I need to look up the value in column A (Sheet: Results) and bring back all the responses in column B (horizontally).

Nittie Query.xlsx

View 5 Replies View Related

Excel 2010 :: Countif And VLookup Of Multiple Values

Jan 15, 2014

I am working with an Excel 2010 workbook that has two worksheets in it. What I am trying to accomplish is I want the second worksheet to scan the first worksheet for a student's name, and count all of the instances that the student has a score less than a certain threshold (we'll say "5" for this example). I have tried using various combinations of vlookup and countif functions, but have not had much success. I did get it to a point where it worked, but only for the first instance of that student's name; it wouldn't continue searching the first worksheet for any other instances.

I have attached a sample workbook as a reference : Sheet1.xlsx‎

View 8 Replies View Related

Excel 2010 :: Plotting Values V1 / V2 / V3 And V4 According To Given Date And Condition

Mar 25, 2014

Excel Version : MS Excel 2010
Attachment filename : <Forum to plot the values.xls>

My requirement is i want to plot the values V1, V2, V3 and V4 from the given condition (A1 / A2 / A3 / A4) and the given date.

If the given date is not available then the formula should take the older date than it not next date. For example if the given date is 10-Mar-14 and the date is not available for the given condition then it should take the older / earlier dates like 09-Mar-14 or 08-Mar-14 like and it should not take 11-Mar-14, 12-Mar-14.

The values should be plotted in the yellow cells.

View 1 Replies View Related

Excel 2010 :: Showing Multiple Values Per Cell?

Jul 31, 2014

When I update a cell (change A1 from 2 to 3), any cell that references that cell correctly changes its value (B1 = 2*A1). However, the screen will show the new value in B1 (6) over the previous value (4). At first I thought it almost looked like a strike-through, but then I realized the old value and new value were simply stacked in B1.

If I scroll the screen away that cell and go back to it, the correct value will now show without the stacked values. I'm not having this issue in any other program (Open Office), and I don't seem to be having any kind of stacking issue in any other Microsoft program.

View 5 Replies View Related

Excel 2010 :: Pasting Space Separated Values?

May 9, 2013

I have some text out of note pad in the following format

"cat" "dog" "bird" "turtle"
"cat" "dog" "bird" "turtle"

There is several lines like this. I need to copy it out of notepad and paste it into excel where every word in quotes is in its own cell. Right now if I paste it everything goes into cell A1.

I am using excel 2010..

View 4 Replies View Related

Excel 2010 :: Crashing When Pasting Formulas As Values

Nov 8, 2013

I recently received an .xls book which I then saved as .xlsx (I'm using 2010). There are just under 8,000 rows and 20 columns. File Size 1MB.

The only formulas in the sheet are the ones in a column which I inserted and copied down for all 8,000 rows. Nothing too complicated: no arrays or anything. The sheet calculates fine.

I am simply trying to copy and paste these formulas as values (into the same cells), though at every attempt Excel crashes. I tried on smaller sets of the column and just got it to work for a few hundred rows, though it struggles with any more than that.

I opened a different workbook of mine, and tried the same operation on twice as many cells containing complicated, lengthy array formulas and the action completed instantly.

There is no Conditional Formatting in the book, no code, no 'last cell' issue, no Named Ranges, no external links.

I have even copied the data to a new workbook, then copied the text of just one of the formulas over into this book, added an equals sign, copied down and recalculated, then tried to paste as values again. Still crashes.


=IF(AND(N3>1,ROWS($1:1)<>MATCH(M3,$M$3:$M$7979,0)),"Exact Duplicate","")

is far more resource-hungry than I thought, though if that were the case, wouldn't the issue be during calculation (which, as I said, is fine) and not during a paste attempt? No, it can't be this.

View 1 Replies View Related

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