Previous Topic Next Topic

How to extract data from one excel file to another

Closed
zamorin Posts 2 Registration date Tuesday 10 September 2013 Status Member Last seen 11 September 2013 - 10 Sep 2013 à 22:20
zamorin Posts 2 Registration date Tuesday 10 September 2013 Status Member Last seen 11 September 2013 - 11 Sep 2013 à 03:10
How do I extract data from one excel file to create a report in another excel file template?

The input file has various data fields. I need to extract 6 of the fields to create the report. Can I also group them in different tabs? Thank you.
Related:

2 responses

Réponse 1 / 2
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
11 Sep 2013 à 02:37
sample data is like this

hdng1 hdng2 hdng3 hdng4
62 62 62 62
62 62 62 62
62 62 62 62
62 62 62 62
62 62 62 62
62 62 62 62

try this macro on this data and see sheet 2. if ok modify macro 

Sub Test()
Dim r As Range
Dim aarea As Range
Worksheets("sheet2").Cells.Clear
Worksheets("sheet1").Activate
Set r = Range("B1:B1,D1:D1")
For Each aarea In r.Areas
aarea.EntireColumn.Copy
Worksheets("sheet2").Cells(1, Columns.Count).End(xlToLeft).Offset(0, 1).PasteSpecial
Next aarea
Application.CutCopyMode = False
End Sub
Réponse 2 / 2
zamorin Posts 2 Registration date Tuesday 10 September 2013 Status Member Last seen 11 September 2013
11 Sep 2013 à 03:10
Thanks a lot Venkat. That works. Now the problem is:

I have an excel file coming from a bank I need to extract the 6 columns to a new excel file. The banks have a 3 alphabet code for each branch. According to the branch code, the data should go into the respective tab in the new excel file.

ie: KLG records goes to KLG tab on the excel with the relevant details of the record included.

Thanks.

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses