I am trying to have one cell automaticall input infromation based on another cell. For example, if A1 = 10, then I want B1 to automatically equal 20.
The formula I am using in B1 is as follows - =if(A1="10","20","")
I have 2 problems though:
1st - I don't want to put the furmula in any cell because other information is put in there also. I tried putting it in conditional format but I don't think it is meant for such usage. Also, I already have something in data validation. so I can't put anything there because to my knowledge you can only put one validation per cell.
2nd - I have multiple numbers (around 7) that I need to be automatically inputed along the columns.
I am looking to add a function to a current spreadsheet that writes the current date to a cell when another is updated. The sheets function is to have a user record when a particular action has been completed and then remind them after a given amount of time. The user is faced with an option to input a "1" to essentially "start the timer" and then the date that is automatically input by the code will be used to compare with the current date. I have tried the following on the Workbook_SheetChange sub
If ActiveCell.Column = 9 And ActiveCell.Value <> 1 Then ActiveCell.Offset(-1, 2).Value = Date End If
But cannot figure out how to eliminate user error. Let me explain. If a user enters a value (will only ever be a 1 to indicate "yes") into column 9 then the date appears in the correct place (two cells to the left) If however a user deletes a value then the date will update one cell too high!? I also thought of using a cell based if statement (if j7 = 1 then today() else "" but this only updates with todays value each time you open where I want the date to stay as the day the cell was updated. The date is going to be used as a way of working out when to change the original value of the cell in column 9 to "".
My company has an excel file that has our new customer's information (colum A & B are first & last name;Column C is customer email; Colum D is cutomer phone, ect...)
once that information has been entered we have another excel file that will load all of a customer's information, and then be pasted into a welcome letter into MS Word for their confirmation & emailed to them
The problem I'm running into, Is that I do not know how to populate my nex excel sheet with the info I want only from a specific line.
I would like to enter a line / row number (for example '6') and than have excel go to that file & copy/paste the name, phone, email, company name, ect. into my new excel sheet
I have one that works already, but the previous owner PW protected it & hid his formulas/macros, so I'm in a dead end now...
I would like to have a cell automatically change text based on a conditional formatting formula. When the cell color is red, or the formula is true, then display the word "Expired". Can a formula be devised using results from conditional formatting?
This is being used for expired CPR 2-year certifications. When the certification expires, the cell currently turns red (based on a cell formula) and I would also like the word "Expired" to replace the date.
I have a workbook with a single worksheet that has about 2000 rows, columns A, B, C, D, E & F Cells in colums A, B, C, E & F all have very different information in them, nothing is similar in any of those columns that I can base a criteria on. Cells in column D however will have 1 of about 18 possibilities in them
What I want to do is have another workbook with 18 worksheets, each worksheet named 1 of the 18 possibilities, and somehow magically pull the data from the first workbook and insert it into the correct worksheet in the second workbook, leaving the data in the first workbook intact.
I update the first workbook several times a day, adding and deleting from it so would need to update as it goes, or be able to run the update as and when needed.
My skills are limited to simple formulas inserted into cells and dragging them down!
I have an invoicing spreadsheet, what I want is to have a main working page and then tabs after separated by vendor, but save myself a bunch of manual work in the future.
I want to be able to work in the main tab and the other tabs automatically update with the new info.
So I want the macro to search the text in the first column and if it finds "AIM Land Services Ltd." then I want it to populate the appropriate tab, in this case "AIM", with all the respective information after it ie: A-O. But I dont want it to select any other vendors/ info.
This is what I have:
Sub MoveData() For Each cell In Range("A1:A1") ' Where to look for the date If cell.Value = "AIM Land Services Ltd." Then ' The date Range("A5:O350").Select ' What is the range to copy Selection.Copy ' Copy it Sheets("Invoice_Log").Select ' Select the Sheet it applies to Range("A5").Select ' Where to paste the data
I need to match data in cell A to cell B and then if they equal I need to copy the adjacent cell C to cell X . How do I set up a macro to do this automatically? I have over 5000 cells to compare and match up.. I have Office 2003.
I have a column C with different text in cells (item's title). Column D - relevant description for each of the items. 100+ rows.
Now, unfortunately, often a spreadsheet with items is updated with many new items. So I get a new spreadsheet with old and new items mixed. I need, somehow, to import descriptions of the old items (Column D of the old spreadsheet) to the new spreadsheet from old spreadsheet. So I want excel to look for old items in column A of the new spreadsheet and, once found, insert a description in the column B from old spreadsheet.
I've got a range of data in Column D approx 50,000 rows long and I need to go down this range and when theres a blank cell copy the info from the cell above. I've got some code which loops through this but I need to make sure I put "EOF and the bottom of the info to stop the loop. Is there a slicker way of writing this code?
Here is what I am trying to do with no luck so far.
If I type RS23U1R109000 in a cell A1, I want B1 to read the 5th letter or number and fill B1 with E86.
Example A1= RS23U1R109000 B1=E86 A1= RS23V1R109000 B1=E87 A1= RS23R1R109000 B1=E84
As you can see in my example, the 5th letter could be U,V,R or whatever, but I need cell B1 to read that letter and populate B1 with E86, E87, E84 or whatever.
my spreadsheet to return the word unit if cell a18=1 or the word units if its over 1 but i also want the cell to remain empty if there is nothing input into cell a18 is this possible
I have a sheet that counts stock, in cell I5 i have week 4s results in k5 week 5s. what I need is in cell N5 the number in I5 if their is no number in k5 but if k5 has a number in it I want that number in N5
I have about a 100 sheet workbook for a project my company has upcoming. All the sheets are numbered 1-100. I also have another sheet that has the description of each pay item on ROW B of the sheet. Well here's my question. I'm trying to get a function that i can just copy and paste in each sheet instead of changing the number on each sheet.
For instance...
I would be using =Descriptions!B2 for sheet 2, and then =Descriptions!B3 for sheet 3 and so on. My question is does anyone know how i can get the sheet name so then i could just copy and paste one function that would be like =Descriptions!B(SheetName)
So that way i can just copy and paste instead of having to change it each time. I found this function to get the sheet name but can't seem to incorporate it into the =Descriptions!B
Is it possible to extract certain info from one cell. Example in cell A I have a description of a product plus price I only need the price, The price has a $sign in front of it. Example below
I have over 2000 products so I was hoping I wouldn't half to go through one at a time. Is is possible to extract just price and place it into cell b.
1 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $22.50 Stock Quantity: 107 YD
2 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $28.50 Stock Quantity: 107 YD
3 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $19.50 Stock Quantity: 107 YD
4 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $119.50 Stock Quantity: 107 YD
5 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $67 Stock Quantity: 107 YD
6 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $89 Stock Quantity: 107 YD
7 "Damask 100% Silk Color: Creme Approx Width: 55"" Approx Rpt: V. 16, H. 13 Reproduction Circa: Late 16th Century Renaissance Revival Price $25.50 Stock Quantity: 107 YD
Table-1 B C D E F Adda Zakeera 1239987801310037 Ahmed Pur East 5559998803310042 Ahmed Pur East-2 8888874805510041 Arifwala 3545555805510045 Bahawalnagar 3336666802610046 Bahawalnagar-2 1257777806610038 Bahawalpur 2206666804410044 Bhakkar 2223333805610042
I want to arrange my data like Table-2. I have tried vlookup() formula, it worked but every time I puldown the formula I have to manually increase cell # (e.g) In the row of Adda Zakeera, I have 4 values. When I use vlookup() and drag it downward the values should be shown as in Table-2 under Adda Zakeera.
=VLOOKUP($D$2, Sheet1!$B$4:$AF$90,2,0)
Table-2 D E F G H I J Ahmed Pur EastAhmed Pur East-2 Adda ZakeeraBahawalnagarBahawalnagar-2BahawalpurBahawalpur-2 555 888 123 333 12548 2201#N/A 555 888 9987 333 77777 66666#N/A
I have a long spreadsheet that is formatted and organized with six digit codes on the left, and then several lines of information on the right, in order to sort and compare to another report, I was trying to replace the blanks in the digits on the left....
What I'm trying to put together is a sheet where i work out how much margin i will be making on a sale (which i done). The bit I'm stuck with is the recording the data on a separate sheet.
What i have done so far. I created a Macro button to insert and copy cells C6, C7 & C8 (the bits i need). Which works but it takes the formular with it so everytime i chage the figure on sheet 1 it changes in sheet 2.
So what i'm asking is there a way to mirror what is display rather that copy?
I created a small block of cells on my worksheet where i have in separate cells, the day of the week, the days date and the month. I want to design a special memory calendar for my mom in early stages alzheimers.
There are cells with specific info which i do not want to re type for the whole month/year.
I want to be able to copy all the info into another block of cells and have the day of the week and date change also the month.
Whenever I get information from finance.yahoo.com or from my job and put it into excel all the information seems to go in one cell and numerous rows. (I think its b/c I am putting information that isnt' meant to be in excel and forcing it to open up there.)
For Example in cell A1 I will have "AIG , AMER INTL GROUP I , 66.08 , 1:16pm , 169.455B , 16.736 , 2.01 , 9.47 , 0.78"
Cell A2 I will have GOOG , GOOGLE , 508.9 , 1:21pm , 158.845B , 22.361 , 17.511 , 26.29 , 1
What I want to see is cell A1 as AIG and cell B1 as 66.08 and cell A2 - GOOG and cell B2 508.9. I don't even want the rest of the stuff.
Is there any way or formula I can use to just pull the information out of cell and have it separated for me?
I want to take all the numbers that have the ending tag "-XX" that are LETTERED but NOT the numbered combo (just like example 13538-AL) and remove the tag to just have the root 5-digit number.
I have all the end tag combos I would like removed. SO if I needed -AL, -LG, -CG, -SS, etc. removed, I would need the formula that would find all the 5-digit numbers with those end tags and remove those tags, leaving the other numbers alone.
I want to be able to change 2 cell info based on 4 checkboxes used. So based on a check box i check, it will populate what info i assigned to it the box. See below,
1 cell12342 cell
I have 4 checkboxes and 2 cells i need populated by whatver box i check. I have the following formula, but not sure how to tie in all the cells together.
=IF(A1,"Checked message",") If 1 CELL gets changed when checked, i need 2 CELL to change as well. Example, I checked box one and so 1CELL should change to, lets say to a set dollar amount like $12, and then 2CELL would also change to another entry say a set dollar amount, like $15 or whatever both based on checkbox one. BUT i also want to populate those same 2 cells with different amounts if i check the other boxes.
Usually you press the enter key or any of the arrow key to enter cell information. Is is possible to press a commandbutton to enter the cell information and perform some operations without pressing the enterbutton first?
In the Yellow Cells, I am looking for a formula or Macro that will automatically recognise and give the correct Premises number. As an example, in the first block of Yellow cells, it should be MOR001&2; The second block should be MOR003 and so on...
One could copy and paste the Premises number for each premises, but with 100 entries or more, it becomes a tedious and time consuming task. An autonomous function to recognise the correct premises number would be much easier
In the end, this is to be used when drawing up a PIVOT so that one may easily pick up a premises number or numbers and their related charges
