AgTalk Home
AgTalk Home
Search Forums | Classifieds (79) | Skins | Language
You are logged in as a guest. ( logon | register )

How to store page format in Excel
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Omar
Posted 4/20/2015 19:45 (#4527954 - in reply to #4527918)
Subject: RE: How to store page format in Excel


Elmira, Ontario

You could record a macro to automatically make all the changes.

But the way I do it is to have a blank master page already formatted in a target file. Then I copy the downloaded report, and "paste special" (text only) into my formatted page. I already have all my headings etc, so all I copy is the actual data. You have to watch for when they change the column order but my experience is that doesn't happen often.

Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)