Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to automate process
What I need is a way of automating a process that I need to do on a monthly
basis. Basically I have 1 main file that I manually enter data onto file Titled May 2007 (this is the one I completed last month) The other individual files that start with 050107-053107 contain the information that I need to enter onto the blank template. I would like to set up some way that I can import this information into the spreadsheet instead of manually entering it data into each cell. I wouldnt mind importing each individual file. this step 1 of the long process I need completed. Once I figure out how to explain step 2 and have an example for it I will let you know. Please give me a quote on this IF there is a way to set this up whether using macros or some sort of spreadsheet merge. any help will regre |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to automate process
Any reason you don't do a copy, paste?
sand wrote: What I need is a way of automating a process that I need to do on a monthly basis. Basically I have 1 main file that I manually enter data onto file Titled May 2007 (this is the one I completed last month) The other individual files that start with 050107-053107 contain the information that I need to enter onto the blank template. I would like to set up some way that I can import this information into the spreadsheet instead of manually entering it data into each cell. I wouldnt mind importing each individual file. this step 1 of the long process I need completed. Once I figure out how to explain step 2 and have an example for it I will let you know. Please give me a quote on this IF there is a way to set this up whether using macros or some sort of spreadsheet merge. any help will regre |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to automate process
i dont mine to copy and paste but it gonna waste 4 to 5 hours
"Bob I" wrote: Any reason you don't do a copy, paste? sand wrote: What I need is a way of automating a process that I need to do on a monthly basis. Basically I have 1 main file that I manually enter data onto file Titled May 2007 (this is the one I completed last month) The other individual files that start with 050107-053107 contain the information that I need to enter onto the blank template. I would like to set up some way that I can import this information into the spreadsheet instead of manually entering it data into each cell. I wouldn€„˘t mind importing each individual file. this step 1 of the long process I need completed. Once I figure out how to explain step 2 and have an example for it I will let you know. Please give me a quote on this IF there is a way to set this up whether using macros or some sort of spreadsheet merge. any help will regre |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to automate process
If the file names are always different, it will be a bit difficult to
replace the human. If you can change that part of the system then you can work on automating things. sand wrote: i dont mine to copy and paste but it gonna waste 4 to 5 hours "Bob I" wrote: Any reason you don't do a copy, paste? sand wrote: What I need is a way of automating a process that I need to do on a monthly basis. Basically I have 1 main file that I manually enter data onto file Titled May 2007 (this is the one I completed last month) The other individual files that start with 050107-053107 contain the information that I need to enter onto the blank template. I would like to set up some way that I can import this information into the spreadsheet instead of manually entering it data into each cell. I wouldn€„˘t mind importing each individual file. this step 1 of the long process I need completed. Once I figure out how to explain step 2 and have an example for it I will let you know. Please give me a quote on this IF there is a way to set this up whether using macros or some sort of spreadsheet merge. any help will regre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate deletion process | Excel Worksheet Functions | |||
How can I automate the process of copying the first letter of a ce | Excel Worksheet Functions | |||
If/then Process? | Excel Discussion (Misc queries) | |||
Automate process via button on form | Excel Worksheet Functions | |||
How to automate process of replacing values? | Excel Discussion (Misc queries) |