Hello!
In one sheet I have data which is connected with formula with data in another sheet. I want every day with macro to autofill the data in the first sheet, but I don't know how to set a destination.
I tried this :
Please Login or Register to view this content.
but it is not working. How can I change this code so it works?
Last edited by cassiopea; 02-08-2012 at 08:29 AM.
What, exactly are you trying to do?
Are you trying to copy the links down to match list 1
Try this:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Yes, I'm traying to copy the links down to match List1, but each day only for one day. So, today is 08.02.12 and I want this date and previous dates to be linked, and NOT following dates.
Basically:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks