Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populate a form from a sheet in same workbook
I have a spreadsheet of parts data called Register. On a separate page, I've
created a form called OnHold form. Some of the cells in the OnHold form get populated with information from data in the Register spreadsheet. The data will always come from the same row and will always be from the last row. I think I've figured out how to get to the last row of the Register sheet (this in a commandbutton on the OnHold Sheet). Dim rgLastCell As Range Set rgLastCell = Sheet.Register.Range("A65536").End(xlUp) Range("B9").Value = rgLastCell.Value But maybe not. I want the last value in the last cell in Row A to go into cell B9 in the OnHold form. Then I want the last value in the last cell of Row B to go into cell G11, etc. I thought to just repeat the code above but change the ranges, and I'm sure you know why it won't work, but I don't. Can anyone help? I'm really new at macros in Excel. Thanks, DM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate a form | Excel Worksheet Functions | |||
How to enter data in one form & populate several others w/same. | Excel Worksheet Functions | |||
How to populate prices in sheet two based on cost in sheet one | Excel Worksheet Functions | |||
Link a form field in a Word document to populate an excel spreads | Excel Discussion (Misc queries) | |||
How do I select cells and make the info populate into a form? | Excel Worksheet Functions |