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 From raw data sheet to sub sheets by Patrick Johnson
Hello all and thank you for taking the time to answer my questions. Several years ago I was ok with excel and the formula's associated with it, however, now I...
December 20th 12 03:35 PM
by Patrick Johnson Go to last post
0 2,441
Content Linking from MS Word Documents into Excel by Lacks
Hello all, I have a simple question and expect it would have a simple answer though solution may be a tricky. Context: Link contents of two word documents...
December 6th 12 12:45 AM
by Lacks Go to last post
0 2,296
Linking Excel in Word by EKO
I am trying to embed an excel spreadsheet in a Word Document, however I want the Word Document to pull the excel file from the same folder that the Word...
November 28th 12 08:22 PM
by EKO Go to last post
0 1,685
Excel file path editing by Karl Kruger
I need help editing a file path name. I use hyperlinks in my Excel databases and several times when an update from Windows happens, my file paths change and...
November 21st 12 12:51 AM
by Karl Kruger Go to last post
0 1,612
Counting checkbox results in multiple workbooks by ej777
This is my first post on the forum so please forgive me if I am missing any necessary information: I have hundreds of workbooks that all use the same template...
November 7th 12 04:15 PM
by ej777 Go to last post
0 1,703
copy table from multiple spreadsheets and paste them into one by stmnik
hi everyone, i have a series of 800 spreadsheets all having the same table (in terms of position and size). i would like to copy all and paste them into to one...
October 15th 12 09:56 AM
by stmnik Go to last post
0 1,911
2 Attachment(s) Link row of data from one worksheet to another based on column criteria by texas tina
I have excel sheet with 4 worksheets tabs(Master, Won, Lost, No Bid). All data entered on Master. I want each row to automatically link/appear on 2nd, 3rd or...
October 13th 12 11:05 AM
by Spencer101 Go to last post
3 2,137
Exporting columns from Sheet1 to sheet2 by Hemanthkumar
Hi, I need to export some columns from sheet1 to sheet2 with some condition. For Instance., I have DATE, NAME, ID NUMBER, ADDRESS columns in sheet1... I...
August 30th 12 07:06 AM
by Hemanthkumar Go to last post
0 1,867
Linking specific data between 2 sheets with a checkbox by morrima
I've got a basic invoice on sheet1 with 17 rows and each row has a column for quantity, item description, item cost and total cost. Then on sheet2 I have a...
August 27th 12 02:55 PM
by morrima Go to last post
2 1,933
OLAP Refresh Stops working by jccveal
Hi All, Hope you can help. I'm using excel to test that an OLAP cube is doing the right calculations. So creating a pivot table linked to certain dimensions...
August 17th 12 05:16 PM
by jccveal Go to last post
1 1,808
Creating absolute links between workbooks by bones23
I hope someone can help! My issue seems to be that Excel stores relative links between workbooks so when they are moved away from each other the links are...
August 1st 12 08:54 AM
by bones23 Go to last post
1 2,265
Character Link by Rixster
Hello, I'll try to explain this as best I can. I am not the most technical user but I'm trying to learn. What I'm trying to do is figure out if by using the *...
July 23rd 12 06:29 PM
by Rixster Go to last post
3 1,870
Insert Relative Hyperlinks in Exel cells? by Mebendazol
I'm trying to use .xls file as index for 2000+ files There will be a "Collection folder" that contains .xls index file and subfolder "Data" for all files I...
June 18th 12 05:30 PM
by Mebendazol Go to last post
0 2,323
Series syntax by Cheth.shetty
How to change the absolute path to relative path in series formula for excel sheet 2010. I have one path already entered which os not working when the excel...
June 15th 12 05:47 AM
by Cheth.shetty Go to last post
0 2,102
Build formula using field values as text in the formula referencing another workbook by solardirect
I want to build an Excel formula using field values as text in the formula referencing another workbook. From an open workbook, I want to use a formula like...
June 4th 12 10:47 PM
by Mo_H Go to last post
6 5,135
updating problem by joanwork
Hi there, I have an on going problem with updating data from linked excel files. 1. I'm working with excel 2010. 2. The source files are excel 2007. 3. The...
June 4th 12 09:33 PM
by joanwork Go to last post
0 1,792
New Excel Project by Cmarkee
Thanks for the help on the last one, learned a lot about pivot charts. I want to create a form as my first worksheet, that you can select the date and line...
May 31st 12 03:41 PM
by Cmarkee Go to last post
0 1,629
Linking Data in different workbooks and then sorting by renato1
Hi I have column A of workbook B linking to data in workbook A; then column B of workbook B has independent data values. When I sort workbook A the data...
May 22nd 12 05:34 PM
by renato1 Go to last post
0 1,759
Help Linking Rows Between Sheets While Sorting by JonD
Hello All, I am fairly experienced with Excel, but unfamiliar with Macros. I am working on a database for student assessment in which the first sheet lists...
May 19th 12 03:15 AM
by JonD Go to last post
0 1,904
Creating a dynamic dropdown from closed workbook by selseyr
Hi I am trying to create a dynamic dropdown that refers to a closed workbook. I found a great thread on this website that referred back to...
May 3rd 12 02:40 PM
by selseyr Go to last post
0 2,320
Post New Thread

Display Options
Showing threads 21 to 40 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 09:19 PM.

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