UtterAccess.com
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    
 
   
cjmadore
post Sep 26 2019, 02:36 PM
Post#1



Posts: 4
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.

Thoughts?



Go to the top of the page
 
June7
post Sep 26 2019, 05:05 PM
Post#2



Posts: 968
Joined: 25-January 16



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.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    18th November 2019 - 04:35 AM