About Us

climate

Hi Sandy
Maximum number of lables is 10 .
Regards

"Sandy Mann" wrote:

Re-reading your post:

I need to a macro, when i input numbers at column H [245,789,7700,...] and
input optional lables [age, job,tall,....] then related data cell
(28,stud,143,.....)

If you want to only select some of the labels then you could have up to 60
inputs. What it the maximum number of labels that you would want to input?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

Replace @mailinator.com with @tiscali.co.uk

"climate" wrote in message
...
Hi
Please suppose that, the following is a matrix at my first file and on
sheet1.
Column H is numbered irregularly and has duplicate numbers and columns I
to
BP is labled(age,gen,....).

H I J K L ........... BP
age gen weight job tall
245 28 F 42 stud 143
789 14 M 33 stud 111
7700 56 F 63 artist 164
1289 31 F 61 dentist 165
..... ... . .. ........
...
..... ... . .. ........
...
I need to a macro, when i input numbers at column H [245,789,7700,...] and
input optional lables [age, job,tall,....] then related data cell
(28,stud,143,.....) copy to separate file(test.xls)and set on to sheet1
and
set extracted data to second row and column I.

Thank's for any help.

best regards

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selecting Data	ckane	Excel Discussion (Misc queries)	1	October 29th 08 05:53 PM
Selecting data for report	Lost in excel	Excel Discussion (Misc queries)	2	August 13th 08 08:38 PM
Selecting most recent data within several lines of data	wilson@irco	Excel Discussion (Misc queries)	0	June 19th 08 07:03 PM
Pivot charts - data disappear after selecting or data are static	Patricia Maklari	Excel Worksheet Functions	0	July 24th 07 01:36 PM
Selecting data	cyc	Excel Worksheet Functions	1	August 3rd 06 01:51 PM

Menu

About Us