LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Linking Cells from a different Worksheet with an IF Function

Hi

In my workbook I have two worksheets, one of which includes data from
Access, the other presents it in a more managable way. What I need is a
formula that would link two cells across the worksheets IF the individual
(numbered from 1-22) and the date (in dd/mm/yyyy) meet criteria. Also, the
data is incomplete (in that some months there was no data inputted (when a
zero should have been inputted)) would need to show a 'zero'

Any Ideas?

G
 
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
Linking cells into empty cells in another worksheet Bookworm Excel Discussion (Misc queries) 6 October 14th 07 11:11 AM
Linking cells between worksheet - from column to row dm Excel Worksheet Functions 2 January 7th 07 04:49 PM
Problem on linking different cells from other worksheet ? Eric Excel Discussion (Misc queries) 2 August 7th 06 02:20 PM
Linking cells by name only to another worksheet.... Jkralick Excel Worksheet Functions 3 June 8th 06 02:01 AM
Linking incremental cells from another worksheet Aaron Daniels Excel Discussion (Misc queries) 2 November 18th 05 12:16 AM


All times are GMT +1. The time now is 12:38 PM.

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"