Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use the current row in a list to populate a report
I'm trying to create a workbook that uses a list to record each report. A
separate worksheet (called report) would serve as the report template. Each variable cell on the report would refer to a given column on the list worksheet. The trick is to select the current row of the list in order to make the reference. The reference I'm trying to accomplish would be something like: [report!c4] =[list!E(current row#)] All the references for a given report would come from a single row of the list, I have no experience with VBA, but I have been trying to figure out how to use those functions to get that reference, unsuccessfully so far. Perhaps a routine to get the current row of list and turn it into a variable to be plugged into the reference (current row#) above? Any help would be greatly appreciated. thanks, Dave |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use the current row in a list to populate a report
Worksheets("list").Activate
Worksheets("report").Range("C4").Value = Cells(Activecell.Row,"E") HTH -- AP "David Murto" a écrit dans le message de . 16... I'm trying to create a workbook that uses a list to record each report. A separate worksheet (called report) would serve as the report template. Each variable cell on the report would refer to a given column on the list worksheet. The trick is to select the current row of the list in order to make the reference. The reference I'm trying to accomplish would be something like: [report!c4] =[list!E(current row#)] All the references for a given report would come from a single row of the list, I have no experience with VBA, but I have been trying to figure out how to use those functions to get that reference, unsuccessfully so far. Perhaps a routine to get the current row of list and turn it into a variable to be plugged into the reference (current row#) above? Any help would be greatly appreciated. thanks, Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a dependent list, to a current list? | Excel Discussion (Misc queries) | |||
Populate List Box | Excel Worksheet Functions | |||
Input to populate report worksheet | Excel Worksheet Functions | |||
Update master list with other lists | Excel Worksheet Functions | |||
Populate Drop Down List | Excel Worksheet Functions |