I have my code below. I need to "auto fill" my formulas in cells H2:P2 down until it hits the first blank row. Unfortunately, the code I'm using will auto fill until the last row used in the sheet. I have inserted a blank row between data where I would need the code to stop. I have it...
I have this code I have been using which fills up a textbox dependent on a selection from a combobox. Currently I have been trying to modify it to be able to fill the textbox based on the selection from the combination of 2 or more comboboxes. For example, if I have:
ComboBox1 = First...
Any help with the following problem would be greatly appreciated.
So I have 2 seperate workbooks (not sheets) 1 & 2).
Hello Forum Members,
I need some help how to get an order form prepared.
I have a worksheet full of data. In column A all the product names, col B has all the colors for each product available, col C has all the variations. Each on different row. I want to have another sheet where I could start...
Does anyone have a suggestion how to go about populating and maintaining client ws's from a host, or master ws of data? The table below is what the master worksheet will look like and contain.
I need to figure out how to auto-populate / maintain:
In a CS1 ws the details about Project 1 &...
I have created a spreadsheet in excel. It will contain the following columns:
I would like to eventually convert this spreadsheet to a table, but for now it is...
Hello everyone i have created a userform AND now the issue is i need a code TO autofill or autosuggest text in the textbox, for example if i have already entered text 'JOHN' and next time if i type J it should suggest me JOHN. is there any vba code for that pls help me as i need to submit my...
Good morning all!
so my question is about auto fill I'm not sure if this is even possible or not, but what i have done was built a basic tracking log for personnel on a job site i am on. basically i open a blank one every day and save as and add new date.
my columns are listed as such across...
Looking some help in excel formula (not macros). I have group of units based on their sizes. e.g. type X=2 units, type Y=1 units, Z=3 units and so on filled in excel as below;
so based on the value in column B as above, I want all...
I have an excel sheet with time-series data for several items, where each row represents a different year. Something like this:
Item Var 1 Var 2 ...
A 5 10
A 6 10
A 8 20
B 1 33.7
B 2 29
B 0 24
I have a list of people that need to be sent letters. I have already created a form that will poplulate the letter based on the information input manually. I would like to take it to the next level but auto popluating the letter but pulling information from the data provided in a spread...
Working on a travel spreadsheet in Office 2010
1st tab that I will insert State and City, that will need to auto fill another cell on that row with daily allowance * number of days cell (also on in that row)
2nd tab has reference information in each ROW.
Oh yeah and in the city and state...
I have been racking my brain on this for weeks and got precisely no where so I wonder if any of you guys may be able to suggest something.
I have a complected spreadsheet using multiple pages with various formulas pulling all the data together.
I have simplified my problem here but on one page...
Guys and gals, I'm going to try to keep this as simple as possible for you. I need to do something for work that will make everyone at work love me. I can't begin to try to explain to Google what it is I'm looking for, so here I am. My first thread post for any site. Ever.
I have two vertical...
I am trying to set auto fill in Column L. L1 I have =f1, L2 I have =j1, L3 I have =f2, L4 I have =j2. I want this to continue down the L's but the auto fill wont work. I want it to progress =f1 =j1 =f2 =j2 =f3 =j3 =f4 =j4 and so on. Instead it is jumping cells. How do I fix this?
Hi. I use Excel 2010. I want to write some code that will look at the cell in column A. If the cell is not blank, then the column B value will fill in with the current date. Is there a way to just write the code to get the current date to autofill downward in Column B until column A is blank...
I currently don’t have any experience with using the check box function so I am looking for so I'm biting the bullet and asking for some help!
I have 3 check boxes in G5 one of which is call "N/A".
What I would like to do is:
If the "N/A box" is checked then cells C5, D5 and E5 will auto fill...