LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Urgent new user needs Macro HELP!

Would anyone have a Macro the help me get the results below?

Workbook name: enlformat2
Worksheet name: enldata
sheet2
sheet3




A B C D Agency LastN FirstN XXX

DoITT Jones Kay
DoITT Smith Bob
Confuse Terry Jerry
Acme Hook Kathy
Acme Fung Jay
OEM Mitchell Robert
DEP Law Frank
DCP Shank Dee
OEM Crane Harry
Confuse Shockey Jay
DoITT Lauben John
DEP Water Logged

The output to appear as follows:


A B C D
Agency LastN FirstN XXX
Acme
Fung Jay
Hook Kathy
Confuse
Shockey Jay
Terry Jerry

DCP
Dee Shank
DEP
Law Frank
Water Logged
DoITT
Jones Kay
Lauben John
Smith Bob



--
53214920
 
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
need urgent help on macro merging deepika :excel help[_2_] Excel Discussion (Misc queries) 3 February 27th 08 05:07 AM
MACRO URGENT HELP OSK Excel Discussion (Misc queries) 2 June 29th 07 09:08 PM
Urgent need of a power user in Excel to help me build a sprdsht. Ema Excel Discussion (Misc queries) 2 April 30th 06 11:25 PM
Urgent - Help VBA Macro Jeff Excel Discussion (Misc queries) 8 October 3rd 05 08:25 PM
URGENT Mac/PC macro compatibility problem marika1981 Excel Discussion (Misc queries) 7 January 8th 05 12:43 AM


All times are GMT +1. The time now is 01:34 AM.

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"