I need a formula that will take the value of one cell and put it in another cell other than the one in which I am typing the formula. I can't think of how to do this.
I have two columns, A & B (no headers), of information. The columns are not identical, and column B has empty cells scattered throughout the column. For each empty cell in column B, I want to copy the same row of information into it from column A, as if I'm just scooting the information in column A that's on the same row as the empty cells in column B.
This is simple with a cut/paste, but when there's thirty empty cells, cutting and pasting takes time. (What's really frustrating is that I've figured out a few formulas that will copy the information from column A but all the information gets pasted in the column in which I'm creating the formula (say, column F, for example). THAT doesn't help me because the empty cells in column b are still empty!)
I am trying to move a column of numbers based on the information in another column. I've been looking for about a week and find macros that are close but not quite.
In one column it reads Mobile, Home, or is blank. If the number is a Mobile (column R), the area code (column P) needs to move to column S and the phone (column Q) needs to move to column T and the primary phone (column R) needs to move to column U. Home and blank cells remain as they are.
area (P) phone (Q) primary phone (R) col S col T col U
is there a way to stick a few row of cells together so that when i move one they all move.. i have some rows that when i sort them i want them to move together with the other ones..
I have a "surplus inventory" sheet and a "inventory shipped" sheet. How can I input how much I shipped in the "inventory shipped" sheet and make it take away from my "surplus inventory" sheet automatiaclly?
I am trying to recall info from the rows in another part of a worksheet when I type the first column. For example, I have over 300 rows of:
Apples 155 12oz red Orange 120 10oz orange Banana 50 11oz yellow etc.
I want to select or type only the word:
Apples
And have the rest of the columns fill in with the rest of the info, like so:
Apples 155 12oz red
A filter would work well to select, except I need about 7 in the worksheet as it is a form and excel only allows one. I can’t seem to make the advanced filter work. An IF function would work, except I'd have to put all the words to match in " " marks, which would be very time consuming.
how I can recall the info from my list to the 7 lines I need to copy them into?
how to use vba in excell. First question. 1) I have a spreadsheet with names in column one and other info in columns B-I. I would like to make excell do the following. If I enter the name a second time and so on, then can excel take the info out of certain cells from the first entry? Say column C, D, and G and auto enter them for this new row. 2) can I copy parts of a sheet to a new sheet and then when I make changes or new entries then they will update the copied sheets info?
i have this code that gives me 1st row of data , from Row 10 of every sheet in workbook, how can i modify to give me row 11 ,12,13,14,15,16 as well upto row 21 if there is Data in Col C ( max range is C10:C21) ,
For intX = 1 To Sheets.Count For intY = LBound(arySkipSheets) To UBound(arySkipSheets) If Sheets(intX).Name = "MachCapRpt" Or Sheets(intX).Name = "MachAdSht" Or Sheets(intX).Name = "Times" Or Sheets(intX).Name = "MachSchd" Then Else .Range("A" & intNextRow).Value = Sheets(intX).Name .Range("B" & intNextRow).Value = Sheets(intX).Range("B10") .Range("C" & intNextRow).Value = Sheets(intX).Range("C10") .Range("D" & intNextRow).Value = Sheets(intX).Range("E10") .Range("E" & intNextRow).Value = Sheets(intX).Range("H10") .Range("F" & intNextRow).Value = Sheets(intX).Range("M10") .Range("G" & intNextRow).Value = Sheets(intX).Range("W10")..............
How to return the value of what i looking up. for example i want to find the value of A1 from a range of B1:B10 if A1 is B1 then it return the value beside B1 for example the value of B1 is C1
I have a spreadsheet with info about students in a summer program. I need to pull out the students who have allergies along with what their allergy is and their emergency contact phone number. I would like this new info in a new spreadsheet.
Here is an example of the spreadsheet:
allergiesnamephoneallergy type nobob410.555.1234 nojim410.555.5843 yesmeg410.555.7458nuts nolex410.555.1159 yeswill410.555.5005fish
I'm copying and pasting data from a PDF and need to eliminate some unnecessary data. The original .pdf has 4 columns: Account, Dollar Amount, Name, Notes
When I copy this to an excel document, it copies the row from all 4 columns into column A. The two columns I need are Account and Dollar Amount. All account numbers are 8 digits so I was able to create a formula to weed that out with this: =left(A1,8)
The problem I'm running into is obtaining the dollar amount within the cell. For example:
A1 contains: 11112222 $1234.56 Sample, Name Sample Note
I pull the 11112222 with =left(A1,8) in column B but not sure how to pull dollar amount to column C.
Further, the dollar amount varies from $1.01 to $10,000+
The spreadsheet is used to keep track of shares that are purchased / sold
It will make all tax calculations as well as provide a single statement showing all transactions rather than having to sort through dozens of individual statements.
I seem to have most of it working but could use some help with the following.
I would like to be able to have a spot (maybe on a separate worksheet) where you could enter the four items from which everything else is derived, share price, date, number of shares and whether it was a purchase or a sale, and have it automatically:
1. add a new row (complete with formulas and formatting info) to display the new information
2. sort the new data to fit into the right spot in the spreadsheet by date.
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
I need to sort information in a column containing both numbers and words. In the "asending" & "desending" it only gives two options to choose from. (none) & PartNum.
Above is a small example of 2 of the columns, most addresses are in 3 columns.
The postcode can appear at the front, end or anywhere in the address field. Depends on who typed it in. I need to somehow extract the postcode and have it in a separate column.
Text to columns wont work i think because the info isnt uniform, I've tried the search for the various postcode starting letters but still cannot extract the entire postcode.
I have tab1 with (master list with contact name) and tab2 (list with no conact name)
i want to have formula or macro that llnks the contact persons name with the company name, address, city, and state.
i know copy and paste--but thats not what will work..this is an example worksheet, the real verson will have thousand of line of data and i would like to creat a link or formula..
Can this problem work in excel or is this more on an access promblem? in where i need to build a database...
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
a little task that I'm trying to accomplish. twice a day, a coworker of mine puts out a report on all the jobs we have going for the next couple of days. I paste her report into my own, hide the columns I don't care about, and format the way I like, and add in column U, which holds my comments about the job. It ends up looking something like this:
escelex1.PNG
Later that afternoon, I get the updated copy of her report, in which the B number and customer name always stay the same, but some of the info might change, for example the HOLD column, or the boards or sten columns might change.
What I would like to do is to paste in the afternoon copy of the report, and to have excel merge duplicate rows in such a way that I have the afternoon information from her report (columns B-Q) and keep the comments that I had put in the morning record's row.
When I paste her afternoon report into my spreadsheet, I get duplicate entries looking like this: escelex2.PNG
But I want to be able to merge the data, so that it looks like this: escelex3.PNG
Does that make sense? I want the afternoon version of the data, with no duplicates, but I don't want to delete the comments that I put in in the morning (which is what the "remove duplicates" button is doing)
I need to make a macro to get sales information from sheet one to sheet 2 in a different order with a few other things that need to be added in everything I need is in sheet 2.
Sheet 1 is what I work with and I need it to look like sheet 2 using a macro I wrote what I need in sheet 2A13-...
Below is my current code. I created this to work for a spreadsheet I had. Works mint. Then I use in another spreadsheet which is almost identical but has less rows. Everything works, but then im left with a bunch of extra rows that have DIV error. Rather than select range 2:34, is there a way to select the entire column, and autofill only if the column next to it has a number in it?