- Sep 24, 2014
- 655
- 272
Ok, does anyone know how to create a VBA that will search a document for a particular ranges of dates, then copy the date contained over to a new worksheet?
NT Excel gurus.. come hither
- Thread in 'General' Thread starter Started by verbal kint,
- Start date
- Nov 4, 2013
- 1,391
- 1,188
no one is writing that out for you out of the goodness of their hearts here
go to r/excel
go to r/excel
- Jan 13, 2015
- 692
- 460
Thread is lulz
- Jan 13, 2015
- 692
- 460
Are the dates in one column?
If so, just create a filter for the dates, highlight the dates and copy the filtered results. Might not eem need vba
If so, just create a filter for the dates, highlight the dates and copy the filtered results. Might not eem need vba
- Apr 28, 2005
- 943
- 390
You need a common factor between both sheets as reference then you can use a Vlookup
I'm on my iPad in class so if it doesn't come out right just pm me and I can send you an example later.
=vlookup(item that you want to match, [item matching1 +however many rows till your date column, # you date column is in relative to item matching, false
Ex
Sheet1 Sheet 2
A B C D E F G H I J A B C D E F G H I J
1 2 3 4 6 1 D 2 4 3 5 6
Code = vlookup(A1,sheet2$A$1$A2, 2, false)
Value in A1 is what it's looking for and matching from sheet 1. Sheet2 is a made up name but it will look like that based onYour other data. but basically just select from the matching cell I happened to make it A1 on the second sheet as well drag from the header until you hit the column your looking for which happens to be column b row 1 on my example. The( 2, false ) will need to be adjusted based on the placement of the column your dates are in in my example they are on column 2 relative to the match in a1. Leave false alone. If you type this code into your specified column It should pull the dates. Make sure and adjust number type to dates or you'll get 4000 numbers
I'm on my iPad in class so if it doesn't come out right just pm me and I can send you an example later.
=vlookup(item that you want to match, [item matching1 +however many rows till your date column, # you date column is in relative to item matching, false
Ex
Sheet1 Sheet 2
A B C D E F G H I J A B C D E F G H I J
1 2 3 4 6 1 D 2 4 3 5 6
Code = vlookup(A1,sheet2$A$1$A2, 2, false)
Value in A1 is what it's looking for and matching from sheet 1. Sheet2 is a made up name but it will look like that based onYour other data. but basically just select from the matching cell I happened to make it A1 on the second sheet as well drag from the header until you hit the column your looking for which happens to be column b row 1 on my example. The( 2, false ) will need to be adjusted based on the placement of the column your dates are in in my example they are on column 2 relative to the match in a1. Leave false alone. If you type this code into your specified column It should pull the dates. Make sure and adjust number type to dates or you'll get 4000 numbers
fontaine
Banned
- Jul 5, 2013
- 8,053
- 6,535
You should do a sumif...
But VBA?
Ain't nobody writing that code for you like buddy said
But VBA?
Ain't nobody writing that code for you like buddy said
truth-serum
Banned
- May 16, 2013
- 4,062
- 1,432
My PayPal is ready if you need help with your homework. Time is money b
