Add rows Automatically

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi All,

I am after a small piece of code which can accomplish the following.

In a worksheet, column A to K are formatted as follows :

Column A : Date
Column B : General
Column C : General (Contains Validation)
Column D : Amount
Column E : General (Contains Validation)
Column F : Amount (Contains Formula)
Column G : Amount (Contains Formula) - Hidden
Column H : Amount (Contains Formula) - Hidden
Column I : Amount (Contains Formula)
Column J : General (Contains Validation)
Column K : Text

I need to protect the sheet without telling anyone the password. Only
the unprotected cells can be filled in by the user. To keep the file
size small, only 100 empty rows are to be kept at the bottom with all
the above formatting. But whenever the user consume these rows,
additional rows need to be added at the bottom, which had to be done
manually. What I require is a macro, which when executed opens up a
box asking for number of rows to be added at the bottom, and then adds
the rows, copying everything from above (but without having the need
to unprotect the worksheet).

Is that Possible ?

Regards
Kanwaljit Singh Dhunna
.

Relevant Pages

  • Re: Interactive Woksheet ... How would you do this?
    ... This worksheet has been essentially unmodified for several years, though it is used on a regular basis to generate new recipies -- and recently 'broke' when a 'new' design requirement was encountered. ... The user fills in the blanks, specifying the ratio between the fillers, the amount of each active ingredient, the amount of each sweetner, and the amount of water. ... When I was given this worksheet, and observed how the designers were using it I immediately developed some VBA code tied to the worksheet_changed event to enable the designer to enter either the water amount or ratio, for example; and added a new field tied to the goalseek method to automate the manual trial and error iteration related to calculating the filler quantities. ...
    (microsoft.public.excel)
  • RE: Excel pull data based upon one specific word between two date
    ... Trying to lookup matching data from worksheet 2that has the above ... etc...this is the amount that is still due within the date ranges for this ... "Gary Brown" wrote: ... the insurance company name from one sheet to the data table and return the ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Excel pull data based upon one specific word between two date
    ... Rename 'Sheet 1' as 'AR AGING' ... Go to the 'RapiData' worksheet. ... D1 - Claim Amount ... "Gary Brown" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • RE: matching and deleting
    ... duplicate entries end up in sequential rows. ... Dim RowOffset As Long ... Are the entries to be compared on one worksheet or a group on one worksheet ... paste both sheets to a new worksheet and then sort by amount and then delete ...
    (microsoft.public.excel.misc)
  • RE: Macro - How do i....?
    ... I tried it and it worked on that worksheet... ... takes the amount in row 1column C and pastes it to all rows that hold ... column F and move them to the bottom of column C. ... cannot be cell specific. ...
    (microsoft.public.excel.programming)