Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to automtcly update th date in cell if info in row changes? | Excel Discussion (Misc queries) | |||
How do I read info from different worksheets into a summary sheet? | Excel Worksheet Functions | |||
Copying (Master) column to another sheet to automatically update | Excel Worksheet Functions | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |