If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Count in a query | Ben | Running & Setting Up Queries | 21 | April 4th, 2006 10:12 PM |
I created a monster | Ben | Running & Setting Up Queries | 2 | March 16th, 2006 02:43 PM |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |