| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop for formula on one sheet with reference from another sheet
I have a form in XL that currently prints automatically with a macro when I
enter a project number. The list of project numbers is on another sheet in the workbook. The sheet I am working on is "Close Form" cell 'Range("D2:E2").Select' because it's a merged cell. I would like to have a macro that writes something like "='Upload Nos'!A1" in this merged cell looping through col A until the first blank cell in the sheet, "Upload Nos". I don't have enough macro experience to write it. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet Reference in Formula | Excel Discussion (Misc queries) | |||
| Loop through sheets & filter main sheet using sheet name | Excel Programming | |||
| Reference a Sheet in Formula | Excel Worksheet Functions | |||
| Formula in a sheet reference | Excel Worksheet Functions | |||
| Formula to reference name of sheet tab | Excel Discussion (Misc queries) | |||
Threaded Mode
