Macro to Find and paste the cell value

[Daddy143]

Hello,

I'm newbie to Excel. i need your help. i have a file and i want data from sheet2 to sheet1.

Ex:
1. Sheet2 - Row A-King of Row-Civil: 10/3/2018 will be copied in sheet of E17 cell.
2. Sheet2 - Row A-Kitsap of Row-Civil: 10/3/2018 will be copied in sheet of E18 cell.
and this will repeat to last Row to Column.

https://www.dropbox.com/s/kd0ndz0jijzxxlx/PNWcourtwork (1).xlsm?dl=0

Can someone help with it?

thanks in advance....

 

[Daddy143]

Thank you so much mumps...

Apology for late reply, due to an medical emergency......

Works Superb.....if anything i need your help i will contact you Sir....

 

[mumps]

My pleasure. I hope everything is OK.

 

[Daddy143]

Hi Mumps

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
  97.5 KBViews: 0
• 
  T log.PNG
  122.6 KBViews: 0

 

[mumps]

Since this is a new topic, you should start a new thread. Use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data. Once you have done this, if you send me a private message with a link to your new thread, I'll be happy to have a look at it.

 

[Daddy143]

Apology for misunderstanding....
Yes, this is a new topic and i was started a new thread and below is the link.
please go through it and help me. thank you in advance..

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

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……). https://www.dropbox.com/sh/i08qcevxpfptnkk/AAC5hH0EdMqrf4jWXW1zscSDa?dl=0 From T log sheet Column K end...

www.mrexcel.com