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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

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,665
Messages
5,549,307
Members
410,909
Latest member
aa42
Top