LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Need to List Servers from one worsheet to another based on a condt

Sheet1

Servers Environment
devServer1 Dev
preprodServer1 PreProd
prodServer1 Prod
prodServer2 Prod

Sheet 2

Dev PreProd Prod

I need a code to evalate or compare the value from Environment column
(Sheet1) and append the server name under appropriate Column in Sheet2.

End Result for Sheet2 will be

Dev PreProd Prod
devServer1 preprodServer1 prodServer1
prodserver2


Your Help is greatly appreciated.




--
Regards,
Mahesh
 
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
Possible to link servers with ADO or others? Angus Excel Programming 0 August 23rd 06 08:40 AM
Multiple Excel Servers Robert ap Rhys Excel Programming 8 January 24th 06 09:36 AM
use shared workbooks on Web servers Gkrish Excel Discussion (Misc queries) 1 January 22nd 05 09:21 PM
Getting Data from Web Servers and Application Servers James B Excel Programming 0 June 3rd 04 01:26 AM
Worsheet Name Change Based on cell's value nuver Excel Programming 12 May 29th 04 04:26 AM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"