LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Allow no action to be taken

I have a worksheet that I want to try and eliminate manual activity. To
simplify the question, assume I have three cells A1,B1 and C1. If the value
in C1 is X then I want to place the value of B1 in A1. If the value in C1 is
not X I want to leave the value in A1 alone.

I am trying to create a worksheet with YTD values and I want to place the
appropriate values in the appropriate month's columns. I don't want to
change the other values for other month's that have already been colleceted
and stored. It looks like I have a loop if I am trying to "pull" information
in A1. I can't figure out how to "push" information from another cell into
A1 without being in A1. Hope this makes sense.
 
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
Repeating Last Action Haseeb Excel Discussion (Misc queries) 2 November 15th 06 11:35 PM
Repeat last action Teri Excel Worksheet Functions 5 July 13th 06 04:11 PM
Can a formula contain an action? Peggy Excel Discussion (Misc queries) 7 February 21st 06 05:37 AM
on particular action run a macro Jelinek Excel Discussion (Misc queries) 1 February 3rd 06 01:21 PM
what is OLE.action Flute Excel Discussion (Misc queries) 1 December 2nd 04 09:04 PM


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