Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
marybatt
 
Posts: n/a
Default Absolute cell formatting

I have a workbook that is set up that when I enter a specific value ex:e18 in
one cell it will give me the coresponding number ie:800-252-6030 in a
different cell. I need to add additonal numbers and "shortcuts" to the
workbook. HOW? Please be very specific and step by step

  #2   Report Post  
Posted to microsoft.public.excel.newusers
bpeltzer
 
Posts: n/a
Default Absolute cell formatting

Click in one of those 'different cells' that takes on a corresponding value.
Chances are there's a formula in that cell that makes reference to cell e18
(maybe a vlookup?). You probably will be able to copy the formula(s) that
cause the corresponding values to appear from their current location down to
additional rows. If that doesn't get it, please provide some additional
information: what sorts of values are entered, what values appear, where is
the corresponding data coming from and how is it organized?
--Bruce

"marybatt" wrote:

I have a workbook that is set up that when I enter a specific value ex:e18 in
one cell it will give me the coresponding number ie:800-252-6030 in a
different cell. I need to add additonal numbers and "shortcuts" to the
workbook. HOW? Please be very specific and step by step

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfer Cell Formatting for linked cells Scott Excel Discussion (Misc queries) 2 November 23rd 05 11:04 PM
enhanced conditional formatting Stuart Excel Discussion (Misc queries) 13 November 13th 05 07:20 PM
retrieve cell formatting with IF(HLOOKUP) formula useR Excel Worksheet Functions 2 August 3rd 05 06:55 PM
cell formatting problems jazzsax505 New Users to Excel 2 May 29th 05 10:30 PM
Trying to add conditional formatting to every other cell...GOING . trixiebme Excel Worksheet Functions 2 March 24th 05 01:55 PM


All times are GMT +1. The time now is 03:55 AM.

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

About Us

"It's about Microsoft Excel"