Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to make one column update another column in Exell

I want a macro or something to make a value in C column place another value
in K column ie: C= 3 and then K would = 5.5 on the same row
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default How to make one column update another column in Exell

You posted under Excel 'Functions'... You may not need a macro... See this
site:
http://www.contextures.com/xlFunctions02.html

Regards,
Ryan---

--
RyGuy


"Canron newbie" wrote:

I want a macro or something to make a value in C column place another value
in K column ie: C= 3 and then K would = 5.5 on the same row

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 50
Default How to make one column update another column in Exell

That could be pretty easy depending on exactly what you want.
Let's say that column K is there to add a fixed number to whatever is in
Column C.
Cell K1 would have this formula in it:
=C1+2.5 or =SUM(C1,2.5)
As soon as you entered a number in cell C1, Cell K1 would add 2.5 to the
number and display the result, in this case 5.5.
You could then copy K1 as far down as you would like.

"Canron newbie" wrote:

I want a macro or something to make a value in C column place another value
in K column ie: C= 3 and then K would = 5.5 on the same row

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
When I make a row absolute, but column relative, the column stays. tonefbr Excel Discussion (Misc queries) 3 October 9th 07 11:17 PM
how do I update a column and create new rows for new column cells Pete Excel Discussion (Misc queries) 1 June 6th 07 02:02 AM
how to make one column copy from one sheet to anoth column w/o zer areezm Excel Discussion (Misc queries) 3 June 6th 06 10:45 PM
How do I update Column #1 based on specific value of column #2? SLH Excel Worksheet Functions 2 September 20th 05 02:16 PM
Excel, when column A and B have same name make column C add up in mail merge Dani B via OfficeKB.com Excel Discussion (Misc queries) 6 July 22nd 05 07:43 PM


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