autosum, filter then copy and paste

  • Thread starter Thread starter willroy
  • Start date Start date
W

willroy

Hello People, Hope you can help me out with this one.

I have a spreadsheet with a 13 tabs. 1 main one and the others for each
month of the year.

The spreadsheet will be used to log insurance policies issued by that
department.

~What I want to be able to do is to put data into the main one and
depending on when the start date of the policy is, to select and copy
into the correct month.

I don't wether I can enter in a formula with out using VBA.

Has anybody got any ideas?

Thanks

Will
 
hi Roger thats very helpful however, when I follow instructions for
'extracting data to another worksheet' an error message appears stating
that I need at least 2 rows of data to be selected.

Something is wrong

I need to paste the filtered data on a different sheet!

Any ideas?

Thanks

Will
 
When you select the List Range (steps 5 and 6 of the instructions),
select the entire list, not just the headings.
 
Hello Debra

impressive site.

It is now coming back with the error message "The extract name has
missing or illegal field name"

I think this may be due to the dates being in 10.01.99 format and no
10/01/99.

If this is so, is there any way around this?

Thanks
Wil
 
That message means that one or more of the headings in the extract area
is not an exact match for the headings in the List Range.
 
Ok, Ive managed to avoid the error message now and have checked the
headings match.

Now when I have asked it to advance filter the data and nothing gets
pasted back there at all.

My criteria is:

WEF WEF
01/06/1999 <30/06/1999
Click to expand...

Any ideas?

Thanks

Will
 
I followed those instructions and they worked ok for me, but I have USA
settings.

This is a guess:

Maybe you could use this in each of your criteria ranges:

WEF WEF
=">"&date(1999,06,01) ="<"&date(1999,06,30)

or even
WEF WEF
36312 <36341
Click to expand...

Those are the underlying values for those dates in 1900 base date system.

(if you write them as USA dates, does that help?)

WEF WEF
06/01/1999 <06/30/1999
Click to expand...

(And shouldn't all those comparison operators be >= or <= to include the
first/last day of the month??)
 
Just for my own enjoyment(?), did it have to do with the date formats?

Or was it something else?
 
Back
Top