Home Take the date in one worksheet and find the same date in another worksheet column and return the cell reference for that date to use in a loop
Reply: 0

Take the date in one worksheet and find the same date in another worksheet column and return the cell reference for that date to use in a loop

user3675
1#
user3675 Published in September 19, 2018, 6:44 pm

Dim wb As Workbook Dim ws1 As Worksheet

Set ws1 = wb.Sheets(1)

Dim Lastrow_ws1 As Long Lastrow_ws1 = ws1.Range("A" & Rows.Count).End(xlUp).Row

Dim LastDate As Long

Set LastDate = something 'take the last date in ws3 column A and find that date in ws1 column A and find the return the cell reference

For y = LastDate To Lastrow

ws1.Cells(y, "A").Copy ws2.Range("A1").PasteSpecial Paste:=xlPasteValues

Calculate

'THEN RUN A SEPERATE LOOP USING THE LASTDATE VARIABLE

share|improve this question

1 Answer 1

active oldest votes
up vote 0 down vote
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.327643 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO