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: 465
Default Copy from one named cell to another dependent on content of a third.


HI

I have a small puzzle.

In Column H I have a row of numbers. All ones and threes , with some
blanks.

If the number in H1 is a 1 , then the content of B1 should be copied
into K1.

This would apply to all cells in H which contain a 1. All other numbers
would be ignored.

Can this be done?

Grateful for any assistance.
 
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
How do I copy a row depending on the content of a cell in the row Robert59 Excel Worksheet Functions 2 October 19th 07 06:26 PM
How to insert rows that copy cell content of the row above Rocket Scientist Excel Discussion (Misc queries) 0 July 1st 07 04:18 PM
copy comment content to cell content as data not as comment Lilach Excel Discussion (Misc queries) 2 June 21st 07 12:28 PM
Copy row based on cell content billinr New Users to Excel 6 February 21st 07 01:49 PM
How do I copy a cell (content AND format) from one worksheet to a. Excel Format Copy Excel Worksheet Functions 1 February 9th 05 10:34 PM


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