If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I update a sheet automatically with the info from another?
I have a report that was downloaded from an ERP system into an Excel
spreadsheet. We manually take the numbers from this spreadsheet and update another in a different workbook. Not all the information from the report is used. Isn't there a way to run somekind of macro to automatically do this? |
#2
|
|||
|
|||
how do I update a sheet automatically with the info from another?
Richard
As a starting point................................... Certainly you can run a macro to automate this. That is the purpose of VBA. The only difficult part is how you decide which information is to be used and how you will get that to the other workbook. Can you perhaps use the Macro Recorder to run through your steps and refine the code? How will you filter the info for pertinence? How will you transfer once you filter? Copy and paste or just straight "linked cells"? Gord Dibben MS Excel MVP On Thu, 20 Apr 2006 16:29:02 -0700, Richard wrote: I have a report that was downloaded from an ERP system into an Excel spreadsheet. We manually take the numbers from this spreadsheet and update another in a different workbook. Not all the information from the report is used. Isn't there a way to run somekind of macro to automatically do this? |
#3
|
|||
|
|||
how do I update a sheet automatically with the info from anoth
Hi Gord,
Appreciate you're response, but I'm a little lost. Let me walk you through my process. What I do now is write down the information that I need and once I have everything I input that info into the appriate spots on the other sheet. What you're describing sounds complicated. Isn't ther some genieric code or program I could use to do this with? I don't know squat about VBA or recording Macro's and refining code. Whatever help you can provide would be appreciated. Thank You, Richard "Gord Dibben" wrote: Richard As a starting point................................... Certainly you can run a macro to automate this. That is the purpose of VBA. The only difficult part is how you decide which information is to be used and how you will get that to the other workbook. Can you perhaps use the Macro Recorder to run through your steps and refine the code? How will you filter the info for pertinence? How will you transfer once you filter? Copy and paste or just straight "linked cells"? Gord Dibben MS Excel MVP On Thu, 20 Apr 2006 16:29:02 -0700, Richard wrote: I have a report that was downloaded from an ERP system into an Excel spreadsheet. We manually take the numbers from this spreadsheet and update another in a different workbook. Not all the information from the report is used. Isn't there a way to run somekind of macro to automatically do this? |
#4
|
|||
|
|||
how do I update a sheet automatically with the info from anoth
Richard
Check out Help on "linking". You can set up formulas on Sheet2 that will receive data from selected cells on Sheet1. e.g. On Sheet2 in A1 enter this formula =Sheet1!D4 Now, when you enter data or the data value changes in D4 on Sheet1, it will automatically go into A1 of Sheet2 Gord On Fri, 21 Apr 2006 11:24:02 -0700, Richard wrote: Hi Gord, Appreciate you're response, but I'm a little lost. Let me walk you through my process. What I do now is write down the information that I need and once I have everything I input that info into the appriate spots on the other sheet. What you're describing sounds complicated. Isn't ther some genieric code or program I could use to do this with? I don't know squat about VBA or recording Macro's and refining code. Whatever help you can provide would be appreciated. Thank You, Richard "Gord Dibben" wrote: Richard As a starting point................................... Certainly you can run a macro to automate this. That is the purpose of VBA. The only difficult part is how you decide which information is to be used and how you will get that to the other workbook. Can you perhaps use the Macro Recorder to run through your steps and refine the code? How will you filter the info for pertinence? How will you transfer once you filter? Copy and paste or just straight "linked cells"? Gord Dibben MS Excel MVP On Thu, 20 Apr 2006 16:29:02 -0700, Richard wrote: I have a report that was downloaded from an ERP system into an Excel spreadsheet. We manually take the numbers from this spreadsheet and update another in a different workbook. Not all the information from the report is used. Isn't there a way to run somekind of macro to automatically do this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Does excel recognise names rather than cells? | Sue | Worksheet Functions | 9 | May 22nd, 2005 04:51 AM |
How do I determine automatically that a sheet is empty? | [email protected] | Worksheet Functions | 4 | May 9th, 2005 08:15 PM |
Office XP Update Problem | Bill | General Discussions | 0 | December 1st, 2004 06:11 PM |
Function to automatically insert a new sheet as a result of data entry? | Mark Mulik | Worksheet Functions | 2 | November 28th, 2004 02:21 AM |
help moving info from one sheet to another automatically | Grace | Worksheet Functions | 3 | April 29th, 2004 04:29 PM |