View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] serozkan@yahoo.com is offline
external usenet poster
 
Posts: 1
Default How can I have a macro update the sheet?

Hi all,
I am trying to create a macro that can update the entire sheet. I have
this data entry sheet and I also have a data.xls file that is converted
from a text file. This data.xls file changes every month. So, instead
of typing all those numbers every month into the data entry sheet,
which is a different workbook, I want to create such a macro that when
I run it, it should load all the numbers for the new month into the
data entry sheet.
I would be so happy if you guys help me out. Thanks