I am really struggling with this and while its just the first part it technically controls everything else.
Say I have 18 (I've only shown 12) rows and the data represented in these rows are dependant on a table (for want of a better word) The table contains 4 pieces of information which will...
Sub numbers()
Dim rngCell As Range
For Each rngCell In Sheets("Final").Range("F13:F" & rowLast)
If WorksheetFunction.CountIf(Sheets("Filter").Range("A1:A" & rowLast), rngCell) <> 0 And _
Range("I" & rngCell.Row).Value <= 0 And _
Range("D" & rngCell.Row).Value < 50 Or _...
<tbody>
No.
Date
Job. No.
1
3/5/2016
456
2
4/5/2016
454
3
5/5/2016
455
4
6/5/2016
457
</tbody>
2nd Sheet
<tbody>
Job. No.
Date
454
455
456
457
</tbody>
I want to copy cell value from date column of 1st sheet if another cell in same row have "sample" value
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.