Does anyone know why, when I copy a Worksheet (right click Worksheet > Move or Copy > Create a copy), Excel occasionally fails to copy across the embedded objects contained within the Worksheet (e.g. Charts, Command Buttons, etc.)?
This is very frustrating, and I'm wondering whether it's the way my Worksheet is configured, or whether this is a known bug.
On a weekly basis I update a suite of charts in one workbook that are created from several other linked workbooks. Once compiled I send this via email to a colleague who incorporates it into another report by printing the charts as a pdf. For some reason he often ends up with erroneous data (zero's where there shouldn't be on the charts), or often his system doesn't display certain elements like titles and axes etc
We think his system is spending resource looking for the original data and getting itself knotted up, but surely there should be a way of delinking the charts but maintaining their integrity as they are saved?
My main sheet has the results of a competition in rows 1-100. 75% of the results won't count for the jumpoff ( its a horsey competition) and I want to automatically copy the successful details to another sheet. I've worked out how to to omit the unsuccessful results by using an IF statement ( IF cellx is > x then copy ) but I still end up with 100 rows - with 25 results and 75 blank rows. How can I copy but compact it down to 25 rows.
As a second question I need to sort the results. I know how to do a manual sort & I even worked out a macro so one keystroke can do the sort. It woruld be better if the sort would be automatic whenever there is a change in the scores.
I have a chart with coloring for specific series sets. When I create a similar chart, can I copy the formatting from one range to the other? Why does it default to certain styles?
View 1 Replies View RelatedI have a list of products and would like to find what are the missing products which aren't ordered yet from the customer.
As the example: let's assume numbers from 1 to 9.
And I have some numbers, like this: 2, 4, 6, 7. What is the formula which can copy automatically the missing one into one cell?
See the attachment : howtodothis.xls
I know, how to copy multiple cell into one cell (like A4&", "&", "A5 etc), but how to find the missing numbers?
My column chart is produced by a pivot table & pivot chart and then I manually select each regions code, and paste the associated graph into word 120 times over. This is extremely tedious.
Although there is facility for SHOW PAGES on a pivot table, I don't seem to be able to find an equivalent built in function for pivot charts.
I've tried locating my pivot chart on the same page as my pivot table and then hitting show pages, but it only reproduces the pivot table.
If I could even get a graph on each tab for each region - I could at least PDF the excel file as a complete report by selecting all the tabs and printing them into a single PDF file.
I am tring to make a macro that will find all charts in a worksheet and delete them.
the macro is essentilally a monthly refresh that cleans out a template of charts that were pput in the previous month. As the chart names and the number of charts might vary from month to month I just want simple code to select all charts in the worksheet and delete them.
I am currently completing work for a senior manager who has the tendency to show off to the other seniors about various ideas/spreadsheet programs, usually at the expense of myself, the creator.
Is there a way I can put my name on a particular worksheet, and (even better) any charts that are created using it?
I'm not trying to be spiteful; just trying to get my name known as these things are passed around the whole company.
With the above code, is it possible to trasfer all selected charts, on to a new spreadsheet and print them to fit on one page Landscape, no margins?? Or is that stretching it, i tried it but i print them all A4
View 2 Replies View RelatedI need a macro to create the following worksheets and charts from an Excel data set:
Three (3) worksheets (already created manually in attached Excel file):
1. Chart Data.
(a) Column A in Chart Data is always numbered 1 - 600 (50 years x 12 mos/yr).
(b) Column I and column Y data sets (from Prod_Month) created in Chart Data. Each data set can be identified and collated with column F in Prod_Month (API) which is unique for each dataset.
2. Rate vs. Month - plot of Daily Gas (col. Y in Prod_Month) vs. Months (col. A in Chart Data).
3. Rate vs. Time - plot of Daily Gas (col. Y in Prod_Month) vs. Calender Time (col. B et. al. in Chart Data)
At a minimum, could someone help me create the Chart Data worksheet from the data in PROD_MONTH? Charting all the columns takes time from Chart Data but any data manipulation macro(s) help.
I am working on a huge amount of data and want to analyse that data through charts because charts are quick representation of the data and save a lot of time. I got some code from my friend, to read each row in a worksheet and plotted the corresponding chart on the new worksheet each time i.e., each row has one chart which is plotted on new worksheet each time.
But I don't want it to plot the chart on the new worksheet. I want it to plot the chart on the same worksheet. In my case there are always more than 30 rows, so it should draw 30 charts on the same worksheet in which 30 rows are written.
Here is the code which plots charts on the multiple sheets
Code:
Sub LineCharts()
Dim Ws As Worksheet
Dim NewWs As Worksheet
Dim cht As Chart
Dim LastRow As Long
Dim CurrRow As Long
Set Ws = ThisWorkbook.Worksheets("Sheet3")
LastRow = Ws.Range("A65536").End(xlUp).Row
[Code] ....
I have a spreadsheet with multiple pivot tables and graphs. Is there a way to add a scrollbar on one sheet so that when you scroll through it, it will display(one by one) each graph that I created with the pivot table(s) so that they're all on one page(still dynamic) as opposed to them being on multiple worksheets
View 2 Replies View RelatedI need help with a macro for copying and pasting of cells. I believe this should not be a problem for the Excel VBA experts, but for someone who can only record macro, I'm really at a loss.
Attached is a sample file, where sheet 'Source' is an example of the sheet from which data are to be copied. The other sheet, sheet 'Final' is an example of the final format that I need. The reason I'm doing this is I'm planning to upload my data into Access and so I need to convert them into a list format.
List of target columns in sheet 'Final' and source cells in sheet 'Source':
Column A: Biz ID - not sure if I really need this, by right it should be listed automatically once I paste the data
Column B: B2 of 'Source'
Column C: B2 of 'Source'
Column D: B1 of 'Source'
Column E: row 6, relevant column
column F: column K
column G: row 5, relevant column
column H: the specific amount
So basically I'm creating an entry for every amount in the table.
I have created a powerpoint that has linked charts from excel. Stupidly, I have saved both of these files (powerpoint and excel) on my desktop.
I need to save them on another drive (so they can be accessed by others) but i am worried that if i move the original excel file, it will break the links for the charts in the powerpoint file....
I have over 150 charts so I don't fancy going through and re-pasting each chart.
There is an autofilter applied to worksheet A, I would like to transfer only the autofiltered range from worksheet A to worksheet B, a clear worksheet B statement would also help.
View 9 Replies View RelatedI have two columns which i want to compare, they contain text data such as A123.
what I'd like is if its in column A and not in Column B then add to bottom of column A.
Once its in column A i can do the vlookup's to draw the other data, costs etc, over but don't know how to identify, and add, the missing codes to the list.
I have one worksheet from which i need to copy only few columns (Ex column A,B, D,G...need not be in sequence.....) to a new sheet.can you please help me to write a macro for this.In addition: Do we need to specify the number of rows in column or is there any way to get data till the end of column automatically.
My DB is in table format . I use this table as source data for 2 barcharts and 1 pie chart.Following are my table headers
Costs|exp heads|Month1|Month2|...|Month n|Spark lines|Average
When i add a month coloumn,Sparklines and Average coloumn should get updated automaticaly.Now this is not happening even if the data is in table format.I also want the graphs to be automaticaly updated.
I'm attempting to copy the contents of the first row in the "banking center" worksheet into the first rows of all the other worksheets in the workbook. Ideally, I'd like to select from A1 to the last column in row 1 to copy. Edit: Fixed a couple things but still having trouble with the copying section.
View 3 Replies View RelatedIn Sheet1, I have this:
Nos. Items Enter Qty
1 Item1 5
2 Item2
3 Item3 20
4 Item4 50
5 Item5
6 Item6 3
etc...
What I want is, whenever I enter the quantity in Sheet1 it will copy the row in Sheet2, say it will start in row 5 without the blank row and it is something like this:
Sheet2
Nos.Items Enter Qty
1 Item1 5
3 Item3 20
4 Item4 50
6 Item6 3
etc...
I have 2 workbooks, one is called AllData.xls and the other is SavedData.xls. I want to be able to copy only the highlighted data from AllData.xls and automatically populate to SavedData.xls by using a button.
View 9 Replies View RelatedI am trying to put some charts into a report that is pivot table based. I have some code that will work if the pivot tables stay stagnic but the users may change the tables around so that could be an issue of new data. I have the following code where I changed the source to the pivot table name (general name because of numberous report possibilites). I have taken out the other charts because they are just a variation of the chart 1. I am crashing on the line with the * on it.
Sub UWTierChart()
Dim oCell As Range
Dim oChart As Chart
Set ws_data = ActiveSheet
'Chart 1
Sheets(wsPT).Select
Range("B21").Select
[code]....
Excel Move-Copy Issue.pdf
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 a workbook with 2 worksheets. On sheet 1 (Roster) is a list of names; on sheet 2 (Summaries) is a set of calculations.
I want to create multiple copies of sheet 2 (Summaries) and name them according to the list of names on sheet 1 (Roster).
Creating and naming the worksheets appears to be working fine. The problem is that the worksheets that are added are blank, not copies of worksheet 2.
My code follows.
I’m building a data logger and all the info from data logger goes to sheet1 using serial port. I need to separate log1, log2, log3 to each individual sheet. Log1 must be copied to sheet2, Log2 must be copied to sheet3 and etc. The reason I need to separate Logs into different sheets so I can create charts for each Log automatically. Also I don’t know how big each log can be. Here is sample data what I’m getting to sheet1. I can change my datalogger to output text log1, log2, log3 to any numbers such as 9999 to make it easier. I need your help to be able sort out each data Log to each worksheet.
View 7 Replies View RelatedThe format of the data shown in sheet below is divided by '|' where it represents a cell divider.
Sheet1
-------
A | B | C
ClassA | ClassB | ClassC
Sheet2
-------
A | B
ClassA | Student01
ClassA | Student02
ClassB | Student01
ClassC | Student02
ClassC | Student03
ClassC | Student04
Sheet3 - Final Output
-------
A | B | C
ClassA | ClassB | ClassC
Student01 | Student01 | Student02
Student02 | | Student03
| | Student04
Sheet3 = check if there is a match between Sheet1 and Sheet2, if there is, then use Sheet1 as a header (ClassA, ClassB, ClassC) and paste the matched data under the respective header.
I have an Excel file that has several worksheets. One of the worksheets is a letter and one is an envelope. Instead of typing the name address twice I need to have th name and address info repeated onto the envelope each time I use enter info in the letter. I know how to do this with a formula but not with a text.
View 1 Replies View RelatedIs there any code that can be written so when a person selects a tab to be moved to a new workbook, the macro code in the existing workbook would be copied to the new sheet? I'd also like to use a button that the user could click on for the macro.
View 3 Replies View RelatedI have a worksheet with some arbitrary selection - it may be 1 cell, a 5 by 4 rectangle, or even a noncontiguous splattering here and there on Sheet1. I want to select the identical cells on another sheet. So I'm thinking something like
dim sht1 as worksheet, sht2 as worksheet
'set them appropriately, then...
sht1.selection = sht2.selection
Basically, I have a worksheet of client info on a row by row basis.
Each client has a ref number (eg A4 is the ref for the first client. A5 the next, A6 the next etc etc)
I would like to know how to copy and paste each ref number into worksheet 'Proforma Template (2)' every 11 rows down, until the end of the client list is reached.
So, copy/paste value of cell A4 into 'Proforma Template (2)' cell E9, then A5 to 'Proforma Template (2)' E20 etc (every 11 rows)
(I've read up about various types of loops but not sure where to go with it)
Once I have this on a macro, I'll use vlookup to take the rest of the data across. (im more familiar with using vlookup so should be ok there)
