Getting Sheet Name And Info From Cell
Mar 5, 2009
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
View 4 Replies
ADVERTISEMENT
May 12, 2014
I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?
View 3 Replies
View Related
Jun 26, 2012
I am wanting to transfer data from one sheet to another depending on cell input
Example:
If I enter "2" in sheet1 cell B1, then I want a macro to take A1 to sheet2 but place it in A1 & A2.
Then say I enter "1" in sheet1 cell B2 goto sheet2 and put A2 into A3 and so on.
Depending on the number entered on sheet1 column B, the Macro duplicates the info from Column A in that row into column A on sheet2. ??
View 5 Replies
View Related
Oct 3, 2012
I have been trying for months to get this to work by altering code from similar requests I've hunted down on google to no avail.
I am looking to have a "Master" sheet that is populated by data from 30+ individual excel workbooks. Each workbook is contained on a server in a directory "O:JobsJobs In Progress." In that directory are subfolders (named in sequence "C12000 Job1", "C12001 Job2", etc) which contain the actual workbook (Named according to number ie. "C12000 Jobinfo").
I would like this "Master" to automatically pull specific values from each C1200* workbook and paste them in a designated cell so that I can quickly look at specific information contained in each workbook. Each C1200* workbook is constructed the same way.
Short Example of C1200* workbook in which data will be pulled from:
Job Number
C12000
PM
Abe Lincoln
Foreman
Thomas Edison
Contract Date
1/1/10
View 1 Replies
View Related
Jun 18, 2013
Here is an example of my spreadsheet: Excel example.xlsx
I would like to get all the bid/ask quotes for the different currency pairs in sheet 2 into sheet 1 sorted by the right date and time.
I need a formula which recognize the time + the currency from sheet 1 and search for it in sheet 2 then brings the right bid/ask quote back into sheet 1.
View 2 Replies
View Related
Sep 24, 2007
I have a workbook with a Cost Analysis sheet, a master menu sheet, and then all the sub sheets. I have coded command buttons on the master sheet, so once a category is selected, it goes to the appropriate sub sheet. On the subsheet is a list of items of varying sizes, and command buttons beside that which will allow the user to "Select" that particular size. Once the size is selected, the verbage in cell B5 plus the verbage (size) beside the selected amount, and the prices (labor and materials) in the next two columns, need to be transferred to the first available blank line, starting with line C5, to the Cost Analysis sheet. I have never done coding before for a Loop (i.e. For i = ???) and am not sure how to get it to do what I want. After they select that, they can pick a command button that takes them back to the master menu so they can continue picking various items until they are through. Then the Cost Analysis sheet will show all the items they picked, (name of item, material cost and labor cost: Columns B, C, & D). Not everything is coded yet (such as selecting a command button to go back to the main menu, because I wanted to make sure I could solve this problem before doing the easy stuff).
I read over quite a few of the previous threads and am not sure how to change them to suit my circumstance. I know some code (VB), but not much. I do not understand the concept of DIM, and how the loop works to make it happen myself, and all the websites I could find were not suited to my situation of copying three cells of data to the first blank cell on another sheet.
View 9 Replies
View Related
Feb 16, 2008
I have a list box that I'm using to pull customer information from my "Customer" sheet to my "Invoice" sheet. I can actually open, select, and close the userform. However, I can't get the macro to put the information into the specified location on my "Invoice" sheet.
Here's my code so far:
Private Sub Cancel_Click()
Application.ScreenUpdating = False
Unload Me
End Sub
Private Sub customer_Change()
End Sub
Here is the "Customer" sheet I'm pulling the info from:
And here is the location on the "Invoice" sheet that I'm trying to direct the userform to:
And here's my userform just for reference:
The userform works perfectly until I press the OK button. That's when I get the error.
View 9 Replies
View Related
May 11, 2012
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?
View 7 Replies
View Related
May 29, 2007
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-...
View 14 Replies
View Related
Dec 13, 2011
how to move info from one sheet to another in the same workbook? Sheet one has several columns, including company name. Sheet two has company name and phone number. Not all the companies on sheet two are on sheet one (1500 on sheet 2, 200 on sheet one), so a sort-cut-paste won't do it.
If the company name is on sheet one, I need for it to get the corresponding phone number from sheet two and put it in the phone number column on sheet one.
View 1 Replies
View Related
Nov 12, 2006
I have sheets Sheet1, Sheet2, Sheet3 and Master in a workbook.
In sheet Master, I list Sheet1, Sheet2 and Sheet3 in range A1:A3. In range B1:B3 I want to return the date in which the sheet in A1:A3 was last updated. So everytime Sheet1 has changes, I want the date to be logged in B1. Same with Sheet2 (B2) and Sheet3 (B3).
I have tried writing the code but it returns errors.
View 9 Replies
View Related
Jul 13, 2006
I am creating a spreadsheet and I need it to recall info from another sheet. I dont know how to do this. The way I am designing it is so that sheet 1 has a spot to input a date, on the second page of the spreadsheet, will have a list of customers and due dates, if the date inputted on sheet 1 is past the date of their due date on sheet 2, I want their info to come up on sheet 1.
View 4 Replies
View Related
Dec 8, 2009
I have two sheets, the first is "Form" & the second is "Tracking". The "Form" sheet contains one button that, when clicked, brings up a userform. The userform has 11 checkboxes & two buttons ("View Next" & "View Previous"). The "Tracking" sheet has 11 columns (A - K), which will contain either "True" or "False".
I need the checkboxes in the userform to pull the values from the "Tracking" sheet. For example, the "Tracking" sheet has the following information listed: ....
View 8 Replies
View Related
Nov 16, 2012
I created a userform with 3 textboxes and 1 combobox. I want the user to be able to open the userform, fill it, save the information on a worksheet and email the userform information according to the combobox information. I've managed to do the email part. It's working great. The saving to the sheet part I just can't figure it out. I would like to textbox1 info in column A row 2, textbox 2 in column B row 2 and Textbox 3 in column C row 2 and comboboix info in column D row 2 . After, if the user opens the userform again, I want the same thing to happen but instead of row 2, row 3 and so on.
View 5 Replies
View Related
Jul 14, 2014
I would like to use the combo box to perform a search function. I have 4 columns of data and 2 sheets, The first column in sheet 1 is the "Name". By selecting the person name in the combo box, the data of that person would be shown in another sheet (sheet 2). And now I have a combo box in sheet 2. How can I do this using the combo box?
View 6 Replies
View Related
Aug 21, 2008
I have a document that has a sheet for each project, 3 at the moment. On this sheet are various text & currency fields, 24 in total.
I want to create an overview document for all of the projects so it will display lines from the individual project sheets that are currently showing as NOT complete.
To clarify I currently have 4 categories for status at the moment: Planning, In Progress, Awaiting Inspection Report, Complete. So I want my overview to show anything that is not complete.
I also have no need for all of the 24 columns in the overview either, I've highlighted about 9 at the moment.
I think maybe a lookup and If combination is my answer but I'm not altogether sure if there are other functions out there that I just haven't come across yet, or how to combine an if and lookup.
Also I would like the data to be sorted firstly by Inspection Location and then in date order if possible. I know I could use the auto filter option once the data is pulled across but it was be easier for the other users of this document whose skills range greatly.
View 3 Replies
View Related
Jun 16, 2006
I have 3 commission workbooks all with about 20-30 worksheets in them with each one listing the sales rep and a history of commissions owed/paid. I want to create a single workbook/worksheet where I have listed all the sales rep and the amount of commission they are currently owed without have to copy/paste or type it all in one at a time. How would I go about this??
View 8 Replies
View Related
Dec 4, 2013
So i have two sheets with user info and so on, my boss asked me if i can transfer person names from sheet1 to sheet2 but each name must be in correct place acordingly to username column
Capture6.jpgCapture7.PNG
in capture6: in F18 you see 139401arle and G18 is supposed to be his name but it's in other shhet as you can see
in capture7 his name "Ar Sveinung Leira" is in E5
is there any way to transfer names so that they go in right place?
Kopi av Computer List - 02 12 2013.xls
View 4 Replies
View Related
Apr 4, 2014
I've started building a macro that loops the sheets and collects the information onto the first worksheet. I've been using Activesheet and activecell references but i'm afraid looping will change these references.
[Code] .....
View 1 Replies
View Related
Jun 4, 2009
I have to worksheets, the first is filled out and at the end Ive place a button that I would like to open the second sheet and fill in cells that have duplicate info from the first, so just copy & paste but kind of automated for speed.
I have only got as far as opening the second document with the macro, after that im stuck!
The Info I would like to be copied across from the "service Diary" to the "Service Report" would be As follows:
*CUSTOMER
*CONTACT
*MACHINE TYPE
*SERIAL NUMBER
*QUOTE NUMBER
*ORDER NUMBER
View 14 Replies
View Related
Jan 12, 2007
I have a blank log template on one sheet, On this I need to be able to enter two variables that tell other cells to pick info from the next sheet. The two variables being 1) Date and 2) DAY SHIFT or NIGHT SHIFT.
On the next sheet is an archive of data running in columns with the dates in row1 and the denoted shift (day or night) in row 2. The rest of the relevant info is in the columns below each date and shift
What formula would I use so that the log template cells fill with data from the archive when the date cell and shift cell data is entered.
View 9 Replies
View Related
Feb 14, 2014
see the attached 'Example' excel sheet.
I'm not the best at explaining, but I think that the excel sheet is pretty straight forward.
In Sheet2, cells C3 and D3 are manually entered by the user. I am looking for a formula for B3 that will take the information entered into C3 and D3, find the row in Sheet1 in which column C=Sheet2!C3 and column D=Sheet2!D3, and give the unique corresponding result from Sheet 1 for that row in column B .
So, for example,
if C3=A and D3=102, then the result would be 444
if C3=A and D3=104, then the result would be 111
if C3=B and D3=102, then the result would be 111
The combination of C3 and D3 is always unique and will never have more than one possible result in column B of Sheet1.
View 5 Replies
View Related
Feb 20, 2012
[URL]
I have a workbook which serves as a master database at work. it contains two sheets: current residents of our facility (let's call this Sheet1), and those that have left/been discharged (Sheet2). It contains 87 rows and 34 columns of info.
I'm looking for a macro that will do the following:
When I click on a cell in any row (i.e. I need relative references) on Sheet1, the macro will (once activated):
1. Select the info between column D and column AH (inclusive) on the row where the selected cell is... i.e if I click on cell F4 before the macro is started, it will select the info from D4:AH4.
2. It will COPY this info
3. It will paste the info into the first empty row on Sheet2, starting from column C (i.e if the first empty row is 200, it will paste the info from C200:AG200)
4. It will then have a popup asking for: a. 'Date Left' and b. 'Reason', with two empty fields to input the info into. 'Date Left' is (obviously) a date value and 'Reason' is a text string. Once OK is hit on this popup, the Date Left will be pasted in column A of the same row (in our example, A200), and 'Reason' will be pasted into column B (again, in our example B200).
5. The macro will then go back to Sheet1 and delete the info that was selected between Columns D and AH inclusive (in our example, D4:AH4)
6. The macro will then save the workbook.
View 9 Replies
View Related
Aug 22, 2014
I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g
The info in these columns at present has been manually entered but I am sure it could be automated.
OOL Roster Final 18-31Aug14.xlsx
View 1 Replies
View Related
May 3, 2007
I have a sheet that users fill out and there is a macro on that sheet to copy the info to another workbook, save and close.
for some reason, the date, which originates from a cell with the value "=Today()", and when pasted in to the new book, it is pasted values.
the issue is, every so often, the date will say 09/26/10 and continue to do so for quite a few entries.
i have tried almost everything. I checked the dates on the computers, and all are fine. i even went through it step by step, and when the data pasted it, it was 09/26/10.
View 9 Replies
View Related
May 9, 2014
So in my excel document I have it such that on the first sheet (Labeled 'Sorted') the data is set up as follows: LOCATION, EXTENSION, NAMEWith the appropriate data under each header. On the second sheet (Labeled 'Locations_Ext') I have a named range called Locations; it contains extensions from a separate document, names of people associated with the extensions from the document, and their locations on the map. I am trying to have it such that the excel matches the extension number given on the first sheet with the ones that I extracted from the document on the second and output the location into the first column on the first sheet. The code I have set up for that process is:
=VLOOKUP(B(//SomeValue),Locations,1,FALSE)
I then want the excel to cross check the information that I took from the Visio to see if the visio is up to date with the latest info we have received (Which is the data on the first page under Extension and Name). The code:
=IF(C(//SomeValue)=VLOOKUP(B(//SomeValue),Locations,3,False),"Good","Error")
Both codes seem to be giving me this: #N/A as the results for every cell.. I'm using MS 2010
View 2 Replies
View Related
Jan 26, 2006
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.
View 7 Replies
View Related
Dec 15, 2011
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?
Code:
Sub TestBlankCell()
Range("D5").Select
Do
[Code].....
View 6 Replies
View Related
Nov 27, 2005
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.
View 14 Replies
View Related
May 21, 2014
I have names in cells in this format.
Smith John
I would like to switch that around so the name in the cell looks like this
John Smith
Is there an easy way to do this?
View 6 Replies
View Related