I need to copy cells from one worksheet to another based on a text value held
in opne of the columns. The data is regarding late payments, so i have a
field "LATE?" which is either "LATE" "OK" or blank or N/A (ie other). I would
like to copy all of the rows that contain the value "OK" to a sheet called
"On Time" within the same workbook and all others ("LATES" and blanks etc) to
another called "LATE".

Any advice about how to do this would be great as I dont know any functions
that move cells and am unsure how I would go about it using VBA.

I also need to know how to move a set of formulas as a dynamic named range
increases. I have a set of SUMIF formulas that multiply a postage type field
by amount of boxes to work out totals for all the data. These formulas must
be at the bottom of the data since whole rows will be pasted in which would
overright them otherwise. I would like the formulas to be at the immediate
end of the data, ie one row more than whatever amount of rows are included in
my dynamic range. I write these two questions together because I suspect that
I could achieve this if I knew how to move cells automatically.

"oli merge" wrote:

I need to copy cells from one worksheet to another based on a text value held
in opne of the columns. The data is regarding late payments, so i have a
field "LATE?" which is either "LATE" "OK" or blank or N/A (ie other). I would
like to copy all of the rows that contain the value "OK" to a sheet called
"On Time" within the same workbook and all others ("LATES" and blanks etc) to
another called "LATE".

Any advice about how to do this would be great as I dont know any functions
that move cells and am unsure how I would go about it using VBA.

1) create 2 new sheets called On Time and Late. (Right click on the sheets
at the bottom, choose insert worksheet, then do it again but choose rename).

2) go back to your original list. select all the data and do Data Filter
Autofilter

3) use the little arrow on the column you are interested in to filter for OK

4) select all of these and do ctrl-C (copy)

5) select the sheet called On Time, do right-click in cell A1 and do paste
special values then do it again with paste-special formats

6) go back to your original sheet. now on the filter arrow choose custom.
choose "does not equal OK"

7) select the sheet called Late, do right-click in cell A1 and do paste
special values then do it again with paste-special formats

8) (cheeky one this) very important, come back to this website, click on
this message and give me a green tick

HTH

--
Allllen


"oli merge" wrote:

I need to copy cells from one worksheet to another based on a text value held
in opne of the columns. The data is regarding late payments, so i have a
field "LATE?" which is either "LATE" "OK" or blank or N/A (ie other). I would
like to copy all of the rows that contain the value "OK" to a sheet called
"On Time" within the same workbook and all others ("LATES" and blanks etc) to
another called "LATE".

Any advice about how to do this would be great as I dont know any functions
that move cells and am unsure how I would go about it using VBA.