I have posted the following in microsoft.excel but no reply.. hence
posting in excel.programming..

Can Anybody help please

TIA
Rashid Khan


..=2EFollowing posted in microsoft.excel

Hello All,
I am using Office 2003 and have the following problem:
I have 2 different worksheets: Master.xls and Report.xls


Master.xls first two sheets are Named as Main and Codes plus=AD many
sheets generated by a macro (not necessarily all) by sheet n=ADames viz.

UNM, UNXL, HEH etc. etc.


Report.xls is as follows:


-- A B C D
1 CODE ITEM STOCK ISSUED
2 UNM UNIFORM MEDIUM 10
3 UNXL UNIFORM XL 12
4 UNXXL UNIFORM XXL 12
..=2E UN2XX UNIFORM 2XX 23
..=2E UNXXX UNIFORM XXX 22
..=2E. HEH HELMET HALF 10
..=2E HEF HELMET FULL 12
..=2E SH40 SHOES 40 34
..=2E SH41 SHOES 41 12
..=2E SH42 SHOES 42 11
..=2E SH43 SHOES 43 11
..=2E SH44 SHOES 44 11
..=2E MA MASK 12
..=2E SC SAFETY CLOTH 21
..=2E LG LARGE GLOVES 22
..=2E SG SMALL GLOVES 24
..=2E GL SAFETY GLASSES 24


I wish to extract the value (Cell E3) from all the existing =ADsheets in

Master.xls (except Main Sheet and Codes Sheet) and paste it =ADin the
corresponding place in Report.xls.
Eg value of Cell E3 of UNM sheet of Master.xls should get pa=ADsted in
D2
of Report.xls, value from Cell E3 of UNXXL will get pasted i=ADn D4 and
so
on and so forth..
I cannot use link from Master.xls as the number of Sheets in=AD
Master.xls
differs each time. Only Main and Codes sheets are constant =ADin
Master.xls.


I hope I am clear..
Any help would be greatly appreciated.
TIA=20
Rashid Khan=20

..=2E.. end of Post