Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Entry - Write to next cell & next blank line
I am trying to use a data entry form to write a new data line into the next
blank line starting at cell A12 and ending at ending at cell AG12. There are a total of eleven(11) data entry lines available. I have been using the following code but I am having trouble with a) writing data to cells B12 to AG12, and b) how to write a new record to the next new line starting at A14 to AG14. COuld someone help me out or point me in the right direction. P.S. I hope the formatting comes out okay. A1 - blank B1 C1 A2 - blank B2 C2 A3 - blank B3 C3 A4 - Header 1 B4 C4 A5 - Header 2 B5 C5 A6 - Header 3 B6 C6 A7 - Header 4 B7 C7 A8 - Header 5 B8 C8 A9 - blank B9 - Header 6 C9 - Header 6 A10 - blank B10 - Header 7 C10 - Header 7 A11 - Header 8 B11 - Header 8 C11 - Header 8 -------------------------------------------------------------------------- A12 - Data Line 1 | B12 - Data Line 1 | C12 - Data Line 1A | | |-------------------------| A13 - Data Line 1 | B13 - Data Line 1 | C13 - Data Line 1B | -------------------------------------------------------------------------- A14 - Data Line 2 | B14 - Data Line 2 | C14 - Data Line 2A | | |-------------------------| A15 - Data Line 2 | B15 - Data Line 2 | C15 - Data Line 2B | -------------------------------------------------------------------------- ~ ~ ~ -------------------------------------------------------------------------- A32 - Data Line 3 | B32 - Data Line 3 | C32 - Data Line 3A | A33 - Data Line 3 | B33 - Data Line 3 | C33 - Data Line 3B | -------------------------------------------------------------------------- A34 - blank B34 - blank C34 - blank ~ ~ ~ A47 - blank B47 - blank C47 - blank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry - Write to next cell | Excel Discussion (Misc queries) | |||
Data entry line missing | Setting up and Configuration of Excel | |||
can I write an Excel macro to pause for data entry then continue? | Excel Discussion (Misc queries) | |||
how do I write macro to sum numbers up to next blank line? | Excel Discussion (Misc queries) | |||
How, on a line chart, to skip blank entry rather than plot as 0? | Charts and Charting in Excel |