Hello everyone, I'm writing a VBA script for a button command in Access.
I only want to update sometimes and don't want that option. :o Karen Hello, I am copying charts to display the same information for different regions. I have an item price list and if a particular cell gets updated I want to automatically record the date of change of that cell.
When I work on the copied region, I find it a cumbersome task to go through each charts source data and change the cell references to the different region. I realize that after I change cell A1 I could tab to cell B1 and enter Ctrl ; but if I have a hundred new prices to enter I don't want to do that (plus me or the data entry person might forget).
If none of those options do exactly what you want, you also can click Paste Special.
I have seen your previous tips (Export data from SQL Server to Excel and Different Options for Importing Data into SQL Server) related to working with Excel and SQL Server data.
In order for me to do it on the 75-100 files I have at any given time, I need to open one, run the macro, close and save, then open the next one. I need to create a macro which auto-populates a master worksheet from the individual user sheets in a shared workbook. There will be an undetermined number of individual worksheets to accomodate new staff.