Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Microsoft Excel _ Macro To Link Data

Posted by: cjmadore Sep 26 2019, 02:36 PM

(Microsoft Excel for Office 365 MSO)

I am trying to create a macro, that pulls data by date, then removes that formula (paste special values); the next day, it moves to the next cell (date) down, does the lookup, and so on. It repeats daily and creates a continuous list without maintaining a constant link between the 2 files. The reference file would also be an excel workbook.

Thoughts?




Posted by: June7 Sep 26 2019, 05:05 PM

I expect would be possible. You need to make an effort and when you have code with specific issue, post question.