I've created a spreadsheet which, on running a macro, imports data from a text file, formats it and then sums various parts of it giving me a subset of the large file as a range of data for a chart (a pie chart) on Sheet 2.
The problem begins when I delete the data in the worksheet in preparation for another import - the Pie chart just loses all the data and I have to manually reselect it in the chart each time.
Once deleted the chart is blank, but as soon as the data is imported, I get reference errors when I click on Sheet 2
I must be doing something wrong. You can delete data and repopulate it and the chart should pick up with the new data. If the cells it is referencing are empty, it is blank. Not so here.
Is it to do with importing the data? Or the formula for my chart data?
I am working with Microsoft Excel 2003. I am trying to import(or something like it) from worksheet (A) to worksheet (B). Worksheet A is a spreadsheet that I have saved to keep the same row names, etc. but the information within the named cells is forever changing. I also save the information from worksheet A, but have another copy that when I open, it always opens without any changed data in it. MY question/problem is that I need to import the data from A to B, and every time that A changes, I need B to automatically update the data and continuously add to the spreadsheet I have made up for B. I can NOT have A overwrite any data that I have already put into B.
I have a workbook that requires refreshed source data each day. The workbook has all of the macros and formulas that analyze the data. I have the following code to import the worksheet with the raw data (onto a fresh worksheet in the calculation workbook), but I would like to create code that also adds the date and time to the imported data worksheet -- not the date/time the raw data was created; instead, when it was imported into my calculation workbook.
Below is my code for importing the raw data worksheet:
I have a number of large CSV files with approximately 1.9 million rows, (this is more then excel can bring in). I typically have to import/delimit the files when brining them into excel. However, when I try this I get the message not all data imported. I would like to be able to split the records in the csv file to multiple tabs in the excel woorkbook when doing the import/delimit but do not know how to accomplish this. The delimit of the data varies each time due to the nature of the data so doing a macro is more trouble to create each time. Currently I am having to open the csv file in notepad and split it up into multiple files then import each new file seperately.
I keep track of returns for my company and I am pulling a CSV file with all of the information on it.
I want to be able to format the info and create new columns for info I enter in to the sheet, and be able to import the updated CSV file into my already formatted sheet.
The part that I am wondering about is, after I import my first CSV file(sheet1) do I need to create another sheet(sheet2) and format sheet2 and have it pull the info from sheet1, then when I update workbook1 the data will update in sheet2?
Or, is there a way to just import the new data a single formatted sheet that I created from the old data and have it just add the new data without messing up any of my formatting?
I'm working on a sheet to analyse data in .CSV format, sofar I can import the .CSV file correctly, however I would like the Macro to name the sheet with same name as the .CSV file.
As i'll be importing multiple .CSV files. The code I have sofar is:
I have attached two files, one the sample txt file imported to excel but the top area is highlighed with some notes and section break. RED deleted don't need amd un highlighted is actual data. The other file is what I would like to see the data look like after parse.
I need to clean out unnecessary data from a file, (see attached text file), I'm not sure how to go about this in excel. basically every file starts with 9 cells that needs to be deleted, two cells of real data then one with garbage that needs to be deleted, it goes like that for 40 cells, then again 10 cells of garbage that needs to be deleted, then 40 of real data and goes like that up to 3000 lines, I know it sounds confusing but if you take a look at attached file, at the end I need to have all cells full of data
I need to bring in 2600 student names from a cvs file and have it formatted to an Excel workbook.
When it imports into the Excel file I need it to populate the proper boxes, such as: StudentLastName StudentFirstName StudentID GradeLevel TeacherName TeacherID RoomNumber
I have the CVS attached. Hope I can get this done. As you can see it shows the teacher's name with their first initial, their teacher number that they are identified by and their room number. I need the student ID as well but not the phone number and the days of the week. This would save a lot of work.
I have a file with four sheets – File1, File2, Association and LookList. File1&2 are totalled, as is Association sheet but then are checked against each other using the totals. What I need to do is the following (but I am not sure how to do it using macro…)
Step 1 - ‘File1’ Sheet – It all comes in text format. Firstly, convert all of column B=>used range (it may vary to 40k records!) into numbers and total each column. (I know the principal behind it – have a total variable for ColB, loop through and when it finds >0 then increment buy one and output under the last cell in that column – but I do not know the macro code)
Step 2 - ‘File2’ Sheet – Again, it's in text format. Firstly, convert all of column B=>used range into numbers and total each column(would contain same amount of records as Step1!) .
Step 3 - ‘Association’ – same steps as for File 1 (again – same number of records).
Step 4 - THEN (and I have NO IDEA how to do this!...) I need to check the File1 & File2 against Association using the lookup and return the Serial number and the Association heading that does not match on a fourth sheet.
The problem is that – for example – Field-1 consists total of more than one column – contains 3 but could contain a total of up to 6 columns! - I understand excel formula ‘vlookup’ but am not sure how to do it when it is a combination of columns and even less when applying it to this! – In fact, for a macro I am not even sure what column format the lookup list should be!
I am using Microsoft Excel 2003. There are several charts in the worksheet and the ranges for the series in the charts are defined by named ranges, e.g.:
Values: =FirstNamedRange
where FirstNamedRange is defined as Sheet1!A2:A100.
The values in FirstNamedRange are themselves calculated from other inputs. The problem is that when I recalculate the sheet, changing the values of FirstNamedRange, there are times when the chart does not change.
This happens sporadically. 9 times out of 10 both the values in the range and the chart change. At other times, the values in the range change and the chart doesn't reflect this. If I save the file, close and then reopen, (thus forcing the chart to recalculate?) then the chart looks correct.
I have a chart that display data from a dynamic named range. Problem is the chart only displays the correct data when I first input the named range into the data source on the first attempt. When the dynamics of the named range change, the range the chart displays remains the same. I have read another post on here where someone had the solution, but I couldnt get it to work for me.
I am inputting the named range into Data Source-> Data Range. The other thread said to put the named range into Data Source-> Series. I am unable to enter my named range into Series. I have also tried putting the .xls filename followed by !(named range) into the series boxes but excel will not allow me to do this either.
I'm trying to do a simple loop which creates charts based on an ID number. I recorded a macro and has tried to modify it but am having trouble defining the correct reange when settign the data source. Here is my
I have a number of charts (mostly pie) I don't have a legend, but I do have "Show label and percent" selected.
When I add in new data the actual chart updates to show the right sized pie slices... but the values on the labels don't update as well. I can't figure out how to make that happen?
I am trying to create a simple xy graph in Excel 2010 using dynamic source data.
I have data in three columns.
There are headings on line 2 and the data starts on line 3.
A B C 1. 2. dp ss ff 3 .1 .2 .3 4 .3 .4 .4 5 .4 .8 .7 6 .1 .6 .8 7 .3 .5 .1 8 .5 .4 .4
I want to create an XY chart with C3 to C8 as the X axis (or dynamic to what ever the last data point is) with A3 to A8 as the Y axis (or dynamic to what ever the last data point is).
I have Defined names for C3 to C8 (myXvalues) and A3 to A8 (myYvalues).
I have created a simple XY graph and selected the ranges as normal.
This is =DATA(,Data!$C$3:$C$9,Data!$A$3:$A$9,1)
The page is named DATA
What I am trying to do now is to edit this range to make the range dynamic.Unfortunately I get error messages which ever way I try to edit the range.
I have created a spreadsheet which uses data validation to allow a user to select a company, start Date, end date, and projected months in order to output different figures. I have attached a spreadsheet to this post in case that was hard to understand.
Since there is data validation, indexing, and matching going on, as different selections are made, various tables change as a result. Uou will be able to see what I mean as you open the example sheet and start messing around with the data validation boxes.
The problem I am encountering now, is creating an exponential graph that will also keep changing as the user changes their selections in the data validation boxes. I am unsure if this is even possible, but I figured it was worth a shot to ask. On the example sheet, I have included a graph similar to the one I want, but it only contains data in a certain range of cells, rather than dynamically changing to accommodate whatever data is outputted.
Here is what I am looking for in the graph: 1. Whatever dates are selected by the user in the data validation boxes, along with the projected dates will be on the x-axis. 2. The PMPM figures associated with the selected dates, and the projected dates on the y-axis. 3. Ability to make different selections from the data validation boxes and still have a dynamic chart that keeps updating itself.
VBA code that would update a chart automatically as you change the inputs which are located in cells in excel. The inputs are located in cells B5:B9 and i want a code so that as you change these numbers the chart would automatically update.
I have the same question as described in Graphs Not Updating When Source Data Updated; however, the poster did not reply to the request-for-clarification questions.
My chart does not always update when my source data changes. My Calculations setting is Automatic (not Manual). There is no macro code working to produce the source data or the chart. My chart is on the same worksheet as my source data. The source data is simple links to other cells in the same workbook that update as the underlying data is updated. Saving doesn't work. Manually calculating (F9) doesn't work. The only way I have found to get the correct data to display in the charts is to open the Source Data and re-enter the Series range. Obviously, that gets old.
I am dealing with plotting large amounts of data (millions of cells) across multiple series. Everytime you click, add a new series or do anything it redraws the graph taking a while. This Is there are way to prevent Excel 2003 from plotting a graph until you are done setting it up?
We have an excel template with numerous VBA and Macros embedded within it, saved on a central drive. I am able to access this file ok, however, when I save it when it is reopened by either myself, or a colleague, we get the "File error: data may have been lost" message. Everyone else within my organisation can open the template, edit, and save and subsequently reopen the spreadsheet without any problems at all.
One thing I have noticed, which to me seems strange is that the files I save that have the "error" message are slightly smaller in size than the ones my colleagues save (350kb vs 417kb)
My IT department have tried unintalling Excel and reinstalling, and also rebuilding my profile, all to no avail. A trainer has sat with me to check I am not using the spreadsheet incorrectly (or differently to anyone else, and this is not the case).
I know, I know... should've backed it up... there exists no other copy of the file in question newer than it's initial creation two weeks ago (been working on it solidly since).
The data does appear to be there but, rather mixed up... does anyone know of any methods/tools/software that might be able to salvage as much of the data (needs to be in it's original structure as it's a cross match excersice) as humanly possible?
I have created some Excel files using Excel 2000 on Windows Server 2003. The Excel version is given as 9.0.6926 SP-3. When I open them using Excel 2000 in Windows 2000 after a few sheet deletions I get the error message "File Error: Data May Have Been Lost" when opening the files. The Excel version is given as 9.0.8948 SP-3 in Windows 2000 (why is it different to the version number in Server 2003? Could this be part of the problem?) It crashes on this line
If Sheets(3). Name <> "template" Then
with the error "Run time error 32809 Application defined or object defined error".
The template sheet is very hidden. When I try and unhide it I get the 32809 error again.
