Formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the same row.
Example: cell in column D says "PSA" - so I would need the cell in column H for that same row to read "Radio"
I would need an entire sheet scanned to review for these occurrences and make the appropriate changes. I also would need the formula to be inclusive enough to scan for variations in column D cell content (PSA 1, PSA 2, etc).
Cell A1 needs to contain the contents of A3 without the user having to go and type the entry in each time the next cell along changes.
For example, let's say that last week 1.81 was typed in A2. The user then had to go in to A1 and also type 1.81. This week 1.83 has been entered in A3 so the user will manually have to go in to A1 and type 1.83. Next week when something is entered in A4, the contents of A1 will again need to match the contents of A4 and so on for the next 52 weeks. We'd like a formula in A1 that automatically shows the contents of the next cell along as soon as the content exceeds Zero.
I have a combo-box in Sheet Number 1 filled with date. In all my other sheets there a empty combo-boxes. When the workbook opens I automaticly want to copy the content from the combo-box from Sheet 1 into all the other comboboxes in the other sheets. Is there an way to solve this problem with a minimum amount of loops?
I receive about 80-100 emails per week that are computer generated by one of our customers. It contains time entry data that needs to be processed for our internal system.
Today I copy paste the content (it is NOT an attachment!) to Excel and have a macro to decifer and organize the information.
Is there a way to automate the "copy-paste" process, that is, go to the inbox and process each email with a loop like method. The process needs to be able to go through a Yahoo mail box as well as an Outlook mailbox, Do not know at this time if there is a difference between the two.
I want to use a Login screen for a little "request-program" I made. Logging in works and when I log in as an administrator, an extra window pops up where I can add and remove new users (with pass). Users (column A) and passwords (column B) are located in a 'logins'-tab in my worksheet. Adding a new username works fine, but I don't seem to get the password next to the username. When adding a new name, the code searches for a blank cell in column A, adds the name and then sort the rows (so username and password still correspond). Usernames are filled out in a combobox (so you can select one to delete) and passwords in a textbox.
I have a named range (D:16 F:800) called “NameRange” which contains names. I’d like to create a macro which offsets a letter “x”, 10 columns to the right everywhere that name appears within the range. As an example: If I’m trying to find the name Tom, A dropdown menu shows the name “Tom” ( which I’ve created) whereby it calls upon a script to search within the named range from this:
Bob Kim Tom Tom Sue Mary Bill Ted Tom Sue Bob Fred Bill Sue Bob Tom Kim
I have tried to these through formulas without success but i think i need VBA also which i am not very experienced.
I want to paste a list in the "InsertList" sheet. This list will only contain the word "Correct" or "False". From then on i need a way to search for the word "Correct" or "False" in the columnS P,Q,R,S,T,U,V.
e.g. If in the column "P" on the "InsertList" sheet the word "Correct" is found, i need that entire row from A to V to be copied onto it's destination, in this case "sheet1".
If the word "Correct" is found on the column "Q" on the "InsertList" sheet, the rows from A to V need to be copied in the Sheet2. And so on..
I have a list of 12.000 pictures which have to be "connected" with the article number (1000) & color (21). Here starts the problem... Each article usually has more than 2 colors, but is listed only once per row and the colors are stated in columns.
What I would need is a macro or function that would do from such structure:
art description color1 color2 color 3
1000 product A 21 22 23 1001 product B 19 23
art. description picture
1000-21 product A, color 21 1000-21.jpg 1000-22 product A, color 21 1000-21.jpg 1000-23 product A, color 21 1000-21.jpg 1001-19 product B, color 21 1001-19.jpg 1001-23 product B, color 21 1001-19.jpg
1. check if the row in color columns is not null 2. if this is true, then I would like to copy the entire row & paste it below existing 3. then the "art." column would be changed (=A2&"-"&C2), so the article woul get suffix of the color (and column "picture" would be created, maybe something like =A2&".jpg") 4. if any other color column in the same row is greater than null, then proceed to next color & repeat steps 2. & 3., else go to next row 5. until all 5000 rows are converted in about 12.000 rows.
A single worksheet holds all the values I need to move to various worksheets in the destination workbook. The destination workbook is MASTER.XLS and is already open. The source workbook has various names.
I have the macro walking through each value in column E of the source worksheet. When a match occurs, the corresponding cell in column F has the destination worksheet name, the corresponding cell in column G has the destination cell address and column H has the destination value (string value).
I have dim statements for SheetName, CellAddr and CellVal ; all set for String. I have been playing with "Offset" as well as "Select"ing through the worksheet hierarchy to drive to the desired destination cell. All seem to be more work than necessary and none work properly.
What I am looking for is a set of macro statements that I can use as a "template" within the balance of the macro I have written. I would also happily accept recommendations about books that provide a step-by-step approach to learning the capabilities of Excel's VBA functions. I know from my limited programming background that there are many ways to do the same thing. I'd rather start with the most efficient rather than burn lots of hours experimenting.
1. Delete rows that contain certain text in a worksheet ? 2. Highlight a cell a colur based on a response ?
I have attached an example of what i mean .....
In the Audit Protocol worksheet is the main information - which contains questions and answers .... If a yes, n/a or no is selected then a response is automatically generated in the observations column (thanks to SHG for helping me with the formula for this) ..... How do I then get the cell to change to red if a NO response only is selected ?
Then the information from the Audit Protocol worksheet (the observation column and number column) are copied across to the worksheet named Action List (this is done just by the copy function) .... How do I go about deleting rows that contain "no action required" - as these are not needed for the report to be generated ?