Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2009, 03:45 AM
msofficeno475 msofficeno475 is offline Handling Excel Data Windows XP Handling Excel Data Office 2007
Novice
Handling Excel Data
 
Join Date: Dec 2009
Posts: 1
msofficeno475 is on a distinguished road
Default Handling Excel Data

Hi All,

I Have a requirement in Excel, sure this can be achieved, not sure how it can be done, can any one please help me?

I Have Following Data,

Emp_IDEmp_NameMGR1SkNull2ks13sw14abc25abcd3

EMP_ID is unique value no duplicates are allowed,

This is the data I have initially, If I change the emp_id of sk i.e., 1 wherever MGR values is 1 there it should get update with the new value, this should be applicable for new one's too....

if data is known I know how to do it, but for future entries to this table also formula should be populated,



Please can any one help for this requirement,
Reply With Quote
  #2  
Old 01-17-2010, 09:56 AM
BjornS BjornS is offline Handling Excel Data Windows Vista Handling Excel Data Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
your question is a little difficult to understand. Could you please attach an example (xls-file) and/or some more explanation.

Best Regards
Bjorn
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Handling Excel Data Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM
Handling Excel Data Excel not saving all data and formatting TRT Excel 2 04-09-2009 12:51 PM
Outlook Form that Saves Data to Excel dcbrown Outlook 0 12-29-2008 06:25 PM
Handling ICALENDAR attachments l_kris06 Outlook 0 11-12-2008 07:22 AM
Handling Excel Data Refreshing Data in Excel jamal420 Office 3 06-13-2005 03:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:09 AM.


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