Hello, I do alot of repetitive work and looking for away to auto fill a row with the last entries I entered based off of a name in the Second column. Every day I need to enter in the same values, but sometimes one value changes and stays for awhile. So I would like to populate from the last...
I need aformula that will auto populate like this:
If A1 shows “M”,then auto populate in A2 “T”,
or “T” , “W”,
or “Th”, “F”,
and so on.
I was tryingto write an “IF” statement, and then a VLOOKUP, but I am not good at writingthese formulas. Could anyone assist in helping write this.
I have a sheet "Planner" where I can input the holidays taken by employees. All these sheets currently work fine as they are if I were to input data manually.
What I am looking to do is auto populate sheet "Holiday Overview" cells C4:N28 with the hours holiday taken which is based on the...
I am creating a rather small excel sheet. Only 4 columns, but it will become quite lengthy. I need a check box in it to use as the case goes to Appeal status. So, what I would like to do is for that check box, which I will have in column 1A. But once I enter a name in column 1B, I would like a...
I'm in desperate need for a unction/rule.
So, (this is embarrassing) a bunch of people are imputing dates in column G in a spread sheet; they are all different dates. These people need these dates plus 6 months to auto populate in column F.
For instance: column G is 04/30/18...
Hi Guys. I am new to this forum, and not sure how to place my actual excel cells in here...
Ok. So I will explain as best I can, I am after a formula (not a macro) to Take player preference and auto-generate a list; in this example, there are only 2 rewards and only 5 rewards available each...
I have check boxes in one column on a form. When the user inserts a row I want the check box to populate as well in that new row in the same column as where the others are now. Is there a way to do that?
Side Note: I already have a conditional formatting formula to shade alternate rows when...
I have a list of QA Analyst, and a number of how many audits they need to complete. I then have another list of advisors that need to be audited.
I want to apply the QA Analysts name next to the advisors names the exact number of times that the first list says they need to audit.
I'm not sure...
I have a table that tracks a bunch of info such as, person, category, department, description, due date, and priority. I have, at best, extremely weak VBA skills, so I REALLY need help.
Here is what I'd like to do, if it's even possible.
I would like to have a VBA code that will...
I have a workbook with multiple sheets. I would like to learn how to set up my dashboard so that I can enter data on it, then have the data fill in the first open row on the spreadsheet. The spreadsheet has 17 columns of data with 2 blank columns after the 5th and 9th columns of information...
I need help figuring out how to auto populate a cell based on a phrase or text in another. So, for example:
If I put 'Replace VCT in doorway' in A1, I would like 'TWO' to automatically appear in B1.
Would it be easier for me to do this in Access and then export it to excel? Either...
I am trying to auto populate column B with number '1000' when column E is filled with data, for which I am using formula =IF(E2="","","1000") But this is not giving me the result I wanted.
You help in this will be greatly appreciated.
I am trying to combine these 2 code lines to accomplish a drop down list with suggestive text. That also auto populates other cells when a menu is selected it populates menu items. The suggestive text works well but I'm a bit stumped on how to go about adding the auto population of the cells...
Okay so I have a speadsheet with 8 columns which are:
A - Name of Customer
B - Date of Sale
C - Month of Sale
D - Cost
E - Sell
F - Margin
G - Profit
H - Description
I want to auto populate Column H when I type in the name of the customer in Column A.
In Description I have a...
I am trying to determine if there is a way to create a workbook template for a sales quote that references other workbooks. In other words, is there a way to automate the population of data fields (eg. supplier, cost, description) when a manufacturer product number is entered into a...
I'm trying to figure out how to populate Sheet 2 (Item 1) with the information from Sheet 1 (Submittals log) Row 6 automatically. I'd like a new sheet created for each item in Column A with the same format as the Sheet 2, but with the information for the next Row down (Item 2) and I'd like the...
I got a excel data as follows:
Loan Acc no
Context of problem: I am trying to quantify lengths of fencing along a road into excel. I type the extents of the fencing into Table 1.
Note that Start & End represents the location on the road. So for example, a fencing which starts at location "90" and runs to location "95" is 5...
I am looking to auto populate a spread sheet using multiple drop down lists, 4 to be exact. It is a dimensional drawing of a tool, where the dimensions will change when a different size and weight and material is selected from the drop down list.
Please let me know if you can help me out...
Hi I am now trying to create a excel macro to auto populate all the dates with reference to a start date and end date. The catch is that only working days are required in the range. My reference cells (start and end date) are in Sheet 1 while the destination cell range are in Sheet 2. The reason...