VBA copy and pasted specific data from one workbook to another workbook

Daddy143

New Member
Joined
Dec 10, 2018
Messages
14
Hello everyone,

I was hoping to get some help to solving below.

We have 2 workbooks namely 1.PR (Contains sheet1, sheet2 and so on……) and 2. T log (Contains sheet1, sheet2 and so on……).


  • From T log sheet Column K end row data Need to add in PR sheet A column last row
  • Condition: Sometimes the dates are not changing on daily basis.
  • From T log sheet Column B end row data Need to add in PR sheet H column last row
  • A. From T log sheet Column K data repeat 2 times (Colored in Orange)
  • Conditions:
  • pick the data from column E row data (Colored in Green) and add in PR sheet O column
  • condition: above point 1 starts in same row O column need to add
  • pick the data from column F row data (Colored in Grey) and add in PR sheet P column
  • condition: above point 1 starts in same row O column need to add
  • B. From T log sheet Column K data repeat 4 times (Colored in Blue)
  • Conditions:
  • pick the data from column E row data and add in PR sheet O column
  • condition: above point 1 starts in same row O column need to add
  • pick the data from column F row data and add in PR sheet P column
  • condition: above point 1 starts in same row O column need to add


  • A. From T log sheet Column K data repeat 2 times (Colored in Orange)
  • Conditions:
  • pick the data from column B row data (Colored in Pink) and add in PR sheet I column
  • condition: above point 1 starts in same row I column need to add
  • pick the data from column B row data (Colored in Pink) and add in PR sheet J column
  • condition: above point 1 starts in same row J column need to add
  • B. From T log sheet Column K data repeat 4 times (Colored in Black)
  • Conditions:
  • pick the data from column B row data and add in PR sheet I column
  • condition: above point 1 starts in same row I column need to add
  • pick the data from column B row data and add in PR sheet J column
  • condition: above point 1 starts in same row J column need to add
  • From PR sheet Column J end row data Need to add in same sheet N column last row
 

Attachments

  • PR.PNG
    PR.PNG
    97.5 KB · Views: 4
  • T log.PNG
    T log.PNG
    122.6 KB · Views: 4
Last edited:

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Hello everyone,

I was hoping to get some help to solving below.

We have 2 workbooks namely 1.PR (Contains sheet1, sheet2 and so on……) and 2. T log (Contains sheet1, sheet2 and so on……).


  • From T log sheet Column K end row data Need to add in PR sheet A column last row
  • Condition: Sometimes the dates are not changing on daily basis.
  • From T log sheet Column B end row data Need to add in PR sheet H column last row
  • A. From T log sheet Column K data repeat 2 times (Colored in Orange)
  • Conditions:
  • pick the data from column E row data (Colored in Green) and add in PR sheet O column
  • condition: above point 1 starts in same row O column need to add
  • pick the data from column F row data (Colored in Grey) and add in PR sheet P column
  • condition: above point 1 starts in same row O column need to add
  • B. From T log sheet Column K data repeat 4 times (Colored in Blue)
  • Conditions:
  • pick the data from column E row data and add in PR sheet O column
  • condition: above point 1 starts in same row O column need to add
  • pick the data from column F row data and add in PR sheet P column
  • condition: above point 1 starts in same row O column need to add


  • A. From T log sheet Column K data repeat 2 times (Colored in Orange)
  • Conditions:
  • pick the data from column B row data (Colored in Pink) and add in PR sheet I column
  • condition: above point 1 starts in same row I column need to add
  • pick the data from column B row data (Colored in Pink) and add in PR sheet J column
  • condition: above point 1 starts in same row J column need to add
  • B. From T log sheet Column K data repeat 4 times (Colored in Black)
  • Conditions:
  • pick the data from column B row data and add in PR sheet I column
  • condition: above point 1 starts in same row I column need to add
  • pick the data from column B row data and add in PR sheet J column
  • condition: above point 1 starts in same row J column need to add
  • From PR sheet Column J end row data Need to add in same sheet N column last row
looking for reply...
 
Upvote 0

Forum statistics

Threads
1,214,653
Messages
6,120,749
Members
448,989
Latest member
mariah3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top