| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Reference
Dear All,
I have two workbook A.xls and B.xls (where consist of 3 sheets). I would like to combine all Part Number in B.xls into A.xls with the following condition. 1.Sheet 1 - 15 records, sheet 2 - 35 records and sheet 3 - 50 records. 2.the first records of every sheets start from F4. 3.I would to combine those 100Records into A.xls. 4.When touch at the last row, then go to the next sheet, until 100 records. 5.In A.xls finally will leased those records from A1 to A100. Please how to link those cell by VBA? thank you for your kind help/. respectfully, andri |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Threaded Mode
