Making List From Various Cells
Jan 14, 2009
I have a workbook of contracts that I have designed in excel. Each worksheet tab/title is the contract number, i.e. 3487. On each individual contract I have the contact name, address etc. Each cell/field is in the same position on every contract. In other words, every B1 is the Group name, every B2 is the first name, every C2 is the last name, etc. What I'm trying to do is to make a new page with all of the contact info on it so I can make labels etc. I hope this is clear.
View 5 Replies
ADVERTISEMENT
Mar 27, 2014
How do i make a drop down list in a cell show Select One in the cell when the cells previous contence (Option selected from drop down list) have been deleted. E.g Cell E5:E400 must show Select One in the cell and when clicked on show drop down list I dont want a input message box or error box i can do that with validation
View 1 Replies
View Related
Dec 12, 2007
i have to make a synonym list out of existing wordlist for my professor. As far that’s the most boring job I would like to ask you people, if it could be automatically done by a vba code. I don’t think that that’s technically possible but I hope though that I am wrong and that some one here can help me. I will try my best to describe the problem as good as I can. Please let me know if its not precise.
Here we go!
I have a wordlist containing four columns A,B,C and D. In column A we have got Source Words(sw), in column B word specifications1(ws1), in column C word specifications 2(ws2) and in column D we have many meanings and target words separated by comma (tw1,tw2,tw3,…) for (sw). The interesting columns for our problem are only A containing words (sw) and column D containing meanings and synonyms(tw). The wordlist is supposed be get larger through finding, enhancing and adding synonyms in the same list. The difficult thing would be to make a macro with two modes. In first mode which asks each time before it adds or enhance a cell and in second mode the macro should do all the work alone without asking the user. The existing wordlist looks like: ...
View 41 Replies
View Related
Apr 2, 2007
what im trying to do right now is get some scripting to work better
the following is what the macro recorder gave us
what i need it to do is read how many rows are in the range and put the totals row one after the end. now it seems to be set to 507 and one wksheet has almost 700. can someone help me decipher all this.
thanks
kev
Sub General_Reports()
'
Range("A:D,F:F,G:G,H:H").Select
Range("H1").Activate
ActiveWindow.SmallScroll ToRight:=4
Range("A:D,F:F,G:G,H:H,I:I").Select
Range("I1").Activate
Selection.Delete Shift:=xlToLeft
View 9 Replies
View Related
May 14, 2014
In it I have a list of different profiles (From autocad Civil 3D). With a column for the station value, and a column with the elevation. These profiles are arranged all below each other. In the example xls, I've limited it to 2 example profiles to make it a bit clear. The 1st few columns come from the export out of Civil 3D (with empty rows between them, but these are easy to delete). For each station of the profile, you have an elevation
What I need to do is calculate a 3D length for each profile. So manually you can do this with A=(B2+C2)^1/2, and then make a sum. Which is not really a problem if you have a list with 2 profiles. But sometimes we have a list with 100 profiles.
Optionally, it would also be handy that we then get a list in another sheet, with in 1 column the profile names, and next to it the 3D length.
My main question is: Is this possible with VBA? (I would assume it is..) Next, it would be handy if I could be directed in the right direction to produce these routines, because I don't have that many experience in vba.
View 3 Replies
View Related
Nov 10, 2008
1. Is it possible for this hyperlink box to only be displayed when ALL the questions have been answered? i.e. All drop down boxes have been used?
2. Is it possible for the result (along with their individual names and scores) to be saved on another sheet? This of course would be supplemental (i.e. When the next person finishes the test, their name would be next on the summary etc.)? I would then have a whole list of who had taken the test...when...and what their score was!
3. Finally, and I know I'm pushing my luck, but is it possible for this summary sheet of names and scores to be hidden?
View 9 Replies
View Related
Sep 18, 2013
I have a bunch of excel files in a folder, and I want to make an excel spreadsheet that makes a list of them all. This drive is a shared drive and their are different authors for files. I have already made the list, with the file name, date modified, date created, etc. However, I am having trouble importing the list of the authors for the files. Is there a way to automatically import a list of excel files in an excel, with an "authors" column? I can't do it manually, for their are hundreds of excel files.
View 1 Replies
View Related
Jul 22, 2009
I have one column with a list of 2000 rows like this
apple
banana
carrot
dog
elephant
fish
goat
hat
I want to do is put all those lines of text / rows into one cell with the word "or" between each phrase. In other words in one cell all the above should be made into "apple or banana or carrot or dog or elephant or fish or goat or hat" . There should be no breaks.
View 2 Replies
View Related
Sep 25, 2011
I have a list that looks sort of like this:
Last Name | First Name | Date | Service Day
Smith...........John....................Monday
Jones............Alex...................Thursday
etc..
This list goes on down for like 50 cells. Anyway, I'd like to make a new list based on Service Day so that I can organize the names under the service day so it should look something like this:
Monday | Tuesday | Wednesday | Thursday | etc..
Smith, John..............................Jones, Alex
etc...
I tried using the vlookup function but then it confused me when i also needed to match the names with their respective service days.
View 7 Replies
View Related
Jun 26, 2013
I have a table where I need to make a drop down list in two consecutive columns (G and H). The list in column H will depend on the Option chosen in Column H.
Column G
Compensation
Payroll
Column H
COMPENSATION
Savings Box
Update Information General PAYROLL
Payment Inquiry Update Information Severance Pay
As shown above If you select Compensation in G you will have those three options in column H and the same for Payroll.
View 2 Replies
View Related
Jul 14, 2014
I need to make an automated way of extracting a list of IDs and the associated cost by a date range, say 6/1/2015 to 12/31/2015, plus the starting letter of the ID. I need the data to then fill a form where it can be sub-totaled. There are several additional columns of data that are not relevant so I know I can create a pivot table and then filter the data, but then I need to copy and paste the filtered data into the form. Is there a way to do this without me copy and pasting everytime?
I added a test worksheet to show the data and form.
View 6 Replies
View Related
Aug 20, 2007
I am preparing an excel spreadsheet to be used as an order form. There are certain columns that I do not want customers to be able to change, for example unit price, but I would still like them to see it. Is it possible to have only certain fields that can be changed and others that are protected?
View 9 Replies
View Related
Nov 20, 2007
Is there a macro that can make cells with no data in them disappear or not be displayed?
View 9 Replies
View Related
Oct 13, 2011
I have a question about making a variable selection.
In cell X25 is written "B9" and in cell Y25 is written "M39".
Now i want to make a selection by a macro from cell B9 to cell M39.
View 1 Replies
View Related
Apr 1, 2014
How do you make an active-cells value / text a hyperlink?
View 1 Replies
View Related
Jan 16, 2012
I have a spreadsheet with rows of cells which are either blank or have text in them.
Is there an easy way to write a formula which will make the cells which have text in them bold and make the cell colour grey. But if the cell is blank keep the cell white.
View 3 Replies
View Related
Jan 27, 2012
I have a workbook with a data entry sheet.
The name of the data entry sheet is 'Enter Data Here', and my employees will be filling in information in columns A to U.
I want to be able to accomplish 2 things.
1) When an employee opens the file, he/she is not able to edit any non-blank cells in columns A to U.
2) Employee is able to add data to a new row in columns A to U, and is able to edit this until they press 'SAVE'
Is this possible?
View 9 Replies
View Related
Jul 6, 2014
I have a big Excel file that is supposed to be used by many users and therefore I need some cells locked. But problem is I use these cells in my vba codes which the users must be able to run by using the buttoms in the file. But now I get error in every macro since the cells the code are trying the reach is locked. Can I make an exception for vba codes in some way so that I can run my macros?
View 4 Replies
View Related
Jun 9, 2014
I want to make an excel workbook for a client. What I want to do with it is make a set of instructions telling them to add or insert as many rows in specific categories I have made for them. These options differ depending on the different duties performed. There will be an associated number (value for that duty, ex. duty might be Janitor and the number would be like 5 dollars per hour, so on and so forth), I want to make it to where there is a code that notices more rows and adds more IF statements or whatever statements are needed to keep adding those extra options. These values are connected to a data validation list that drives the if statement.
View 4 Replies
View Related
Aug 28, 2013
I'm looking for a way to make a cell copy the fill color from an adjacent cell.
in my case, cell A1 is a dropdown menu cell, where each option has a different fill color (through conditional formatting). what i want is to make cell B1 copy the fill color from cell A1 automatically. it may be important the both cells have dropdown menus.
View 3 Replies
View Related
Sep 6, 2006
I have a chart that shows up to a list of 28 people and the number of sales for that day. I'm try to make the chart only show the names and number of salesperson that are not = to null. This is what the chart has for values right now "=' Nest Average'!$C$6:$C$33". How can I make it so that it only shows those cells if not = to null.
View 2 Replies
View Related
Dec 25, 2012
I have created a qualification tracking spreadsheet to track when qualifications are coming due. Each cell may have a different date based on when that employee initially got that qualification. I want the cell that the initial qualification date is typed in to turn "red" after 180days, "orange" after 120 days and "yellow" after 90 days. I have a formula that does close to what I need, but it changes the cell next to it in color.
That code is as follows: =AND(A1<>"",Today()>=A1+90,B1="")
I have attached the sheet, what I am trying to do. Basically columns B-E and rows 2-35 are the ones that need the formatting.
Streiffs_Weapons_Warfare_Qual Tracker.xls
View 5 Replies
View Related
Feb 11, 2014
I have set up a formula to sum data from specific columns in multiple sheets in the same file. The simple formula had worked perfectly until I needed the data from the last sheet. In all of the other sheets the data that I need to pull is all in consecutive rows but in the last sheet the data that I need pulled and added is in every 4th row. The sheet looks like this:
All of the columns I've filled in work fine. The ones blank are the ones I am running into issues with. When I drag down the formulas excel pulls the next consecutive rows, which is perfect for the first four sheets I am summing, but for the fifth sheet (I'll ref the Test1 column) I need it to pull 'Wayne 2014'!C6 and then 'Wayne 2014'!C10 in the next row and so forth.
Date
All Test
Test1
Test2
Test3
Test4
$ Amt.
Jan.16
=SUM(C2+D2+E2+F2)
[Code] ........
The first four sheets look like this, which is why they work fine:
Date
All Test
Test1
Test2
Test3
$ Amt.
Jan. 16
=SUM(C2:E2)
[Code] ........
The fifth sheet looks like this: I only want the formulas from the first sheet to pull the data from the dated rows in this sheet.
Date
All Test
Test1
Test2
Test3
$ Amt.
Jan. 16
=SUM(C2:E2)
=SUM(C3:C5)
[Code] ......
Is there any way in Excel 2010 to get it do what I want? (I am not sure how that one cell became outlined and I do not know how to fix it.)
View 4 Replies
View Related
Feb 14, 2014
I have a list in column L2:L352. I would like to be able to start at AD2 and drag horizontally so that AD2 = L2, AE2 = <BLANK>, AF2 = <BLANK>, AG2 = L3, AH2 = <BLANK>, AI2 = <BLANK>, AJ2 = L4, etc.... until L352 has been autofilled.
View 2 Replies
View Related
Jun 24, 2009
I am trying to create a drop down list that when selected will display data in the 10 rows below and 4 columns, so a total of 40 cells. I would like the data to be based on the selection in the drop down list.
The data looks like this,
RequirementsQtyResourcesQty
Level 1 Sentinel10Level 1 Sentinel105
Level 2 Sentinel10Level 2 Sentinel167
Level 3 Sentinel10Level 3 Sentinel156
Level 1 Banga20Level 1 Banga401
Level 2 Banga20Level 2 Banga307
Level 4 Banga20Level 4 Banga0
i have 27 different combinations of the above list with up to 10 different rows. I have a label for each one, but i cannot get the rows below my drop down list to display the proper values base don the selection in the drop down list.
View 8 Replies
View Related
Feb 8, 2014
I would like to take a List of numbers, which come from a separate spreadsheet, place them into a UserForm text box and then use a command button to input the list of numbers into a column of cells. The list would often vary, between 1 and 10 entries. But if I could do this, I would be able to resolve an issue with my spreadsheet that continues to haunt me (the dreaded number stored as text.....). I know that you can assign a single textbox value to a single range-cell value. But if I could input a list at a time, it would obviously save a lot of effort.
Example
In spreadsheet #1, I would copy the list below.
25466
87550
66985
44252
In the user form I would paste these numbers into the text box and they would be input into Sheet #2
B6 = 25466
B7 = 87550
etc. etc.
View 2 Replies
View Related
Feb 3, 2010
I am making a simple map in excel. I have my floor plan on sheet 1 and the location of product on the floor on sheet 2.
Currently I have some formulas on sheet 1 that link to some sales data on sheet 2, but what I would really like to be able to do is use the search function on page 1 and it give me the location of the products in a given area.
The data is broken up into group location on the second sheet.
View 11 Replies
View Related
Feb 6, 2010
I have four columns containing about 200 addresses.
A Names
B Streets
C Cities
D Phone no.
If I write a name in D1 I want to get the corresponding street, city and phone no. in E1, F1 and G1.
I also want to copy the formula downwards let's say ten times so I can make a list.
If I for example just want to make a list of three names (D1-D3) I want the rest of the fields to stay blank.
View 6 Replies
View Related
Aug 2, 2007
I've created an Add-in (.xlam file) in Excel 2007 and installed and activated it (it shows up under "Active Application Add-ins" on the Add-in menu for new workbooks).
I can see the macros and code when I go to the VBA editor, but the macros don't show up in the regular macro list.
I know that I can write code for the new workbook that will reference the Add-in code, but I want other users to be able to install the add-in and run the macros in it right away without any knowledge of VBA. Is there a way to make this possible?
View 11 Replies
View Related
Feb 11, 2008
i made a claculator in vb.net, and now i have to make one in vba, what i did was as follows, first ill post the code from last year, then my vba attempt;
View 14 Replies
View Related
