X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Macro To Link Data, Office 2013    
post Sep 26 2019, 02:36 PM

Posts: 5
Joined: 19-July 13

(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.


Go to the top of the page
post Sep 26 2019, 05:05 PM

Posts: 1,307
Joined: 25-January 16
From: The Great Land

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

Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    3rd April 2020 - 01:47 AM