Posted to microsoft.public.excel.misc

bmolintas

external usenet poster

Posts: 6

Trim and copy

I have multiple worksheets.

Sheet1 contains:

System Group Level Status Description
SYS1 SF99530 0007198 4 CUMULATIVE PTF PACKAGE C7198530
SYS2 SF99530 0007016 4 CUMULATIVE PTF PACKAGE C7016530

Sheet2 contains:

System Current CUM
SYS1
SYS2

How can I have sheet 2 automatically update based on referencing and
trimming cells in sheet1 to result in:

System Current CUM
SYS1 C7198530
SYS2 C7016530

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Using =TRIM()	Chuda	Excel Worksheet Functions	6	November 9th 06 03:05 PM
Trim	Steved	Excel Worksheet Functions	7	August 1st 06 05:43 AM
Trim if?	John	Excel Worksheet Functions	6	June 26th 06 04:44 PM
trim	geza	Excel Worksheet Functions	2	June 8th 05 07:03 PM
Trim Again	ferdy	New Users to Excel	5	May 12th 05 02:50 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us