A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Links and Linking in Excel Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Linking a table in Excel 2013 to data from another spreadsheet by ruthhicks999
I am trying to redesign some reports along the lines as to what I had at a previous workplace. Can anyone help me work out how it was done. The reports...
July 20th 15 02:22 PM
by ruthhicks999 Go to last post
0 11,537
pass parameter to access query by Bill Manville
Jamie Collins wrote: > You can most definitely *execute* a Jet (MS Access) stored procedure > (stored Query) using MS Query in Excel without VBA...
May 5th 15 06:17 PM
by nuochoa080415 Go to last post
3 4,729
Angry
Linking formatted cells by ShelbyX
I'm trying to figure out how to link contents from 2 sheets in a workbook. I've created a Q&A(#1) on one sheet, with the reply options and scoring defined on...
August 28th 14 10:48 PM
by ShelbyX Go to last post
0 5,024
How to do oracle function in excel sheet ? by kathytiya
Please Help me i am doing oracle dba training in chennai i want to do oracle function in excel sheet it is possible ? www.anoracledbatraining.com
July 4th 14 12:13 PM
by kathytiya Go to last post
1 3,471
Help with referencing from a list of numbers on another sheet please! by SammyBoy85
Hi Folks, I have a problem which I am sure there is a simple soultion for but I can't for the life of me work it out. I have a workbook (Workbook 1) which...
May 7th 14 09:49 AM
by SammyBoy85 Go to last post
0 3,008
Lightbulb
Facilitation between Excel & Outlook by Alex Donnelly
I need to find a way to facilitate information between a spreadsheet in excel and information in Outlook Diary. My aim is to centralise information between...
March 3rd 14 04:19 PM
by Alex Donnelly Go to last post
1 3,313
Exclamation
How could I grab data from the script protected site? by iqbal88
Hello, I can't import data table from the site which contain stock data. I did in MS Excel 2007; Data > Get External Data > From Web > Import as usual but...
December 29th 13 09:44 PM
by iqbal88 Go to last post
0 2,985
Workbook Naming by Ed McCormck
Using the following formula to indirectly access a worksheet from another one. =VLOOKUP("US Navy",INDIRECT("'"&A32&"'!$H$7:$V$209"),15,FALSE) Cell A32 is eon:...
December 20th 13 04:26 AM
by Ed McCormck Go to last post
0 2,840
"Reliable" Hyperlinks by AndrewWoodard
Hello, Everyone! I'm an old guy but new to this forum, so please excuse me if I "clunk" in this process. Thanks in advance for your patience. I'm not a...
November 2nd 13 03:18 AM
by AndrewWoodard Go to last post
0 3,280
Hyperlink Prompts Error Message by B30K
Hi, I'm trying to create hyperlink using Excel 2007 but keep getting error message "This operation has been cancelled due to restriction in effect on this...
October 20th 13 03:26 PM
by B30K Go to last post
0 2,928
1 Attachment(s) Simple Macros Table Count Link by arceaf
Hi, I'm having some problems with a Developer table an need help. I've created a drop down menu from a list (attached). The only this is, once I select the...
June 29th 13 04:10 AM
by arceaf Go to last post
0 8,545
Sorting data exported from Crystal Report by JoshBrunz
I have a crystal report that list customers from different locations. The format is simple. 1 row will have the name of an office. lets say 'office 1'. then it...
June 21st 13 07:50 PM
by JoshBrunz Go to last post
0 3,157
how can i insert security to my excel files by rickbrode099
i want to put pass word security code to my excel file how can i do
May 9th 13 10:38 AM
by rickbrode099 Go to last post
0 3,446
Inserted linked Excel tables in word resizing/losing formatting by Look13
Hi - Apologies if this question is answered elsewhere but I can't find a solution. I have a word (2010) document that has multiple tables inserted as linked...
May 6th 13 08:29 PM
by Look13 Go to last post
0 3,938
Cycle counts from linked sheets: everchanging quantities by tubbycricket
Hey everyone, this is my first time here, I just had a question in my mind and wanted to know if such a thing was possible or nonsensical: The industry I work...
May 3rd 13 12:10 PM
by Aries86 Go to last post
1 4,425
Consider a password manager for internet security by Saige
If you've never used a password manager as part of your online safety regimen, you've been playing with fire. Don't get burned, because password hacking is...
April 24th 13 11:47 AM
by Saige Go to last post
0 3,030
Charge cards factor the most into credit ratings by Saige
The CFPB has released a new study about credit history. It found, among other things, that credit card activity is the solitary most essential factor analyzed...
April 24th 13 11:46 AM
by Saige Go to last post
0 2,948
Links between two workbooks by baleshst
Hi, Can anyone guide me to understand, which is the best way of linking workbooks. I have a master budget which pulls data from several other...
March 9th 13 06:10 AM
by baleshst Go to last post
0 3,555
Exclamation
Linking data between sheets with limits on quantity by owj1993
Hello The Scenario: the company I work for have four main customers who near the end of every month will e-mail a list of the stock they want, the maximum...
March 8th 13 11:39 AM
by owj1993 Go to last post
0 3,200
1 Attachment(s) Linking Background Cell Color by TreeHugger1
I received some VBA code that will give a value to all the standard background colors for a cell. I then linked this formula to provide a number next to each...
February 9th 13 01:50 AM
by TreeHugger1 Go to last post
0 3,459
Post New Thread


Display Options
Showing threads 1 to 20 of 984
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.