Form Development - Adding Rows

Dec 16, 2009

I'm creating a spreadsheet to generate a standardized form that I use as a paralegal.

I have 2 things that I don't know how to create....

1 - I want to have y/n questions on the data entry tab. When boxes are clicked Y, it adds a row and language to the form which exists on another tab. I know how to do links and to do if then statements, but I don't know how to make it not take up space when the answer is n. Some of these clauses are pretty long so I don't want to have big blank spaces when the answer is no.

2 - I have certain sections where I need to control the number of rows. I want to have a cell on the data entry tab where I put in the number of rows that I want. The spread sheet would create those rows and I would then enter the data on the data entry tab. On the form tab, the spreadsheet would refer to the cell telling it the number of rows, add those rows, and link them to the data that I entered on the data entry tab.

View 9 Replies


ADVERTISEMENT

Development Of Excel Input Formula For Microbiology

Jul 4, 2014

Tried to open the formulation area of the forum but get an error so posting here and when that is working I can move it.

I need to develop a formula that is used in our microbiology laboratory and the formula on paper is attached as I needed scientific symbols.

total plate count formula.JPG

View 5 Replies View Related

Adding A Form To A Worksheet

Mar 25, 2009

I'm adding a form to a worksheet for the first. I tried to follow an example from the internet and then adapt for own form but have got lost and don't know where.

Attached is the excel file i am working on. On the summary worksheet i have added a button which works fine and opens up the form i have made.

My problem is it doesn't enter the data into the relevant cells on the relevant worksheets. I think the form should be quite self explanatory.

View 6 Replies View Related

Adding More Pages To A MultiPage Form

Mar 30, 2009

I am trying to add more pages to the mulitpage form in the toolbox. How to add more "Pages" to the Multipage form?

View 2 Replies View Related

Adding Worksheet Protection But Allowing Form Controls - Macros

Jun 5, 2014

I have a worksheet with lots of things going on... the end user needs access to the Name field, DOB field, all the scroll and form control option buttons in the 9-question sheet, and the macro-enabled reset button at the bottom. Formulas are sprinkled throughout the worksheet, in columns T through AC... option button links go to AA and AB.

I would like to protect the entire sheet so none of the fields, except where indicated above, could be selected or edited... but when I protect the sheet, I get errors when trying to use you form controls, and the formulas do not respond. And finally, when protected, I get a debug error on the reset macro.

View 2 Replies View Related

Compile Error - Adding Record To Excel Spreadsheet Via A Form

Jul 15, 2014

I'm trying to tweak this code from a previous form I created but I'm getting a compile error message. On my old form...the first box was a combo list box where the person entering data would select a value. On the new form, its a text box where the person will enter the value. I thought I could just change the me.cbo[name].listindex to me.tbo[name].listindex - but that seems to be causing the issue. I'm not sure what I would put after the me.tbo[name]. to get the code to run...

Code:

Private Sub cmdAdd_Click()Dim lRow As LongDim lPart As LongDim ws As WorksheetSet ws = Worksheets("DataNEW")'find first empty row in databaselRow = ws.Cells(Rows.Count, 1) _ .End(xlUp).Offset(1, 0).RowlPart = Me.tboProdCode.ListIndex

View 8 Replies View Related

Creating A Purchase Order Form That Will Reduce Time Spent Adding?

Apr 18, 2013

I'm creating a Purchase Order Form that will reduce time spent adding in contact details.What I'm looking to achieve is a form that will be printed with a few formulas allowing sections of the form to be filled out automatically once a singular company name (chosen from a drop-down list I created, currently with a 'Combo box ActiveX') then the rest of the form is filled out accordingly.

At the moment it's a bit of a mess, not too sure where I'm meant to put the ranges.There are currently 2 sheets - Sheet 1 with the form, Sheet 2 with all contact information.

View 1 Replies View Related

Adding Additional Goals And Objectives In Treatment Plan Using Form Control Button

Feb 25, 2014

Instead of having the goals and objectives already in the form I would like to have buttons that would allow my clinicians to add as many goals and objectives as they'd like to the attached treatment plan. I'd like them to be able to click a delete button as well when they review the plan and need to delete a goal that's been met. When my team clicks into the second worksheet they would see rows 10-16 (below). They would then type a STG 1 and an Obj A. They then would click the Add Obj button and add as many objectives that they needed. Then when they clicked the add goal button a blank copy of rows 10-16 (including the Add Obj button) would pasted one row down and would update to read STG 2. Neither of these buttons would appear when the document printed.

Here is a screen scrape of what I'd like the attached form to look like before goals and objectives are added.

add goal.jpg

The original form is saved in an .xltm format but I saved it in an .xlsm format so I could upload it here.

HCT ITP (2-25-14) Abbr.xlsm

I found a thread on this forum that came close to answering my question but my attempts to pull out the coding that I needed was unsuccessful. Here's a link to the thread: [URL] ........

View 14 Replies View Related

Deleting Rows Using A Form

Jun 10, 2007

I have a combo box which I can select names from and I want the form to delete all the details associated with that name when I click my command button.

View 9 Replies View Related

Print Specific Rows To A Form

Nov 9, 2007

I found a code which is very useful for my project, I have somehow copied the coding and tried to use it, however, I seek help to accomplish it. My question is as follows:-

I have 3 forms,namely PO1,PO2 & PO3. All the data is extracted from the spreadsheet, how do I call up the PO2 form if the row selected is PO2? Attached is my file for better understanding.

View 10 Replies View Related

Use More Rows To Open User Form

Jan 15, 2010

Am working on a spreadsheet which has two sheets, one for the visual interface and another for the data, the data is displayed on a form, the form is opened by clicking on the cells.

Currently this is working for the top row of A5 to AA5 or 1-001 to 1-024, however when I try to include A8 to AA8 or 1-025 to 1-048 it fails.

See attached spread sheet for code
The problem parts are in;

Sheet1(Layout)
Private Sub Worksheet_BeforeDoubleClick.......

Form (Ports)
Private Sub UserForm_Activate()

How to include A8:AA8 and more when needed?

View 6 Replies View Related

Simple Macro To Group Rows For Form?

May 11, 2014

I am creating a new form, and have 2 option boxes. I have linked these checkboxes to a cell which gives a calculation depending on what is selected (cell E10). If the value of this cell is 2, then the person has selected that they don't need to fill in the details below. If this is the case then I would like to hid the entire rows below (rows 18 - 45 to be precise).

At the moment I have used data validation to blank out these rows, but I'd much rather group them automatically to avoid a large gap between the option boxes and the next section.

View 7 Replies View Related

Print Selected & Multiple Rows To A Form

Jul 12, 2008

The file consists of 3 sheets:Orders,Order Form PO1 & Purchase Order. When I mark "x" in the row that I want to print, Order Form PO1 will be displayed with all data in the specific columns. However, it only allows me to select one row at a time. Now, I want to select multiple rows so that it will pass the data to the sheet Purchase Order.

View 13 Replies View Related

Form Control To Grey Out Unused Rows

Nov 8, 2009

Is there a macro that will format unused rows or with no value in a given range. I have a sheet that I am using that some of the date is either added or deleted and would like to have a macro to do grey out unused rows. I am using this with a form control.

View 3 Replies View Related

Transfer Rows Form One Sheet To Another Automatically

Sep 4, 2008

i need a little help. I have a workbook with 2 sheets. I need rows to transfer to the first sheet automatcily if the record dose not already exsist on the first sheet based on if a vaule in a certin cell is below a certin number.

View 9 Replies View Related

Adding 2 Rows After Every One Row

Jan 29, 2009

I need some help fomulating a VSB code which would add two rows after every one row.

View 7 Replies View Related

Adding Rows With VBA

Apr 18, 2008

We have workook with several worksheets (tabs). The main page has several headings (category), including "Doors and Ceilings", "Walls" etc. There are currently three rows under each heading. When I go to a category (tab) there is a list of issues in column b. I can go to column A of each issue and if I place an "a" that issue will be copied to the main page under that category. The problem is that i only have 3 rows and I need a row added each time an issue is transferred to the cell before it.

Is there some VBA I can use to detect the precence of data anbd add a row?

View 9 Replies View Related

Adding Two Rows After Every Existing Row

Aug 7, 2009

Is there any way to automatically add two new rows after every existing row containing data?

For example

1 A B C
2 D E F
3 G H I

turn into

1 A B C
(empty row)
(empty row)
2 D E F
(empty row)
(empty row)
3 G H I

View 9 Replies View Related

Adding Rows With Data?

Mar 14, 2013

I have got a spread sheet (Attached) that works out the rankings of youth football teams so that they can be given fixtures against teams of the same ability. I want to use the same system for another age group which has nearly 100 teams in it but I can't get it to work for over 50 teams.

With my basic Excel knowledge I have worked out how to add extra columns with the correct formula, but I can't work out how to add rows with the correct formula to the table that is in cells A12 -C12 down.

Ideally I would also like this table to show the team with the highest ranking in position 1 & in descending order from there - but I would be more than happy just to add the extra rows for now.

View 5 Replies View Related

Adding Two Rows Together If They Have The Same Value In Column A

Oct 7, 2008

I've got an excel sheet which has names in column A followed by 5 numerical values in columns B-F. I'd like to get a macro that will compare the values in Column A and if they match, add the B values, the C values, the D values, the E values, and the F values and delete one row - effectively combining the row. What's the best way to go about this? Also the sheet is already in ascending alphabetical order by Column A, so the rows that need adding will be next to each other. So I guess compare each A value with the one below it and if they match add the rows, but how?

View 5 Replies View Related

Adding Conditional Rows

Jul 10, 2006

I want to be able to have rows/cells generated with a certain text
based on the answer given by a user.

For example, My question in a cell could be "how many groups have you made?".
Now to this if the user answers "3" then I would want three cells below to
ask "what is the name of your first group", "what is the name of your second
group" and so on.

View 11 Replies View Related

Updating By Adding New Rows

Mar 1, 2008

i have rows of data in an accounting worksheet (payments in/out) which needs constant updating by adding new rows. within the row a formula exists in column D such as =SUM(E11:J11) and the next row is =SUM(E12:J12). if i select row 12, right click and select insert, a new blank row 12 appears but without formula in column D. is it possible to insert row with retained formula? i would prefer to add a row from a blank row below current row and have new row appear with above rows formula but this is not vital.

View 12 Replies View Related

Adding Rows Automatically Using VBA

Jan 3, 2014

I have a spreadsheet where I will input details for "incidents" under different headings on one row per entry (I will have a separate tab for each "incident", and each row will relate to each customer affected by this incident)

For every row that is completed I have a "Summary", which is just a section of the same worksheet, that will list all the basic details of the above entries in a format that will be printed and passed to a different department.

As I will be unable to determine whether a particular incident will have 5 entries or 50, I need a way to add a new row to my "Summary" section if and when a row is completed.

I have a formula to populate the data in the "Summary" section automatically, so all I need now is for it to add new rows as and when they are needed, copying the formulas from the original row, so each new "incident" entry is copied each time.

I have created a dummy spreadsheet but I'm not sure how to attach it to this post.

View 5 Replies View Related

Adding Comments To Many Rows In Vba

Feb 15, 2007

Is any way to add automatically comments in VBA

Some combination of "ctrl" with something else.

View 3 Replies View Related

Create Order Form That Inserts Rows Based On Value In Column

Apr 11, 2014

I'm trying to make an order form that is based off of a price list. Basically there will be 200 items or so someone can just enter the quantity they want into a column. I would then like another sheet on the workbook to auto-populate all of the fields available. The thing I'm having trouble with is I don't want the finished form to be as long as the price list with blank rows in-between. I've been reading up to make a macro work for this, but have had no success.

View 3 Replies View Related

Excel 2010 :: Copying Data Form Columns To Rows?

Mar 27, 2012

I need something that will take data from columns in one Spreadsheet and put in difference cells in a row. I know this could be done with recording a macro but the number of column will never be constant.

Below I attached examples of the Spreadsheet

Financials SpreadSheet
Need to have the data in column B to F put their respective cells in row in the
Master Spreadsheet
So we would have 5 rows.

Excel 2010ABCDEFGH5Job Number17542000250030003500Total6Date Booked01-Mar-1215-Mar-1215-Mar-1223-Mar-1223-Mar-127SalespersonJames ThorntonHoward StandenHoward StandenIan BullimoreSylvia Walton8AdvertiserNestleTalkTalkLloyds BankSkodaHonda9ProductNature ValleyBroadbandMortgageApril

[Code]....

View 6 Replies View Related

Formula For Adding 12.5% Onto Multiple Rows?

Apr 25, 2014

I have a quotation that I am working on that I need to add 12.5% onto each seperate line price.

There are 300 individual lines on the quote all with different pricing but they all need 12.5% adding on so I am hoping there is a simple way to do a bulk sum for all of the rows rather than having to go through each row and creating a sum for each. - ie =(K28*1.125)

View 3 Replies View Related

Adding Rows To Sheets With 3D Referencing?

Jun 13, 2013

I have attached a file for reference. I have another file I use that is similar to the one attached, however it has 500+ rows and is still growing. The issue I am having is that in this file I want to make a "Template" worksheet. Basically I need 50ish sheets that are more or less the same. I have a column that describes a item, a items weight, a row with headers for the columns that I want to appear identical on every worksheet. I want the variables to be the count. These will change from sheet to sheet with formulas to than update the totals.

My issue I am having is that I constantly find myself needing to insert new rows for new items. In my real worksheet I have rows grouped together in a logical way so the rows cannot just always be placed in the next available row at the end of a sheet. How I can have sheet 1 be my "template" and the others take their item lists and weights from sheet 1. In the example file I created sheet 1. I than created sheet 2 and selected a cell entered "=" and selected the cell that I want it to have the same info from on sheet one. I fill handled these items down to generate a list. I than held down control and dragged a couple of new sheets. This process works, and is what I am currently doing, but what do I do when I wish to add a new rob between row 4 & 5?

View 2 Replies View Related

Autofiltering Then Adding Value To Filtered Rows?

Jul 25, 2014

I am able to autofilter a sheet to show only rows with a date in Column U but no "x" in Column BC. Now I want to be able to put an "x" in BC in only the filtered rows. The purpose is if someone enters a date in Column U, the macro will show only those rows minus the rows that have already had an "x" added to BC.

For the most part I've gotten this to work using but it will also put an "x" in Column BC, row 3001 on down.

How can I get it to stop at the last row?

Cells.AutoFilter Field:=21, Criteria1:="<>"
Cells.AutoFilter Field:=55, Criteria1:="="
Columns(55).SpecialCells(xlCellTypeVisible).Value = "X"

View 5 Replies View Related

Adding Rows And Calculation To Macro

Nov 3, 2008

I am extending rows on a salary schedule. As you can see below, the rows include: Bargaining Unit (GP) Schedule(2A) Range(5) Step (A) Hourly (S) and the hourly wage(11.52)

GP,2A,5,A,H,11.52
GP,2A,5,B,H,11.82
GP,2A,5,C,H,12.17
GP,2A,5,D,H,12.5
GP,2A,5,E,H,12.88
GP,2A,5,F,H,13.22
GP,2A,5,G,H,13.61
GP,2A,5,J,H,14.18
GP,2A,5,K,H,14.71
GP,2A,5,L,H,15.26
GP,2A,5,M,H,15.83

The Steps currently go from A thru M but I need to add N thru Z and after step M there is a 3.75% increase for each step.

You can see that this is a csv file (comma delimited). All of the other info needs to autofill and only the new steps (N-Z) will change and the wage for each of the new steps. The last row is 2 decimal points.

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved