do if cell not empty
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
I am working on an order form. I have a list of items from a catalogue. So
far so good. Now when a person ADDs NEW ITEMS at the bottom of the list, I
need to copy some cells for as many rows as NEW ITEMS were added.
i.e. let's say there are 10rows with catalogue items, and there are two new
items added in column "C", then I have to copy "A and B 10" to "A and B 11
and 12" as well as "G and H 10" to "G and H 11 and 12".
HELP for the code.
thanks
.
Relevant Pages
- Re: Hornby shambles
... promotional catalogue, which doesn't have an order form. ... where catalogues and brochures are thrust at you. ... Nope - advertising needs to come out of the ...
(uk.rec.models.rail) - Re: Hornby shambles
... other fact is that there's a difference between a mail-order catalogue, which includes an order form, and a product-list or promotional catalogue, which doesn't have an order form. ... I'm afraid that paying for this sort of stuff really goes against the grain for me - perhaps that's because I work in an industry where catalogues and brochures are thrust at you. ... Nope - advertising needs to come out of the overhead side of things, and the profit margin needs to cover that. ...
(uk.rec.models.rail) - Re: Hornby shambles
... catalogue, which doesn't have an order form. ... neither occasion did any of my suppliers charge for catalogues and ... I simply wouldn't have done business with any ...
(uk.rec.models.rail) - if not empty do something
... I have order form based on info from catalogue. ... people will enter into bottom lines in column C. ... IF one, two or more items were added, THEN I need to copy last cells from ...
(microsoft.public.excel.programming) - Re: Cataloging help
... You need the titles in column A ... This will fill all the blank cells with the values from the row above. ... separate catalogue. ...
(microsoft.public.excel.misc) |
|
