Transferring data

**jimpatel1993** · 01-21-2021, 06:11 AM

Hi,

Thanks for looking at my post. Please check the attachment

Basically i have 2 workbook in different shared location. I wanted to transfer some of the data from workbook 1 to workbook 2.
1. First i wanted to filter column G from workbook 1 to "Filter 2" and transfer only filter 2 data to workbook 2.
2. Then transferring like i wanted to transfer column C (source) to column B (destination) , column D to D, Column L to Column G, etc.
3. I wanted to sum from column P to colum AA and transfer those sum to destination at column H
4. Then copy from column AB to AH and paste in I to O in destination

I am not that great in macro and any help will be appreciated. If it is too much work then its ok. Thanks again and sorry guys

Thanks,
Jim

**maras_mak** · 01-21-2021, 02:49 PM

The code is in the VBA module of the 'Transfer data_maras' workbook.
Open it and run the code.The second workbook2.xlsx is opened with the code and the changes are saved when finished.

Please Login or Register  to view this content.

**jimpatel1993** · 01-22-2021, 06:06 AM

Hi Maras,

Thanks a lot for your time and effort for replying. I have downloaded and its works perfectly fine but when i try to convert to my source file i am getting an error in the below line. I think i am doing something wrong. I have attached my source and destination file (Exact format how it look like) is it possible for you to point me a direction where i am going wrong?

NOTE: I have update workbook2 manually how the result i am looking for. Unfortunately i am getting an error and i am sure i am doing something wrong.

thanks again

Have a nice day
Jim

**maras_mak** · 01-22-2021, 04:04 PM

There were anomalies in the 'Workbook2.xlsx'. Many headers had a space at the end, and the main workbook was not.
You need to post attachments on the forum with the same structure as the original.
Check how it works now.

**jimpatel1993** · 01-23-2021, 02:40 PM

Really thanks for your time and effort. It works perfectly fine and I just got stuck with final couple of bit. It will be much helpful if any one input any idea of how to do this bit please.
1. As I have added column AH and AI. There are few circumstance where column B (ID) might have repetition of same ID number and in this case I wanted to check “Grandtotal” in AI column and which ever is higher with the same ID number I wanted to transfer to the other workbook and ignore the other one please.
2. Secondly, when i transfer data to destination workbook by using the code you specified i have few more columns which is having other formula but for some reason when i use the column heading i am getting N/A. Do you know how to not to erase any formula in those cells plus stop transfering after column P please?

Any idea please?

Thanks again 
Jim

**maras_mak** · 01-25-2021, 08:26 AM

Does this do what you want?

Please Login or Register  to view this content.

**jindon** · 01-25-2021, 09:42 AM

Different method.
Run from Workbook2 and Source workbook should be closed.

Please Login or Register  to view this content.

**jimpatel1993** · 01-25-2021, 01:35 PM

Thanks a lot for the input. Both the ideas works fine and thanks a lot for your input. One final thing is I have added "sheet2" in the source work book with some data's having same unique ID and name from sheet 1 and some are new (highlighted in yellow for same unique id from sheet 1). It is exactly same concept but for some reason i am not getting luck in getting the solution. what i am after is I wanted to move data from sheet 2 (Sourceworkbook) to destination and if the same unique ID repeats in both sheet 1 and sheet 2 then i wanted to add in the respective column and row in the destination sheet. If it is new unique ID then i am looking for adding new additional row with same above concept. Any idea guys?
Thanks again
Jim

**jimpatel1993** · 01-27-2021, 06:19 PM

Any idea please

**jimpatel1993** · 01-30-2021, 12:56 PM

Any idea guys? Much appreciated if you could help.
Thanks

**p45cal** · 02-04-2021, 09:58 AM

See your cross post at Eileen's Lounge.

Transferring data

LinkBack

Thread Tools

Rate This Thread

Display

Transferring data

Re: Transferring data

Re: Transferring data

Re: Transferring data

Re: Transferring data

Re: Transferring data

Re: Transferring data

Re: Transferring data

Re: Transferring data

Re: Transferring data

Thread Information

Users Browsing this Thread

Similar Threads

Transferring Data

transferring cell data to different sheets when data is entered in particular cells

[SOLVED] Transferring data from a front sheet to correct tab dependant on the data

transferring of data

transferring data with an add-in

[SOLVED] Transferring Data

Bookmarks

Bookmarks

Posting Permissions