I'm working with a very large spreadsheet which has somehow divided itself into print areas. Each section has 'Page 1' or the equivalent as a background, behind the data itself. I thought it would be simple to remove this, but for the life of me I can't see how. I'm using Excel 2007.
View 6 RepliesThere's a 'background' button in the main 'page setup' toolbar. Presumably the 'format>sheet>background' thing was pre-2007.
Now my question is what image dimensions should I use to fill an A4 page? Does Excel have a specific dpi that I need to consider? I have Photoshop experience, I just need to know what Excel is looking for.
Can someone look at the sheet sample? I am trying to turn duplicates into a zero like Ive done in record 1 so that the same tax bill is not counted twice. The records are in rows and if I do a transpose and try to do it by hand it will take forever cause I have hundreds of records.
Excel 2007
BQBRBSBTBUBVBWBXBYBZCACBCCCDCE1txt_nme_taxpayertxt_nme_streetcity state txt_addr_1txt_parcel
Year 10Year 9Year 8Year 7Year 6Year 5Year 4Year 3Year 2Year 12QUINCY'S REALTY INC % RASH & A19900
HOLIDAY LNCHARLOTTE, NCPO BOX 16003192170500.55516.22712.71768.860000780.713FERGUSON, BENJAMIN10733
MONTECARLO DRCHARLOTTE, NC3508 SARGEANT DR151840720.4423.5180.381.988.2387.689.1789.1789.1789.174HARVEY,
[Code] ........
I have recived a CSV file with dollar amounts that need to be formated with out a deciaml and with our rounding. Example I need 12558.64 to be changed to 1255864.
View 3 Replies View RelatedI have several sheets with about 250,000 rows per sheet.
But, even I sort by Column A, there are STILL hundreds or rows that are total blank interspersed down the page . . . I can't autofilter for blanks because there is too much data . .
How can I get rid of them?
I've got a whole load of cells that have a pipe ( | ) on the end of the value which I'm trying to remove.
Easy enough thinks me, so;
Code:
=LEFT(AB188,LEN(AB188)-1)
And then Copy / Paste Values Still has a pipe on the end... I check the cell for trailing spaces, there are none...
I check the length of the cell (658) against the length of the result from the formula (657)...
So, my formula works, but when I copy and paste as values the pipe remains.
I'm using Excel 2007 and the cell contatins other pipe characters I'd like to keep in there so I can't find and replace or anything.
I am using Excel 2007 on Windows 7. I would like to remove duplicates as follows: If column A = column A, column B = column B, and the two rows are within one hour of each other, then remove all duplicates, leaving one instance of the row. As you can see, sometimes the duplicates are right next to each other, and sometimes have rows between them. (Rows 1 & 2, Rows 30 & 32). Even though this sample doesn't show it, sometimes there can be tens of duplicates within an hour, not just two.
Excel 2007
ABCD1EruptionI Can't Stand The Rain (78)3/7/20129:12:55
AM2EruptionI Can't Stand The Rain (78)3/7/20129:10:02
AM3ChicagoJust You 'N' Me (73)3/7/20129:05:59
[Code] .........
The title in the attached chart is a camera shot transferred from another excel 2007 worksheet in the same workbook.
I'd like to remove the border line, I've tried right clicking... then format picture ...no dialogue box comes up. I've scrolled through all the commands in the ribbon + non ribbon commands and can't find anything that seems appropriate that's not greyed out ....
border line.docx
When I duplicated a worksheet in Excel 2007, I received a warning that "A formula or sheet you want to move or copy contains the name ___" (an existing Name) and was given options. The Name in question should not have been relevant because I never intentionally linked it to the worksheet that was being duplicated, but apparently something happened at some point to create such a link.
I opened Name Manager and deleted the Name in question, and this invoked a warning. "Privacy warning: This document contains macros, ActiveX controls, XML expansion pack information, or Web components. These may include personal information that cannot be removed by the Document Inspector." I had no macros. Each time I attempted to save the document, I got this error/warning, even after disabling Macro Security completely.
It was still saving, fortunately, so I closed Excel and relaunched, and the issue seemed to vanish.
Should I be worried about the integrity of my document? Everything seems fine now, but I'm a little concerned.
I am having trouble delete a drop down list inspite of selecting clear all from the data validation tab in excel 2007. When I hit Alt + Down Arrow, I still see picklist options. I didnt set up the spreadsheet, hence I am not sure how to begin troubleshooting.
View 1 Replies View RelatedI have been trying to write a macro to add a page break in Excel 2007, but I have had no success.
A friend recomended:
Columns("CC:CC").Select
ActiveWindow.SelectedSheets.Vpagebreaks.add Before:= ActiveCell
This has not had any affect when I have printed.
I found this template, it works great, I have customized it to fit my business. One thing I cannot seem to change is the cell background on the shift tab. I am able to change the background but on the schedule tab when I select a shift the background is still the same. Here is the template [URL]
View 9 Replies View RelatedMy OS is Windows 7. My version of Excel is 2007. I have read how to get a macro to move around a page in a relative way, but is there a way to move from page to page in a relative way as well?
View 5 Replies View RelatedExcel 2007.
I have a workbook with a sheet per day, each sheet has a variety of 'jobs' as columns and a variety of people and kit as rows. Hours are manually input each day during the month.
Simplified version... These are two separate sheets 'M060114' and 'Tu070114'.
Monday
Dig
Drive
Dave
4
5
Bill
2
7
Tuesday
Dig
Drive
Dave
2
7
Bill
8
1
I have a Pivot Table on a separate sheet. This was created using the Wizard (ALT +D +P).
Dig
Drive
Dave
6
12
Bill
10
8
So far, lovely.
But when I double-click on a number or right-click and choose 'Show Details' I don't get the sheet names in the newly created information sheet. I get the Row label, column label and a list of the entries.
So if I clicked on 10 above...
Row
Column
Value
Bill
Dig
2
Bill
Dig
8
That's fine with just a couple of entries but with about 80 columns and 250 rows spread across a month, therefore 30ish sheets, it's difficult marrying up the 'Show Details' sheet to the actual data.
So after all that, the question. Is there a way of getting the sheet name to appear in the 'Show Details' information sheet?
I have an excel spreadsheet I have created as a printable form. It all fits nicely onto one page. I would like to be able to email it to people and have it look like a one-page form. It looks great in Page Layout view, but the only problem is that there are a bunch of extra sheets that show up as well. Is there any way to remove/hide these extra sheets that are not needed? Or is there another way to send this out so that it comes to folks as a one-page form so that they can alter the data in the cells but not the page formatting?
View 1 Replies View RelatedI want to do the following -
Whenever I enter a value say "X" in Sheet1, ColumnA I want the value to be autofilled into sheet 2, ColumnA if and only if value does not exist in sheet2, Column A.
How to achieve this in Excel 2007 ?
I would like to add a makro that will ask, through a pop-up, to name a new sheet.I have the following formula that creates a new sheet and names it BMW and moves it around a little bit:
Code:
Sheets.Add After:=Sheets(Sheets.Count)
Sheets("Sheet1").Select
Sheets("Sheet1").Move Before:=Sheets(6)
Sheets("Sheet1").Select
Sheets("Sheet1").Name = "BMW"
But I would like a formula that asks beforehand, through a pop-up, of a preferred name. In this case I will write BMW in the pop-up, and the new sheet will be named BMW.
Using XL2007 on WinXP.
I am not able to add a new Excel sheet in a existing file when I right click next to the existing page it gives this option only and I am using Arabic Charcters + I am not having too many sheets
View 1 Replies View Related I have been tasked with overhauling some simple inventory records that are currently being tracked via multiple spreadsheets and in multiple formats over various years. Thus far I have combined the data into two simple sheets (1 & 2) of the same Excel workbook. The first is just the basic listing of current inventory and locations. The second is a record listing various shipments into and out of the company location as a history log. I'm going to be continually trying to clean up the data and make things easier for the staff. The shipping history/log (Sheet 2) contains basic information in columns that include the serial numbers of the items shipped, which correspond to the S/N's in the global list columns within the inventory sheet(1). I would like to find a way to set up where a column in the inventory creates upon click (or have a maco button with the ability to) a popup which will display the history of the current rows serial number. In effect, list all rows in the second sheet with corresponding serial number or as a reverse strategy; filter out the rows that do not have the same S/N listed in one of its columns.
A piece of inventory comes in and is logged into the global inventory sheet (1) with Serial # ks1254. Likewise the shipping sheet (2) has the shipping information and document info logged with the same serial # listed. This is item has arrived and been shipped out multiple times, and occasionally the history of this item is requested. I have a column set aside in sheet 1, that i would like to act as a trigger for the above request. So if I filter and find the mention item, I would like the trigger to go and select out only the rows in sheet 2 that correspond to the S/N of the item in question. This can be presented as a pop up tab, a small window, even as a new sheet altogether I suppose. I guess I'm using Excel 2007, have a very dated limited VB skill set, so just hoping for some direction and steps.
I am using excel 2007 and when I right click on the worksheet tab, delete is greyed out. My workbook/sheet is not shared. I also had the problem owith row and columns. CommandBars("row").Reset sorted that out but I can't seem to sot out the tab issue.
View 6 Replies View RelatedI am trying to copy two columns to a different sheet in vba code. I will ultimately need to do this multiple times but I think I have the iteration part ok, it's just the copy part that seems to be wrong.
Code:
Worksheets("Lookup").Select
Range(n & lngRevStart & ":" & n + 1 & lngEndRow).Select
Selection.Copy
Worksheets(strDeptSheet).Select
Range(Columns(o), Rows(m)).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
The original code I used for this works great on one column but I knew the letter column each time I used it. Now I am trying to get two columns at a time and will be iterating through several based on user selections. I figure that will be faster to do both columns as the two columns are side by side.
I am getting an error on the PasteSpectial line "Run-time error '1004' PasteSpecail method of Range class failed.
I'm not sure where to go with this but I am assuming I have a problem with the Range selection lines on either the source or destination or both. The support is just for Macro errors.
Am using a VB for auto transpose values to sheet 2 from sheet 1 in MS EXCEL 2007.
What code to add to the already existing VB so that if someone is using the sheet and leaving the cell in E12, for example, and saving it, then the next user should find it again on A3 but not on E12.
The sheet should always open on A3..
I have a file that has an original file format .xls
I saved as .xlsx (I am using Excel 2007) with a different name so I could make changes to the new file without changing the original.
That turn off compatibility mode.... but it is still "shared". While it is shared I cannot delete a sheet. In fact, I really don't even want it to be shared. If the file is open, and someone else opens it, I want it to open as "read only". I cannot uncheck the "Allow changes by more than one user at the same time. This also allows workbook merging." checkbox because it is greyed out.
My knowledge of Excel 2007 is minimal, from formatting individual cells, to creating column totals. I've used it for years in my household budgets. I have an attendance form which is about 3 pages long; currently, it's separated at page breaks, with column totals at the bottom of each 'page'. This is easy because the Row #s are infinite, right? Lately there have been regular adjustments, and I believe the project might be less cumbersome if it were spread out on separate sheets, but how to bring the rows of column totals to cumulative totals on the last sheet.
View 6 Replies View RelatedI am importing data into an Excel 2007 worksheet from an online form. They are answers to 30 questions for up to 250 respondents. I was expecting to import one row of data for each respondent however the data is importing in a step like manner as below
Q1Q2Q3
AF169856 Y
AF169856N
AF169856N
AF145723 N
AF145723Y
AF145723N
Any formula/solution to bring all of these responses into one line for each respondent ?
My set up office 2007 win xp pro ie8
is it possible using vba ideally with a button marked save, to save a single worksheet and name it, in CSV format
Then I would like to be able to do the reverse load a CSV file back in to a work sheet
Expanding upon this
1. Click a command button with caption “save”
2. Take the name of a given sheet, in my case DataToUpLoad and append it with a number to give a sheet name of DataToUpLoad 1 the first time it is save and DataToUpLoad 2 the next time and so on
3. Click another command button with the caption “load” interact with usual dialog box.
My current work around is to copy a sheet open a new work book past the sheet in the save that work book as CSV
The reason this is required is to mate up with the php on the server side
Excel 2007 I have 80 very similar sheets. The only difference is the sheet name (Phase A (1), Phase A (2) etc.). I want the formula located in cell B5 to be different on every sheet.
I have listed the desired formulas on a single seperate worksheet, named "Overview". On this sheet, the following columns have these data in them:
A - Sheetname (example: Phase A (1), Phase A (2) etc.)
B - Cell location (example B5, constant)
C - A formula (example: =Sheet1!G47, =Sheet1!G48, etc.)
I would like to create a macro that will loop through all the sheets, doing the following:
1. Check if the sheetname exists in column A of the Overview sheet
2. If it does, take the formula from column C of the Overview sheet
3. And put it in the cell specified in column B of the Overview sheet
Here is some code, to illustrate the above. I know the code is mostly nonsensical.
Code:
Sub Enter_formulas()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
[Code]....
I can run this code successfully:
Code:
With ActiveSheet.ChartObjects("Chart 2").Chart
.Axes(xlCategory).TickLabels.Font.Size = 20
End With
But this code throws a "This Object Is No Longer Valid" error when it gets to the first .Axes line:
Code:
Sub ChartFormat()
'
' Format Charts macro
'
Dim ch As ChartObject
For Each ch In ActiveWorkbook.Sheets("Summary").ChartObjects
With ch.Chart
.Axes(xlCategory).TickLabels.Font.Size = 16
[Code] .......
I'm using Excel 2007.
I've got a formula that gives me an "#N/A" in a cell when certain conditions are met, otherwise it gives me the results of a calculation.
On the line graph that goes with uit, the "#N/A" is being treated as a zero.
I have spread sheet and values in some columns have highlighted in color.What I have to do is I need to quickly separate the highlighted data and put in the other spreadsheet.
View 5 Replies View Related