populate data

okay, so I constructed a loop to populate a range of cells based on the value of checkboxes in a userform. Now I'm trying to do the reverse. have the userform on activation mark the checkboxes according to the range it filled prior. Here is the working loop from form to worksheet: Dim k As...

I am trying to create a personal budget management spreadsheet. Ideally it would be like this: On the first worksheet I would make a table, on column A I would list the various expenses (for example rent, electricity, transport etc) and on line 1 the months of the year, leaving A1...

Hi i have 3 comboboxes and want the last to to read a different Worksheet dependent on what the input is in the first combobox is this possible and if so how is it done ?? the code i have so far is: Private Sub UserForm_Initialize() Dim Site As Range Dim Location As Range Dim Printer_Type As...

Hi I am new to this forum, and would like to get help on the usage of array inside a combo. I am tring to populate a combo box (single coulmn) with an array (dynamically created) . But Iam not sure how to do it. Would like to get get help from this forum I am trying to get something like...

Hi, I want data to populate on "sheet 2", from "sheet 1". That means that when I insert a new row in "sheet 1", I want "sheet 2" to display the data that has been entered into the newly inserted row on "sheet 1", without having to re-enter the formulas in "sheet 2". I'm fairly macro -...

I am using a basic excel book with many sheets holding reference data. What I want to accomplish is, as I go through each sheet and mark a column beside data I need to pull at that time with say an "X", how can I create a formula on a separate sheet that will compile all the data I marked with...

I have a contract in an excel worksheet and a list of 50 names in a database (in Column A). is there a way to duplicate the contract to make 50 tabs with each contract having the persons name from the database? e.g Contract 1; Mr Smith Contract 2; Mr Brown the name need to populate in...

Trying to create a form where the Combo Box "cboCourse" is loaded from a sheet "CourseInfo". There are 2 ranges "CLkup" containing 2 columns txtCourse and txtTbox and "Database" containing all the columns in the "CourseInfo". Currently my combo box is working thru the properties option...

Hi. I am trying to tote up Incidences of Use in a stats spreadsheet but keep getting the #VALUE! error. The cells in question follow =F79+F113+F117+F124+F167+F176+F180+F184+F190+F220+F232+F238+F242+F248 The content of cells indicated in table below Title of cell...