PDA

View Full Version : Solved: Copying & Sorting



sooty8
09-17-2009, 01:50 AM
Hi All

Attached a workbook with 4 sheets preety much self Explanatory and on the Input Sheet have put the details of what I need to do - the ranges are many more rows can you help with a Sub to make it all run.

Many Thanks

Sooty8

rbrhodes
09-17-2009, 10:34 PM
Hi s8,

Is the data already sorted or does that have to happen as well?

Edit Always UKyyEtc as invoice number?

rbrhodes
09-17-2009, 11:32 PM
Ah anyways...

- Sort required?

Yes.

- Always UK YY etc? for year number? In other words year is always char 3 & 4?

Yes.

-Clear old data from year sheets first or append?

Append.


There. I answered my own questions. Does that mean I'm 'SOLVED'?

S8, see attached.

sooty8
09-18-2009, 03:05 AM
Hi dr,
Not words I've used before however thats' - "pretty cute" can now start digging out the invoices for 07,08,09, and its all set up for 2010 -- office Jnr is not going to be a happy bunny for the next few days.

Many Thanks

Sooty 8