populate

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...

Hello, I have a workbook in which I would like to have some headers populated by simply filling in some cells with text then hitting a macro button to populate the headers of multiple sheets automatically. The headers already have some text in them which need to remain. i have snip images of...

I am using 2 embedded IF statements in the attempt to produce either a string (cell&cell...) or a string with -SPARE are the end. I know the inner IF statement works as expected. The result is setup to work on the FALSE, not TRUE for desired output. My outer IF works when I do not include the...

Hi, I've been trying unsuccessfully to populate a table (T2) with info from a table (T1), perhaps using an 'x' or 'y' to show which student is on which course. T1 is: <tbody> StudentID Course a1 French a2 Math a3 English a4 Science a5 French a6 English a1 Science a3 French...

This is my formula that returns the 1st value but I need to return the data from the 2nd and so on. My project is to pull data to populate invoices based on the invoice number. =VLOOKUP(value(rngInvoice),Received_Process, 2,false)

Hi all, Formula in cell AN1 if cell T5 is blank return last value in column AL, otherwise use user defined function to get result <Dim lr As Long lr = Cells(Rows.Count, 38).End(xlUp).Row Range("AN1").FormulaR1C1 = _ "=IF(R5C20="""",RC[-2] & lr,'abc def...

Hi one and all. I'm new to Excel, so fairly inept with formula etc. I had done a search of questions asked, and found a question that nearly but not quite hit the point. The question posed by 'cmendes on May 18th 2011. What I'm trying to do is to populate cell A1 with AAAA, then autofill...

I'm hoping someone can help me. I have a 100 inputs and 100 outputs I populate column A with inputs and column B with outputs. Column C will contain data that will match to one cell in column A I want Column D to populate with the corresponding output from Column B. Is there an easy way to...

Hello everyone, My computer is Dell and my operating system is Windows 10. My goal is to be able to paste numbers in cells (in this example cells D2 to H2) and have appropriate numbers populate the target cells (cells above and below colored cells). I don't know the appropriate terminology to...

Hello So I have 3 fields E26, E27, E28 What formula can I use to do the following: Check to see if there is a value in any of the cells and if there is a value in one cell populate E25 with a "YES" Thanks in advance

Hi all I'm wondering if you could help or at least suggest options. I have looked through loads of threads and have been able to add rows using a message box but I need to then autofill them cells added with a sequence. Sub MyInsertRows() Application.DisplayAlerts = False...

Hi everyone. I'm trying to figure out how to put excel text in column range with reference. Like if columns B2:B10 as text on it, column A will populate on from A2:A10. Appreciate everyone's assistance. best

I have three columns. Only one cell in column A will have a value, which will be "Active". Column B is locations. In column C I'm trying to get anything that at or below the "Active" indicator to populate as "Down" and anything above the "Active" marker to populate as "Up". <tbody> Minn Up...

Evening. My information is on the worksheet called INFO On the INFO worksheet we have the following, Names in column CV Address in column CX Paid in column CZ Mileage in column DB Current range on the INFO worksheet is CV2:DB16 Overtime this range will increase down the page. I have a...

Dear All, I would like to populate strings based on the SKU & Store combinations. The count of strings will be equal to # SKUs(Unique Count) X # Stores. The strings could go into thousands/lakhs of rows. I have the following sample data set across A1:B5. IN A Column I have 3 Unique Count of SKUs...

We have a Workbook we use to populate an Employee Time Sheet using a User form. We open a userform and populate that form which also uses drop down boxes that look at standard data on other sheets of wookbook. Pressing enter the appropriate line is filled in on the time sheet. We then can...

I have been looking for a VBA code that will basically take information from my worksheet and create a new sheet for every row. I have a template that I would like my data to autopopulate so that each new sheet is in the specific format I would like it in. anyone know how to do this?

I have data in coulmns C and D. I want to calculate the percent difference between th ehighest and lowest valueevery five days and have that value populate in the adjacent column/cell E. Is there a formula to help me do this? As in this example the percent change form the highest vale 8.2 to the...

Good evening all, I have a two tab excel workbook. The first tab as a list of sequencial numbers (house numbers) in one column and a list of mulitple items across. The second tab is editable and i want to freely input house numbers in say A1,A2,A3 etc.. and a item description against each in...

Good morning, i am in the process of trying to get a training calendar built which i already have the calendar part done so that when i change the year on first month it updates it for the year. my next task of trying to figure out is if there is any way to auto populate the information for the...