Is it possible to import data from one excel into another excel but into specific cells

[cadmancan]

Hello all! We have an excel document that gets exported from a piece of equipment as a report. Its formatted in a way that makes little sense to us and we only need certain info extracted. As it stands now, we need to go line by line and verify excel info from one excel file (report equipment) to another formatted excel that we in turn have to turn around and incorporate into a construction document. The time it takes for us to verify two seperate excel files is crazy and our process is very prone to human error as the project deadline looms.

I know its possible to import data from one excel file into another. What I am after is to have excel data from one file imported into another previously formatted excel file but into specific cells every time. I dont want a new file to be created when this export happens. Hopefully I can choose certain fields from excelA.xls and have them imported into specific cells of excelB.xls which is already nicely formatted.

**So the fields from excelA.xls like A3:Z3 would automatticaly be exported to existing ExcelB.xls A5:Z5.


Hopefully I havent confused anyone and this process can be automated a bit. Each time we get a new report I hope the updating can be easily repeated. Any advice would be greatly appreciated. Thanks in advance.

[FDibbins]

this sounds very do-able. but before i can offer suggestions, can you please upload samples of what you are working with, along with some examples of what you're expected outcome is and how you arrived at that.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[cadmancan]

Appreciate the fast turn-around. I cant forward the actual document because its highly confidential according to our customer. I can do a mock up tomorrow morning and remove vendor/ site info and closely resemble what I am hoping for as an example and forward it to you. Thank you very much sir.

[reachharry]

Hi Cadmancan,

For your requirement, there is a feature called MS-Query which would let you to do this. Try exploring about it in google using the search word as "ms query in excel", this will give you a fair idea how to do this process. This feature has a lot of benefits for your kind of requirement.

Hope this helps...

Regards,
Hariharan R

[cadmancan]

Here is a very simplistic example. The first tab represents the report we get. The second represents the file we need to show in the end. On the second tab I have highlighted the exact fields I want to see from the previous report. This is the schedule that the installers and cloent will see. I know you can export info from one excel into another. I thought ( and I could be way wrong) when you export info from one excel it creates a new excel file for th eimport. I dont want a new file. I want the info to go into very specific fields.

Thanks for assisting me. reachharry I will look into MS-Query as you suggested.

[cadmancan]

Was checking back in to see if anyone had any ideas. Tried MS-Query but it doesnt seem to address my specific needs. Thanks in advance.

[BB1972]

cadmancan,

How do you tie-up the information on "Beginning report" with the various cells on "Finished result"? Are they always in the exact same order, or is the site number on "Beginning report", or... ? Just trying to understand the logic behind your sheet in order to assist you.