473,382 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Filtering and extraction of data by date

Hi
I have a problem copying the result of a filter on excel to another sheet

This is thefunction i use to filter oSheet:

oSheet.Range("A1", "AP" & LastRowAll).AutoFilter(2, ">01/03/2007")

So it does the job, now what I want to do is to copy this information on "sheet2", ie i don't want to see the hidden row.
I managed to copy everything but the hidden row show up.
Pretty much what i want to do is to extract any information whenever a certain date in column 2 is greater than a certain date, I would have thought that filter was the best way, but i cant seem to copy the information somewhere else... .
Thanks !
Apr 18 '07 #1
3 4648
SammyB
807 Expert 512MB
Hi
I have a problem copying the result of a filter on excel to another sheet

This is thefunction i use to filter oSheet:

oSheet.Range("A1", "AP" & LastRowAll).AutoFilter(2, ">01/03/2007")

So it does the job, now what I want to do is to copy this information on "sheet2", ie i don't want to see the hidden row.
I managed to copy everything but the hidden row show up.
Pretty much what i want to do is to extract any information whenever a certain date in column 2 is greater than a certain date, I would have thought that filter was the best way, but i cant seem to copy the information somewhere else... .
Thanks !
How can we get the same question twice in one day? See http://www.thescripts.com/forum/thread634196.html. In your case, it would be
oSheet.Range("A1", "AP" & LastRowAll).SpecialCells(xlCellTypeVisible).Copy

This corresponds to the Excel menu item Edit, GoTo, Special, Visible cells only just in case you every want to do it manually. HTH --Sam
Apr 18 '07 #2
Thanks !
I looked so long so an answer to this question ! I was stuck !
Thanks very much Sammy !
Apr 19 '07 #3
SammyB
807 Expert 512MB
Thanks !
I looked so long so an answer to this question ! I was stuck !
Thanks very much Sammy !
Yea, it's one of those things that is not obvious. :D
Apr 19 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Kal | last post by:
I have a particular problem: I am working at a client site where they have the following oracle system: Oracle7 Server Release 7.3.3.0.0 - Production Release PL/SQL Release 2.3.3.0.0 -...
3
by: Aionius | last post by:
Good day to all. I have this problem in JavaScript. I have a form (textbox) which accepts a series of numbers in format 9999-9999-9. Now i want to filter all inputs to the textbox. let's say...
1
by: Bob | last post by:
I have been asked to modify an existing Access database so that it can update a MySQL databse in head office from multiple MS Access databases in branches. The idea is that when the HO database is...
1
by: samotek | last post by:
Filter the last date only I am trying t0 filter only the last date of the query,but i cannot manage that. My query is the following : SELECT Sum(.liters) AS SumOfLiters, orders.invoicedate...
9
by: David Rysdam | last post by:
I have a large amount of data that I copy in and out of Sybase very often. Now I also want to copy this data in and out of postgres. I have an existing script that creates the entire database(s)...
0
by: aviklund | last post by:
Hi, I made a simple data access page with a search button that does work properly, but now I would like to add a filtering to the command button also. Ideal solution would be like this: ...
5
by: | last post by:
Hi everyone. I'm trying to work with very simple data structures but I'm stuck in the very first steps. If someone has the luxury of a few minutes and can give an advice how to resolve this, I'll...
3
by: ilikebirds | last post by:
My table looks like the following , ,, Ex. , , , , , It contains all the and that goes through in the past 3 months. How would I go about querying for all 's that took more than 1 day...
0
by: billiejoefanclub | last post by:
I have 3 pages, 2 of which are in a frame. In page 1, I have a button which after the user clicks opens the frame in which page 2 should be filtered based on a selection in page 1. I am passing the...
5
by: Rebecca McCallan | last post by:
*above I meant to say 'search form, from' I am wondering if it is possible to open a search form from another form (onclick of any record in a text box), pre-filtering the data in the search to...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.