if not empty do something
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
I have order form based on info from catalogue.
If item not in 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
column A and B and last cells from column G and H DOWN to as many rows as
there were new items added.
Hope this is clear. If someone could give me the code for this.
Thanks
Helmut
.
Relevant Pages
- 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) - Re: Cataloging help
... "Roger Govier" wrote: ... This will fill all the blank cells with the values from the row above. ... separate catalogue. ...
(microsoft.public.excel.misc) - do if cell not empty
... I am working on an order form. ... I have a list of items from a catalogue. ... Now when a person ADDs NEW ITEMS at the bottom of the list, ... need to copy some cells for as many rows as NEW ITEMS were added. ...
(microsoft.public.excel.programming) - Keeping split cells together across page breaks
... I have a mail merge catalogue. ... Each item has one row with 10 cells, ... in the first column of the catalogue, and I want to prevent that. ... (Word 2003, Windows XP) ...
(microsoft.public.word.tables) - 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) |
|
