| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract values from certain Cells to a Master Worksheet
Hello All,
I am using Office 2003 and have the following problem: I have many xls files in a folder C:\temp The first sheet of each file in folder C:\Temp is having some values at the following address: B8 F6 F7 B15 C15 C16 D15 E15 F15 G15 C21 B27 B28 E31 G31 I wish to extract the values from the above address from all the xls files in C:\Temp and paste it rowwise in a new Workbook eg. Export.xls from A1 onwards in the order given below: Eg. B8 will go to A1, F6 to B1, F7 to C1.... .... G31 will go to O1.. Can this be achieved? Any help would be greatly appreciated. TIA Rashid Khan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge cells from all worksheets into a master worksheet | Excel Discussion (Misc queries) | |||
| Can you extract URL values from a list of cells? | Excel Worksheet Functions | |||
| Macro to Extract Values from Master.xls to Report.xls | Excel Programming | |||
| how to extract only values from an Excel worksheet? | Excel Worksheet Functions | |||
| Extract unique values from worksheet into form | Excel Programming | |||
Threaded Mode
