replication

Hello The dates should repeat exactly after the red arrow sign. please help.

Hello, I have started a new thread as directed. See background info at https://www.mrexcel.com/forum/excel-questions/1056650-can-i-turn-off-excel-table-auto-fill-formula-only-1-column.html#post5229744 I'm fairly new to the use of Tables. I have a Table where some columns are calculated and...

Hi gurus, I am looking for a VBA solution to check a cell which contains several updates and only keep the latest update, each update has its updated date and time. See the example below: <tbody> M 2 2018-05-18 01:02:09 - K (Work notes) As per suggestion, implemented the fix. No...

I have a pretty large workbook, with one main worksheet running quite a few formulas and arrays, pulling from various other worksheets in the workbook (that are essentially the reference databases) as well as one large worksheet that essentially contains thousands of replicated functions from...

Hi there, I'm currently attempting to automate the use of MS Access 2000's replication manager, but I don't have much knowledge in VBA. I am using Access 2010, but the two files I'm working with are saved as .mdb files (Access 2000). The first file is the data master (Example path is...

Can somebody please help!! I have set this macro up on a button, so whenever it is clicked a mastersheet is populated from the data in sheets "test1" and "test2". What i ideally want is everytime its clicked it replaces the old data and replaces. (to take into consideration of any changes)...

Hello All, I use Excel for Mac 2011. I have what appears to be a very simple requirement - but proving to be very challenging. I would like to have a formula which copies a value from a cell - where the total number of cells is referenced in another cell. Let me explain in an example attached...

I've been searching the posts (seems like a question that would be recurring), but I can't find an answer... I have an excel workbook that contains a list of file names in a hidden column (ak). I am using the following code (worked great in Excel 2003), but it doesn't work quite right in...