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 » Links and Linking in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Linking formatted cells

Thread Tools Display Modes
Old August 28th 14, 10:48 PM
ShelbyX ShelbyX is offline
Junior Member
First recorded activity by ExcelBanter: Aug 2014
Posts: 1
Angry Linking formatted cells

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 another. The Q&A sheet is locked and the reply sheet is hidden so the only choice the user has is to simply select from the drop down the best answer to the question. The answer then calculates a value which is tallied at the end for a score. I have a second Q&A(#2) setup with another sheet, which is where the problems lie. Unfortunately there are 3 duplicate questions, so I've been trying to find a way that when the questions are answered on #1 they will auto-populate on #2, which I think I was able to do, but I couldn't keep the source formatting so the values came out skewed and I kept getting errors. Hopefully this makes sense, because I'm on a stupid deadline to get this done, and I am having NO luck. Hopefully someone can help with this! If I'm not clear enough please let me know. Thanks in advance for ANY assistance I can get!

Thread Tools
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
formatted cells medina Excel Worksheet Functions 0 April 16th 10 04:29 PM
linking a text formatted cell to a formula cell lacy Excel Discussion (Misc queries) 1 May 22nd 09 03:19 PM
Linking to a pivot table from a formatted invoice Spaceman Spiff Links and Linking in Excel 1 January 1st 06 10:02 PM
Too many formatted cells XROCKYISBACKX Excel Discussion (Misc queries) 1 December 4th 05 05:44 PM
Converting 'General' formatted cells to Text formatted cell using. Zahid Khan Excel Worksheet Functions 1 March 12th 05 07:13 PM

All times are GMT +1. The time now is 03:30 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.