Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-08-2009, 03:45 AM
msofficeno475 msofficeno475 is offline Windows XP Office 2007
Novice
 
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 Windows Vista 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
Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM
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
Refreshing Data in Excel jamal420 Office 3 06-13-2005 03:45 PM


All times are GMT -7. The time now is 02:07 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft