I have a button setup with a macro to copy cells in a column and paste them into a row on another sheet. One of the values in the column needs to be checked in the other sheet before being added.
After the button with the macro is clicked
- If the value entered in column A (sheet 1) exists in column A (sheet 2) proceed with the rest of code.
- If the value entered in column A (sheet 1) does not exists in column A (sheet 2), Popup menu to enter details of value (just a menu with an input box and instructions), then the macro should enter the details of value (entered by user into the popup menu) in column B of sheet 3, then proceed with the rest of code.
I posted this with a different explanation before and didn't get a response so I am hoping that this is a thinned down version of my request and is more specific. Please let me know if you need more info.
I have a table with 2 columns and I want to create another table with the same values in these 2 columns but add a new column with values that are different. So for example, I have col A, Col B with values 256 and 14. I want to create a table that has Col A, Col B and Col C with 256 in Col A appearing 60 times, 14 in column B appearing 60 times and new Col C has values ranging from -4 to 55 for each new row. So new table now has 60 rows with same values for Columns A,B but different C value
I can drag or copy paste but when I have 200 unique records in first table, I want to create a second one with 200x60 rows and drag/copy paste is tedious.
I need to replace the values in the braces with the values in Column A. Is there an easy way to do this or am I stuck with doing each one manually? There are 92 lines in Column A.....
I am trying to write a macro that should be able to copy existing row and insert values and formula into a new row just below the row. As an example below:
A B C D E
001 ADESF 500.00 1001210 EMF
The values in column C and D for the new row will be the same.
I have a workbook with several tabs. the first tab is a data input sheet: subtotals from this sheet get posted to cells on the other sheets. at the top of the Data sheet is a drop down validation list that the user will select the next month from. On each of the other sheets, is a grid with calendar months down the left hand side and years across the top:
I am trying to figure out a simple method to check whether there is data on any of the four other sheets in the spot corresponding to the month selected by the user on the Data tab. the format of the validation list dates are dd/mm/yyyy in cell B2 on the data tab.
I have a Multi Select ListBox with values from a range of cells.
I wish to automate the selection of one or more existing value(s) via VBA code so when User views the List, The check mark is visible. This will alert them to Active values.
i.e ListBox:
North South East West.
If the active region is West, The check box beside West is Active, i.e contains an "X"
My problem may seem similar to "conditional sumif", but I could not solve it with that approach. The examples of sumif or sumproduct always use
E2:E25="Low"
notation, in my case I need a range on the right hand side of that comparison. I have several brands which belong to some producers. I'd like to sum the values of all brands belonging to 1 producer. The brands and their producers are listed on the same sheet. An example is attached.
I'm currently using the following formula to return values rounded down to the nearest 2.5: =FLOOR(X8*1.25,2.5)
This works fine but I would like to put in place a system where if the "X8" value is 1 the formula produces a 2.5, and if the "X8" value is 10 or greater the formula produces a 10.
I have Column C and D filled with numeric temperature and humidity data. I need next 16 rows (8 more set) to be filled with randomly generated dummy data by the values exist in C and D. Same numbers but randomly distributed.
I'm trying to place a pivot table in an existing sheet in order to have a list of names next to a P&L. I've got several criteria to filter the names, but when I apply the filters to the pivot table, not all the people show up. The weird thing is that the total at the bottom of the pivot table, which is a simple sum of time in a given month per person, calculates the correct number as if all the employees are there.
When I do the same table in a fresh sheet, in the same file, it shows correctly. It's only when I try to put the table in an existing sheet that it abbreviates the list.
I'm trying to simplify a spreadsheet i've been given by defining names for certain values. I'm using Excel 2013. Is there any way to have all of the newly defined names I've created for cells automatically be inserted into all of the formulas that exist in the spreadsheet?
Example.
Old formula in one sheet of a workbook looks up a cell in another sheet with the value of ='sheet1!A1
I've given the value of cell A1 in Sheet1 a name of dgwd.
How do I get every formula in the workbook that references 'sheet1!A1 to change the value within that formula to dgwd?
I'd like my macro (in an Excel 2010 workbook) to copy values from three worksheet cells and append them to an existing Access or SQL database file -- without having to leave my Excel spreadsheet or open any other programs. The database file simply needs to be appended. Keeping a running list. That file isn't being used for anything else, we can set it up however is necessary to do this.
For example, Excel cells A1, A2, and A3. Representing Job Name, Job Number and Job Total.
how make VBA do this(in SIMPLE terms)? Or give me a link of where to look or what to search for? I understand VBA but not Access or SQL.
For simplicity sake if I wanted to paste the letter A in to a cell that already had the letter B in it to make the cell read AB how could I achieve this?
My situation is as follows: I have multiple workbooks that each contain three worksheets, the worksheets from one or more of these workbooks needs to be added to another workbook.
Since the worksheet names in all workbooks are the same, I need to add the data from a cell (account number) in the file to the existing worksheet names. Using the attached file as an example, the value of cell A8 on the DMC-UPS-Summary worksheet needs to be added to each worksheet name in this file.
I have created a spreadsheet which serves as a reporting portal - if you select a product from a drop down, the spreadsheet automatically updates with data regarding that specific product. I would like to give my worksheet the ability to select a new item from the dropdown (that part i can do) and then print each of these product reports (1 page each) and aggregate them into one large pdf.
I was trying to use Sheet1 (data input sheet) to collect 33 values and write them to Sheet2 as a row. I wanted the user to be able to make changes/corrections. So if the set of data with same date and shift number is entered for a second time, my macro should be able to over-write the existing row in Sheet2. Have been digging for days yet with no avail.
I have an existing module that queries a SQL database and populates a worksheet using VBA. I would like to add to this module to include a sum of columns, but as this sheet is always dynamic, i am not sure how to sum this appropriately. for example, I have column B, I would like to add the rows from a certain point in the worksheet, but this is always dynamic, is there a way to accomodate for this so that I am always summing the column in the correct place?
I have two spreadsheets that use a Number as a Key. I need to compare the numbers on list 1 to the numbers on list 2 and add any values that exist on list 1 but not on list 2 to the end of list 2. List 1 is in Column B, List 2 in in column C of a different sheet in the same workbook.
I'm creating a blank woorkbook that I'm gonna use for different projects. The other day I've got a solution in this forum for a problem creating the link to a non existing sheet and it works perfectly BUT now I need even more. I have to use formula VLOOKUP in the same cell where I have my IFERROR formula and I can't figure out
More precisely, sheet 'Graphique 2' columns D, F, H... are refferring to sheet 'LOT' F25:F44 (sheet LOT is a model sheet and I'm gonna have more than 50 of it, for different companies). To create some graph in function of date I've added months for the next 3 years in column B sheet Graphique 2, so the money amounts from column F sheet LOT (reffering dates are in column C) have to be copied to coresponding rows in sheet Graphique 2
Normally I think I would have to write:
=VLOOKUP(B4,LOT!C25:F44,4,"")
except that I don't know the names of my future sheet so in the same cells where I should have the VLOOKUP formula I have:
=IFERROR(INDIRECT(C$2&"!f25"),0)
My question is what is the combination of this two formulas?
I tried to open an existing Excel workbook, it tells me that it is already open. There is nothing on the screen. I closed Excel (using 2003 version) and restarted computer also. I tried to open the file again - nothing shows up on the screen. When I attempt to open the file again I get a message that says "(file name).xls is already open.
Reopening will cause any changes you made to be discarded. Do you want to reopen (file name).xls?". Even if I reopen the file, it still does not show up on the screen.
Currently I'm trying to set up a table that referneces sheets that don't yet exist. These sheets will be added by the user or by macro, either one. I want my table to automatically take these pages into account when they're created without having to rewrite my formulas. The problem is that when I make the call to a sheet that's not there, it opens a file open dialogue box and I don't want it to do that. Is there something I can do here about that?
I don't think it's really going to shed any light on the subject, but this is my call (from memory, not copy and paste)
Also, when I enter this formula and the sheet doesn't exist, it automatically reverts to a text field and I have to manually switch it back to general in which case it gives a #REF error (which is just fine).
Also, I'm writing it in Excel 2003, but it completely crashes Excel '97 if I try to open it there, how can I fix this?
I would like to Import a Text file into a current Workbook with the worksheet name GLFBCALO. The macro below creates a new workbook instead of imported the data to existing sheet, GLFBCALO. Is there a way to use the OpenText method to import data into an existing worksheet?:
Public Sub ImportOKdata() Dim MyFile As String Dim ColumnsDesired
I have 6 working tabs in my workbook (1-10, 2-8, 1-67, 3-16, 2STB, 204th). Each of these sheet has the same number of columns. The first row is a header and the last row in each sheet is used to calculate subtotals and contains no other data. Each row of data is essentially an order that contains an ID number, information on the equipment being ordered, and information on the customer, remarks, and some other tracking information. Each worksheet contains a Column called "Gaining BDE" (Column E). These "Gaining BDEs" are essentially a way of labeling a group of customers. What I need a macro to do is create and maintain a sheet for each of these "Gaining BDEs".
I need excel to look at each of my 6 working tabs and when it sees 1ABCT, for example, copy that entire row of data into a tab called 1ABCT. As I add rows to my 6 working sheets as orders accrue, I would like excel to automatically place a copy of that row in the appropriate sheet. I have a few other sheets in my workbook that I do not want excel to search for data within as they simply serve as references for my VLOOKUP functions. I would also like the cells to be linked so that when I change the Remarks column to reflect "Complete" for example, that change is reflected in these newly created sheets. I have tried working with other peoples copy/paste row VBA code but have not had any luck and I am brand new to VBA so I have a tough time understanding it still.
I'm having some trouble getting my workbook uploaded but a view of what one of my sheets looks like can be seen here: [URL] ........
I am trying to combine the 'Mail Range' from this code http://www.rondebruin.nl/mail/folder2/mail4.htm with the 'Mail to address in A1' from this code http://www.rondebruin.nl/mail/folder2/mail5.htm and can't make it work. Maybe this is the wrong tactic to take but I have very little knowledge about writing my own code. The ideal solution would make a copy of a a specific range of cells from a specific sheet, mail it to a recipiant (could change based on what is entered in the field) and delete the copy. I will try to attach an example next week.
