Import data from one workbook to another(Search for specific sheets for copy and paste)

**Zahid0111** · 03-11-2020, 12:56 AM

I have two excel files, One excel file is named as Dashboard and in which i have inserted "Import Data" button. I want, when i click this button it should bring the import/Browse/Select file window by using command Application.GetOpenFilename. An excel file will be selected and in this file it should search/look for Sheet named "Grade Wise"and copy all data (from column A to column E). This data to be pasted in dashboard workbook(where we have inserted the import button).It will search for Sheet named"RawData" and paste data in last blank row(Column A to Column E). I need VBA code for this operation please help me

**PCI** · 03-11-2020, 03:19 AM

Is it what you want

Please Login or Register  to view this content.

**jindon** · 03-11-2020, 05:27 AM

Completely different method.
Read data from closed workbook.

Please Login or Register  to view this content.

**Zahid0111** · 03-11-2020, 06:15 AM

Hi thanks it,s working great..thank you so much...Now after copying data i want to run a code(which is attached and included in file) whose function is to Seperate First alphabets of columns C(Grade).
As Columns C(Grade) has different grades whose starting alphabets are X, C,M,B and their third alphabets includes A,F,C also.
CHALLENGE 1: Now, i want to copy sum of all X to X (on same sheet column K), sum of all C to C(on Same sheet Column L), sum of all M to M (on same sheet Column M) and sum of all B to B (on Same sheet Column N) for each unique number(Farmer Number).
CHALLENGE 2: From ColumnC(Grade),It should also look for third alphabet(A,F,C) and copy their Sum of all A to A (on same sheet column U), Sum of all F to F (on 3rd sheet column V), Sum of all C to C (on 3rd sheet column W) as shown in attached pictures I need VBA code for this operations please help me.

Please Login or Register  to view this content.

**Zahid0111** · 03-11-2020, 06:20 AM

Hi thanks it,s working great..thank you so much...Now after copying data i want to run a code(which is attached and included in file) whose function is to Seperate First alphabets of columns C(Grade).
As Columns C(Grade) has different grades whose starting alphabets are X, C,M,B and their third alphabets includes A,F,C also.
CHALLENGE 1: Now, i want to copy sum of all X to X (on same sheet column K), sum of all C to C(on Same sheet Column L), sum of all M to M (on same sheet Column M) and sum of all B to B (on Same sheet Column N) for each unique number(Farmer Number).
CHALLENGE 2: From ColumnC(Grade),It should also look for third alphabet(A,F,C) and copy their Sum of all A to A (on same sheet column U), Sum of all F to F (on 3rd sheet column V), Sum of all C to C (on 3rd sheet column W) as shown in attached pictures I need VBA code for this operations please help me.

**jindon** · 03-11-2020, 06:32 AM

If you just want to run "test2" then add one line at the end of my code.

Please Login or Register  to view this content.

**Zahid0111** · 03-11-2020, 08:39 AM

I tried running your code by selecting another sheet which has data in Column F, G, H too and it copied that data and pasted in RawData sheet...I need to copy data just from Column A to Column E to RawData sheet. Can you please make the changes

**Zahid0111** · 03-11-2020, 08:48 AM

Attachment 666797 Attachment 666799

Hi after adding above code, i gives me the attached error.please look into this

**jindon** · 03-11-2020, 08:57 AM

Your attachment says "invalid".

**Zahid0111** · 03-11-2020, 09:04 AM

Attachment 666804
Attachment 666805
please check them now or i m sending main file too..

**jindon** · 03-11-2020, 09:10 AM

Originally Posted by Zahid0111

I tried running your code by selecting another sheet which has data in Column F, G, H too and it copied that data and pasted in RawData sheet...I need to copy data just from Column A to Column E to RawData sheet. Can you please make the changes

1) Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

2) Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**Zahid0111** · 03-11-2020, 09:14 AM

Yes it is now only copying the required columns..thanks great..
can you please check the other error, for which i sent the attachments too

**jindon** · 03-11-2020, 09:19 AM

You are adding the code, not changing the code.

Please Login or Register  to view this content.

**Zahid0111** · 03-11-2020, 09:45 AM

Attachment 666815
Actually i added this code to run test() as you advised, but it gives me error, can you please check the errors in the workbook attached
Attachment 666816
Attachment 666817

**Zahid0111** · 03-11-2020, 09:48 AM

I added the code(Highlighted BOLD) as given below

Please Login or Register  to view this content.

**jindon** · 03-11-2020, 09:52 AM

Read my post #11 carefully.

I have not said "add", I said "change" the line.

The last code I posted is already changed, so use it.

**Zahid0111** · 03-11-2020, 10:07 AM

Dear, i used it but error is coming from the code which i provided, kindly check it why it shows this error. attached are the screenshots along with workbook please
Attachment 666824 Attachment 666825

**jindon** · 03-11-2020, 10:20 AM

1) All your attachments are invalid, so stop it.

2) My code is working, but "test2" is throwing the error.
I don't really want to touch the code written by someone else, but sheet reference is strange.

Please Login or Register  to view this content.

I don't use sheet index if the sheet name is known.
Perhaps

Please Login or Register  to view this content.

Otherwise ask to the person who wrote the code.

**Zahid0111** · 03-11-2020, 10:33 AM

Ok Great Thank you so much for your kind help...i really appreciate for your kind time and effort

Import data from one workbook to another(Search for specific sheets for copy and paste)

LinkBack

Thread Tools

Rate This Thread

Display

Import data from one workbook to another(Search for specific sheets for copy and paste)

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Re: Import data from one workbook to another(Search for specific sheets for copy and paste

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA for copy/paste specific cells from several sheets into a master data workbook

Copy & Paste Data from workbook to various sheets of another workbook based on date

[SOLVED] macro to copy in loop all sheets at specific row and paste in a new workbook

[SOLVED] Search, Select, Copy, and Paste Specific Data

Search, Copy and paste specific field from one workbook to another

formula/macro to search sheet & copy data to specific sheets

macro to copy specific data from one sheet and paste into two sheets

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions