Is it possible to move a worksheet from a workbook to an add-in.. just can't seem to do it for some reason. As a last-ditch attempt, I tried to convert the add-in to a workbook, but I can't seem to do that either
Each month I get a report that is formatted by the customers and this sheet never changes. The problem is that the master sheet my job uses is not formatted this way. The master workbook has several sheets that breaks down the data from the monthly sheet. Instead of having to enter the data manually I'm looking for a way to export the data from the monthly sheets into the master workbook. As I stated the sheets are all the same but come from different providers and all contain the same amount/style of data.
I'm simply trying to copy a worksheet (from one location within a file) and place the copy elsewhere in the file. I continue to get an error message that looks like this: "A formula or sheet you want to move or copy contains the name 'Additional_Notes', which already exists in the destination worksheet. Do you want to use this version of the name? To use the name as defined in the destination sheet, click Yes. To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box."
The term above 'Additional_Notes' is just one of MANY references which (apparently) "already exist in the destination worksheet". I tried renaming the range as described above, and when I do, the above error message essentially re-appears, but this time the term 'Additional_Notes' is replaced with another bit of text. And so on. I am not able to copy the worksheet and place it elsewhere in the file without this error message cropping up. I've used the move/copy function thousands of times.
I am able to make a copy of the worksheet and move it into a new (blank) XLS file...but NO luck copying the worksheet and placing the copy in the same file...
I have in sheet1 a column "A" with random dates in this format x/x/200X.This sheet is constantly updated with new random entries as more information arrives.
So, how can I use a formula to automatically move to sheet2 "only" the rows with dates for JANUARY. I know that I can move data using e.g....=sheet1!A1, but I don't know how to use this formula with an specific condition to move the rows with JANUARY dates only.
In the attachment, you can see how I would like to move "only" the rows with JANUARY dates to sheet2.
We use work order worksheets in excel with basic information: Date in, work order #, account, date out, total # of days, work conducted by, number of samples, description of sample, etc. Each work order has an individual worksheet. The information in these worksheets eventually get entered into a work order log containing the same information in order to compile a quarterly report. We might have 400 work orders in a quarter.
My question is: How do I link the individual worksheet to the work order log in order to get the data to transfer automatically when a new work order is entered into a worksheet? I'm able to get the first work order to link to the log worksheet, but CAN NOT figure out how to get subsequent work orders to enter into the following rows, rather than just replace the first row over and over.
I have an excel workbook with 5 sheets, the first called 'data drop sheet' & the others called 'Louise', 'Thor', 'Peter' & 'Steve'. In the data drop sheet, the first row is header data and underneath (A2 onwards) are rows of data that I have cut & pasted in. The first column (A) of this data will be the person's name, e.g. Louise Wilson.
I want to be able to move the rows for each person to their respective sheets, starting from row 2 as the first is a header. So, for example, if 'data drop sheet' cell A2 says Steve Brady, I want it to copy the whole line to sheet 'Steve' row 2 etc.
I would like to make a macro that will move rows from one worksheet to another worksheet.
I have an excel spreadsheet with multiple columns and rows, within one of the columns there is some text that refers to SOS or County, I need to move everything that has SOS to another worksheet title UCC SOS and everything that has county to be moved to another worksheet title UCC County. Here is a sampling of the worksheet
I am looking to remove all blanks from a table I have and move all the data left. Right now the data is by date, and some dates are blank for some players (it is a basketball sheet) and filled for others, but I want to see it by game. So I have what is in the first table below, and I want it to look like what is in the second.
I had this code working on a Range in a Worksheet. I decided I needed to move the range to another worksheet. I moved the data to column AA in a new sheet called Audit_Pool and renamed the sheet name in ThisWorkbook.Sheets, but I get a runtime error at the With Range statement.
Worksheet 1 is called "Master List Data". Every cell within this worksheet contains a formula so that it matches the cell value contained in a worksheet held within another workbook.
The formula for reference is as follows:
=IF('[CCL Breakdown.xls]MASTER LIST - Active Customers '!A1="","",'[WFX CCL Breakdown.xls]MASTER LIST - Active Customers '!A1) .
e.g.
If Cell A1 on Master List-Active Customer contains no data, Cell A1 in Master List Data would be blank.
If Cell A1 on Master List-Active Customer equals John Smith, Cell A1 in Master List Data would display John Smith.
There are currently non-blank values contained in cells A4:A750. But next week there may be non-blank values is cells A4:A790 (i.e. it will grow each week)
Worksheet 2 is called "Master List Flat. At the moment, I am manually copying and pasting the rows which have non-blank values in cells from Column A from Worksheet 1 into this report (e.g. A4:IV4).
I would like to automate this process and I have created a Macro, but I do not know how to word it so that it will only copy cells with actual data in.
The Macro I have written is below:
Sub IMPORTANDFLATTENDATA() ' ' IMPORTANDFLATTENDATA Macro ' Macro recorded 01/10/2012 by walesb ' ' Application.ScreenUpdating = False Sheets("Master List Flat").Select Rows("4:759").Select
I have an excel work book with 6 tabs. I would like to have Excel move an entire row from one tab to another tab (removing the row and inserting it in the other tab). I.e. Example I have a tab with items that are marked as "Open Actions" so if I were to change the drop down to close. Excel would move that entire row of actions to the tab with the "closed actions" and insert into the next available row. Now if someone were to come back at a later date say no it should be reopened than I would change the drop down to open and excel would move that row back to the open actions tab into next available row. I tried a PIVOT table and no good I played with few macro and not.
I am working on a project that has 5 worksheets. I have been able to figure out everything else I need to do but this has me stumped. I have data in Sheet1 A6, that i want to place in Sheet2 A6, Sheet3 A6, Sheet4 A6 and Sheet5 A6 and keep data and formatting(BOLD AND UNDERLINE). So I change Sheet1 A6 and the other 4 sheets change also. I'm using Microsoft Excel 2007.
I have a workbook that contains 50 worksheets named 1-50. I need to add more worksheets. all the formulas in the worksheets always refers to the previous worksheet.
How can i make a copy of the worksheet named 50, name it 51 and have all the formulas in worksheet 51 refer back to worksheet 50?
If I want to "Insert Copied Cells" in place of Yellow on Row1 and shift the cells down, the rows would look like this:
[Code] .....
How can I make it so the rows would be the following during such a paste:
[Code] .....
This is because I have hundreds of cells that I need to insert as columns all the while pushing complete rows down. If you're trying to understand why, it will be for some online marketing purpose as demonstrated here in this sheet: [URL] ...
I am unaware how to set up a combo box to allow users to move from the combobox to the next combo box . tab or enter? The way we do it know is we click with the mouse from combobox.
I have a workbook with 2 work sheets, when a row has "yes" typed into the "accepted bid" column I would like that row to be placed into the second sheet in the order in which it was entered "yes" so, if on the first sheet a row, lets say row 10 had "yes" typed into it but row 10-15 on the second sheet had something in it already, the info would have to be placed in the next available row.
I have approximatley 20 rows on the first sheet and the ones that transfer to the second can just be added to it as needed.
I want to move the vales from F8 to F9, F9 to F10, F10 to F12 (there is a space)and so one. I would like it to be triggered by changing the value in F8 if possible. I have tried a good few ways, sometimes I get a stack 28 error.Zones.xlsm
Is there a way to write VBA code that can reference a range of data that may be moved on the spreadsheet by the User? For example, if I write VBA code to reference a range of data such as:
I need to know the function to move a named sheet to the end of the list so its the last sheet in the workbook. Worksheets("xxxx").Copy After:=Worksheets(?)
Im copying a worksheet and want to move the new sheet to the end but I dont know how to finnish it. I tried to do.
I am very new to macros I have a list of data all in column D. I need the macro to go through that whole column and for any cell with more than 50 characters stop at 50 and continue the remaining text in the cell below. This can all happen in column E.
I have a matrix A with 12 rows and 10 columns. My problem is if in the cell(i,j) there is data then the same data should appear in a similar matrix B, but in a cell which is 15 cells behind the cell(i,j).
That is it should start counting upwards from cell (i,j) in B and once it reaches the top of the matrix it should continue counting from the bottom of the immediate left column and go up. When it reaches the 15 cell from cell(i,j) in b, it should print there the value that was in cell(i,j) of A.
I have created a simple button that I want to take me to a certain number of tabs. I have about 24 tabs. I can't see them all. I create a button that will take me to a specific tab from my main page. This works fine till I rename the tab. I want the code to read a sheet number or something like that instead of the specific name.
Sheets("JobList").Select Range("A8").Select This works till i change the name "JobList"
I have code broken out between two different modules due to size limitations in a single module. I'm not able to figure out how to move to the second module after running the first module. I've tried something like this:
Sub FirstModule() 'Code 'Code 'Code SecondModule End Sub
Sub SecondModule() 'Code 'Code 'Code End Sub
I'm getting an error that says "Compile error: Expected variable or procedure, not module". I understand that it's not allowing me to use the name of a module as a procedure, but I can't find any information on how to call the second module.
i have a spreadsheet model that i have inherited that needs some rigour. currently, users are inputting the bare minimum and then running away with calculation errors all over the page. I want to be able to "force" them to fill in certain fields before allowing them to move on. Eventually, I will do this via a User Form but until then, I need something to help my lovely users along in the right direction.
So, if a user inputs a project name (say G15), they will have to also enter Project Type (I15) and Start Date (K15).
while I am here, I want to be able to have the Project Status show as Potential if the Start Date is in the future. I already have validation set to limit the user choices to "Current,Completed,Suspended,Potential,Cancelled". I am not sure how to get the validation list to be contingent on the start date.
and lastly, does anybody have a little piece of code that will make the Start Date show as the day that the Project Status was changed to Current? So, even if the Start Date was initially a few weeks away, if Status is changed to Current tomorrow, the Start Date should be overwritten with tomorrows date.
I'm working with duplicate rows of data and need some help to put them onto one line. I'm working with about 58,000 rows of data.
I have the following as an example:
Ref Name Address 1 Address 2 AAB01 Dr Jones 16 Marsh Ave CL4 2JH AAB02 Dr Peterson 18 Marsh Ave CL4 2JH AAB01 Dr Jones 21 Marsh Ave CL4 2JH AAB01 Dr Jones 18 Marsh Ave CL4 2JK
AAB01 is the duplicate, however it's not clear which address and postcode is correct. I want to perform some sort of formula that will add to the first instance of ABB01 the details from the duplicates.
For Example: Ref Name Address 1 Address 2 Address 1 Address 2 Address 1 AAB01 Dr Jones 16 Marsh Ave CL4 2JH 21 Marsh Ave CL4 2JH 18 Marsh Ave
I have a sheet with 7 columns and approx 30 rows. I want the information within a particular row to be moved to another sheet if the value of the 7th column is equal to zero.
I have obtained a function (from this site at Exponential Moving Average) which is supposed to help calculate simple mathematical values but it's not working on spreadsheet. assist with taking a look at this as I have attached the spreadsheet?
I'm looking for a macro to move all files from one folder to another. I won't know what the files are called and don't really need to know. They could and will be different every time. The purpose is to clear out the files created in the past fortnight ready for the next batch job to run.
I have to copy a column from another workbook and past in to the column in this workbook. However the column i am copying are all referenced from other cells. Is there a way to just copy the numbers and move them into this workbook to avoid double data entry?
I am attaching the 2 work books.
1. Is MSP commissions Structure that is where the data needs to be pasted 2. Grace - this is an example of what we will need to be copying from.
On Grace - copy Column G, Rows 65-81... The paste those numbers into MSP commissions structure column D, Rows 9-25......
We will have a file similar to Grace for EVERY deal closed....FYI so this process if possible needs to be replicated many times.