Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #14  
Old 05-12-2013, 11:18 AM
Stevejd58 Stevejd58 is offline auto cell populate Windows 7 32bit auto cell populate Office 2010 32bit
Novice
auto cell populate
 
Join Date: May 2011
Location: UK
Posts: 24
Stevejd58 is on a distinguished road
Default

Hi Tony
That works a treat.
If at some point I need to change the Occupancy layout at a future date, would applying the formula =IF(ISERROR(VLOOKUP(C3,'FRONT SHEET'!$C$5:$D$25,2,FALSE)),"Empty",VLOOKUP(C3,'FR ONT SHEET'!$C$5:$D$25,2,FALSE)) and changing the cell details be sufficient.

The reason I ask is to
a) grasp what you actually did, to learn from you
b) a colleague is most likely to ask me to set the same up for the ward next door which is of a different floor plan
Reply With Quote
 

Tags
auto, cell



Similar Threads
Thread Thread Starter Forum Replies Last Post
auto cell populate Populate Data to another cell Mrkieth Excel 2 04-29-2013 07:30 AM
auto cell populate how do I auto-populate a word template Greenhorn Word 4 09-05-2012 04:16 PM
Auto populate text help i'm stuck! Word 1 08-13-2010 11:52 AM
auto populate to a PDF file jerrymbna22 Excel 0 07-12-2010 02:19 PM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft