Excel 2010 :: Setting Up A Large Spreadsheet?
Mar 2, 2013
I'm have Excel 2010 and Windows XP. Each week I get 3 spreadsheets and each has data unique to it. Each spreadsheet has a week number column which is common to all three. I want to combine the three worksheets into one and make create several dynamic charts for management. How should I organize a large spreadsheet? In addition to my week number I have a host of other date fields. Some of the data I get is (1) vehicle VIN numbers (2) City/State/Country (3a) I break up the VIN to give me vehicle type (3b) year of assembly (3c) car type (3d) number of doors (4) mileage (5) complaint (7) defect code etc. etc. What are the do's and don't when setting up a large spreadsheet? I have data by week which goes back to 2006 and so my date fields go top-down. I inherited the three spreadsheets and would like everything under one roof, so to speak. One spreadsheet which I can make my charts.
View 1 Replies
ADVERTISEMENT
Jan 31, 2014
I work with Excel 2010 and have a very large spreadsheet with data that I need to manipulate in several different ways. I have been filtering and then cutting and pasting but this is very time consuming . Is there a way to extract specific data from the spreadsheet and transfer it to different worksheets? I don't really know how to use macros.
[URL] .....
View 14 Replies
View Related
Jul 1, 2014
I am running Excel 2010. On a sheet that I have previously used many times, I select all, and set row height to 30. In the past, that has made the sheet fit nicely on one page. Nothing has been changed in the content or number of rows, but all of a sudden the result leaves me with a sheet that takes more than one page to print. It is almost like the number entered is being defined by some new unit of measurement.
View 2 Replies
View Related
Apr 17, 2013
In Excel 2010 I was working on a file setting it up to print. The file closed somehow and I just cannot reopen it. There are other files in the same folder and they all open normally.
View 4 Replies
View Related
Nov 16, 2011
I have inherited a series of Word reports containing links to charts in several Excel files. I can tell by the link in Word that one of the charts is named 'Chart 6'. Is there an easy way to locate which chart in the Excel file is 'Chart 6' (and on and on for all of the other charts linked in the Word doc)? There are upwards of 21 charts in each Excel file linked to each of the Word reports. I am using 2007 but the files are in 2003 format because of limitations of the program from which the data comes for the charts.
View 4 Replies
View Related
May 1, 2012
I am using Excel 2010. Why I do struggle with setting the range below
Code:
Set rng = Sheets("Data").Range(Cells(4, firstcol), Cells(lastrow, lastcol))
I get run time error 1004
Tried simple code from msdn and it return same error
Code:
Range(Cells(2, 3), Cells(10, 4)).Select
View 2 Replies
View Related
Sep 7, 2012
How do I make the column headings appear when I'm working on a large spread sheet so I don't have to scroll to the top each time to see where I am. This is on Excel 2007.
View 5 Replies
View Related
Jan 30, 2013
code to import a tab delimited text file with about 3 million rows so that it creates a new tab every time it hits the 1 million row limit?
View 3 Replies
View Related
Feb 9, 2014
How do I enter a formula in excel 2010 that will give the total amount of times each number is in this group. Example : how many times (total) the number 12 showed up , how many times the number 27 showed, and so on for each number that is in the entire group of numbers, from 1 to 80 .
Here is the page I will copy and paste into a workbook sheet from the internet that i want to evaluate the times each number was called.
Very new to all this , I am a bit aged and need not to learn excel A to Z, just need to know what correct statements /formulas have to be entered to do what i desire.
I am only interested in the total count of the small bold numbers 1 to 80, each single digit 1 to 9 and double digits 10 to 80 will be in their separate cells. The large bold three digit numbers and dates/times will have to be erased (manually) before the calculation takes place.
298
2/9/2014 12:28:02 PM
37
77
[Code]....
View 6 Replies
View Related
Sep 9, 2013
Im using excel 2010. Im looking to have a map of the world in excel. I work in sales with 2 other people and we wish to divide the world up by countries.
It would be nice to have the names in a list and colours represent the countries.
View 2 Replies
View Related
May 23, 2013
I have a system running Windows 7 Professional (32 bit) and MS Office 2010.
In Excel 2010, I have a spreadsheet that contains several hundred rows of data. When I cut and paste a section of data, Excel jumps to the top of the spreadsheet. This does not happen when I copy/paste, just cut/paste.
View 1 Replies
View Related
Oct 14, 2013
I just want to add it to my excel 2010. How can I add a date picker in my spreadsheet, when the cell contains a date format????
View 14 Replies
View Related
Jan 16, 2014
Open a brand new spreadsheet whether the format is set to "General" or "Text" it will not let me enter numbers. For example, when I enter 2007 in the cell it displays 20 07 not really that big of space between the two zeros - but still a space. I can't format this no matter what I do.
View 1 Replies
View Related
Nov 13, 2012
In Excel 2010, spreadsheet with part # in column A and customer code in column B. Many part numbers have more than one customer buying the part.
I need to rearrange the information in the example below, where there are two part numbers:
Part Cust
334 CCC
334 CHD
334 CIL
401 CIL
Looks like the layout below, where there are still 2 columns, part # and customer, but with the customer(s) concantenated in column B:
Part Cust
334 CCC, CHD, CIL
401 CIL
Can this be done with any wizard type tool (pivot table, etc)? I am sure it could be done with VBA.
View 5 Replies
View Related
Jul 14, 2014
We have a spreadsheet on a server.Without using code is there a way to show who saved the workbook last?
using 2010
View 1 Replies
View Related
Oct 17, 2013
Using MS Excel 2010.
As I understand it hyperlinks set in a spreadsheet should work regardless of where you save and/or copy the spreadsheet i.e. as long as the directory location of the location / file the hyperlink is referencing doesn't change (notwithstanding, the user must have appropriate access rights to the relevant directory locations)
However, the situation I have is the spreadsheet was generated and saved to directory location A (intention being this would be the 'master' yearly template) and the hyperlinks set, all of which work when you open the spreadsheet in this directory location. But when I copy the spreadsheet to directory location B, which is intended to be the yearly 'register' location for the spreadsheet, none of the hyperlinks work? When I hold my cursor over a link in the copied spreadsheet, in directory B, I do not get a 'pop-up' path like I do in directory A and when I click a link I get an error message:
Microsoft Excel The address of this site is not valid. Check the address and try again.
As stated above the documents the hyperlinks relate to have not moved, they remain in the same template directory (i.e. the link path has not altered).
View 1 Replies
View Related
Jun 2, 2014
I have been tasked with streamlining a process to collect data from a specific online website (Web of Science) and import it into an Excel 2010 spreadsheet.
Currently they are going to the website, entering a short number of search parameters and then manually recording the pertinent data from the webpage. They would like to be able to enter a keyword in Excel (which acts as the search item) which then automatically does the rest of the process and provides them with a spreadsheet of the required data.
Is this possible? Perhaps by using Visual Basic code within Excel? I also saw a method that employed SharePoint Server 2010.
View 3 Replies
View Related
Aug 22, 2012
We have a spreadsheet on a server location with macros. Different users will access the spreadsheet from one pc on different shifts. Is there a way to set the area as a Trust Location for all users on the PC or enable the macros in the spreadsheet to execute for all users without having to set up the spreadsheet trust location or macros for each user? I would like to have the spreadsheet accessable to any user on the PC without setting up individual access. The users can change for shift to shift.
View 2 Replies
View Related
Oct 10, 2012
Im trying to enter a formula for volatility in my excel 2010 spread sheet
my hig low close is listed verticaly in A,B,C
The formula for D1 is supposedly “={LN((A1)/(B1))}^2”
The formula for E1 is supposedly =SQRT(SUM(D1:D10)/10)*SQRT(252)*100
I put this in D1 and it is giving me an error
View 3 Replies
View Related
Jan 17, 2013
We updated excel from 2003 -> 2010 and this stopped working.
We have a macro which takes pictures from a folder and pastes those pictures in the excel -sheet.
At 2003 the pictures were correctly pasted to their positions, but at 2010 the pictures appear in somewhere at the same sheet. (not at the right places, which should be at column "o" at the same row.)
Macro (working correctly at 2003) :
Sub Kuvan_piirto(ic As Integer)
On Error GoTo loppu
SourceFile = Enari
DestinationFile = "Live1.JPG" ' Define target file name.
FileCopy SourceFile, DestinationFile
ActiveSheet.Pictures.Insert("Live1.JPG").Select
[Code] ..........
What should I change for 2010?
View 1 Replies
View Related
Oct 18, 2013
I am using MS Excel 2010.
I have a workbook with 2 separate spreadsheets.
Spreadsheet 1: GOLD
3 Columns:
A1 Number, B1 Name, C1 Acct Bal D1 (Empty)
Spreadsheet 2: Email
2 Columns
A1 Number, B1 Email
I would like to pull the email address for the corresponding Number From the Email sheet to the GOLD spreadsheet and have it end up in Column D
There are more rows in Sheet 2 than 1. I have already narrowed down the ones I need in Sheet 1. (Sheet 1 has 150 rows, Sheet 2 has 7315)
View 1 Replies
View Related
Apr 7, 2014
I am new to Excel VBA and am trying to create a macro that will draw information from a spreadsheet. The code i have written so far is shown below:
Sub Event1()
'Dim Event Date As Double
Dim Message As String
Dim Ans As String
' Prompt for Data
[Code] ......
The section i am having issues with is shown in red above.
What i am trying to do is have a message box pop up with the information as shown based on a date being typed into the the original box that pops up (Please enter a date and click on OK). The following message box then displays the required information from the spreadsheet.
View 4 Replies
View Related
Feb 19, 2013
I have a word template that gives a popup when started for the user to fill out. At present this is okay, but it is hard to maintain. So what I want is to be able to add all needed information in Excel - since our tools have the possibility to export my needed info to this.
I have a spreadsheet in Excel 2010 named 'Input TR'. This info I want in the popup macro in word. When choosing name from a dropdown menu - I want Excel to give me the choices instead of having it in the coded macro. After I have choosen the name - I want the product belonging for this name in the 'Product/Service:' dropdown menu, e.g Test 1 will give the value 1...5. (I will only be able to choose one of them)
Today - everything is coded in the word2010 macro, and thus difficult to maintain.
View 5 Replies
View Related
Sep 6, 2013
I have a word docx embedded within my spreadsheet .
Both are on Office 2010 versions and I have named the embedded word doc
docx = CCPBlank (named range)
sheet = Support Data
I want to open the word doc from within the spreadsheet from a user form I already have created for other module calls.
Any simple VBA code to open the embedded docx?
I have looked a previous posts and not sure they are suitable. I have embedded the docx as I want to ensure only that empty version is opened each time. It also means I only have to send one file (xlsm).
View 2 Replies
View Related
Jun 27, 2014
I am working with a very large spreadsheet 10k references... I need to add sequential numbers in a column to identify the references but I need to use he filter in the author column due to the way my referencing software exports the data...
When I try to use the pull down autofill it just keeps repeating the last or second last number of the cell - the autofil box that usually appears has disappeared.
Im using excel 2010
View 2 Replies
View Related
Dec 27, 2011
I'm using Excel 2010. One spreadsheet I'm using has 1048576 lines and is a XLSX file. The other file has 65536 lines and is also a XLSX file. When I try to do a VLOOKUP, I'm given an error stating "invalid reference. This file version cannot contain formulas that reference cells beyond 256 columns or 65536 lines.
If both are XLSX files how do I expand the amount of columns in the one spreadsheet with 65536 lines? I thought all XLSX files had a million lines.
View 4 Replies
View Related
Mar 11, 2014
I am setting up a few spreadsheets for a restaurant I work at and I am stuck on an excel matter. I am trying to have an ordered number transfer to a new spreadsheet that will apply that ordered amount to a monetary value. So all my cooks would do is put the prep list on dropbox and it would take the ordered amount by the recipe cost to get an invoice for that day.
Example:
1st Sheet 2nd Sheet 3rd Sheet
Prep List: Recipe Costings: Daily Invoice:
Sausage - 2 x Batch Sausage - $229.03 $458.06
Pesto - 3 x Batch Pesto - $74.04 $222.12
View 3 Replies
View Related
Jan 31, 2013
I have a large spreadsheet converted from pdf whose data still appears in A4 reading format.
I need to move part columns of data from 6 columns to form 1 large column in column A.
For example, move range B8 to B76 beneath range A8 to A76 and range C8 to C76 beneath that etc, page by page working through all 270 pages !
Also need to delete unnecessary 'page headers' throughout as in rows 2-6
View 2 Replies
View Related
Apr 11, 2007
how I would go about setting up a spreadsheet that will allow me to look at previous orders and forecast what I need to buy. He never got into trouble for ordering too much, but he did get caught on ordering too little. I am thinking something along the lines of the attached. However, if anyone is using something that looks or works better (or those who solve this little problem have done a better looking or working sheet) let me know.
There will be some Vlookups that need to bring in description and price (or some other function if there is a better way to do it). The min need and max need will be populated and brought in by vlookup. The order column should be where the forecasting happens based on previous orders. I am willing to have all the data in the same workbook. The second or third sheet can be used to store data in what ever format that is needed to be done.
View 8 Replies
View Related
May 29, 2014
I have a very large spreadsheet that was exported from an ecommerce site with close to 1000 products. I have one column that I need to extract some text from. This column holds all of the html from the product description and is huge. I only need to extract the actual description of the product, but am having a very hard time figuring out how to do it. I've tried using the mid, left, and right function; but not all of the html is the same so it's not really working the way I need it to.
I have multiple tags throughout the html that I can use with the mid function, but there is more than one occurrence of them. So, how can I tell it to start at the 4th occurrence? I've spent countless hours searching, but I'm a complete novice when it comes to excel and I don't even know what to search for. I end up looking through sites that explain how to pull the Y out of XYZ, which is what I need, just on a much larger (and more complicated) scale.
It was suggested that I set up a macro that will find the 4th occurrence of the word, and then uses the mid function to pull the data out, but when I try to find the word, it says it doesn't exist even though I can see it right in front of me.
View 10 Replies
View Related
