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: 2
  • T log.PNG
    T log.PNG
    122.6 KB · Views: 2
Last edited:

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

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
looking for reply...
 

Watch MrExcel Video

Forum statistics

Threads
1,114,513
Messages
5,548,499
Members
410,840
Latest member
Kar3ousse
Top