Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking data with variable cell location
I have an Access 07 DB that has an output table link into a
spreadsheet. The problem with this and several other applications is that I want to be able to highlight the cell where I want the data added, like an append. Is there a way in the properties to make the location variable instead of a fixed cell location? This sheet would have other columns off to the right of the refreshed data that I want to be able to update, it would be great to have it feed back to the table in the DB, so they would become exact duplicates of each other. But, I want to put protection and tracking in the spreadsheet, as I am creating it to track an approval process. So, data refresh, send file, approvals and dates given, return sheet, repeat process. (This is done daily with printed emails at this time.) I am open to any other thoughts or ideas, but can't be to complex due to user knowledge. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save cell location to a variable | Excel Programming | |||
Rolling sum cell variable location input | Excel Programming | |||
Way to store cell location to variable? | Excel Programming | |||
VBA - Passing Cell Location To Variable | Excel Programming | |||
using variable as cell location | Excel Programming |