Computer Support Forum

Excel worksheet page length

Question: Excel worksheet page length

I have 2 Excel files that I create for my company, a list of items we sell, one with prices and one without.  I use 2 columns on a page for both of them.  Other than the prices, they are exactly the same.  However, when I print them out, the one with prices breaks one row lower than the other, even though the margins, row height, and other page setup settings are exactly the same, as well as the printer.  I would like to make them the same, as it makes it easier to copy and paste new data between them.  Any help would be most appreciated.
 

Relevance 100%
Preferred Solution: Excel worksheet page length

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Excel worksheet page length

A suggestion for a quick and dirty fix !  You say it is the list with the prices that is breaking one row lower. Go into 'Print preview' and 'Setup . . .' and increase the bottom margin very slightly, say by 0.1 cm. this should make it break a row earlier to match the other.
 
Apart from the elegance aspect, does it make a difference that it is the printed version that is showing this behaviour ?  Surely, any copying and pasting you are doing is done on screen and you imply that any misalignment is only showing up in the printed version.
 
Chris Cosgrove

3 more replies
Relevance 77.08%

Does anyone have any suggestions as to how I can fix this problem.  I have excel open and it seems that the actual worksheet has been minimised (even though the main excel window is maximised) and the first two columns of the worksheet (e.g columns A & B) are off the page.  Would appreciate any suggestions!  Thanks, ljc.

Answer:Excel worksheet half off page??

This is what I understand your problem is - Excel is maximized, but you have a small window inside Excel, which is your worksheet.You want the worksheet maximized.Right?If so, the small window will have close, minimize and maximize buttons, same as the main window.Press maximize, and it will go back to its full size.Does that help?

10 more replies
Relevance 75.44%

RE: Excel 2007
Worksheet page numbers are no longer at the bottom of the page.
What can I do to view them?
Help!!!
Jazdup
 

Answer:Excel 2007, Worksheet Page Numbers Disappeared

Hi there, welcome to the board!

What do you mean "Worksheet page numbers"? Can you describe for us what exactly which you are looking at and what view type you are in?
 

3 more replies
Relevance 74.62%

Hello,
I have a conundrum and I hope somebody out there can understand what I am talking about. I have a spreadsheet I am developing where the first worksheet is a table of contents and summary, and I have over twenty worksheets that all contain data for different items.

I would like to be able to click on a cell within my table of contents worksheet and have the relevant worksheet open so I don't have to keep scrolling through endless sheets. I have to log a bunch of defective items and keep notes & tallies on them so if there was such a function as this it would really help me out! (I really don't want to have to do this on Word) My searches on Excel's help page have all been in vain - seems like nobody has ever asked this question (or nobody has in a way that I understand). As you can probably tell, I don't know a whole lot of technical jargon. I am a beginner at this, so please keep it simple! Thank you!!!!!
 

Answer:Solved: how to link an excel worksheet to a tabel of contents page?

CTRL+K is the hotkey combo for "Insert Hyperlink".

Then choose "Place in this document"; from there, it's self-explanatory.

Welcome to the board.
 

3 more replies
Relevance 70.52%

Hello,

I need help with a formula. I need the formula to calculate totals from 10 worksheet.

Totals to come from C164 from each sheet to total in the summary worksheet D20. I can't seem to get it past the first worksheet. This is the formula that I have. The work sheet are named xx1-xx10

=Sum(xx1!c164,xx2!c164,xx3!c164,xx4!c164,xx5!c164,xx6!c164,xx7!c164,xx8!c164,xx9!c164,xx10!c164) IIs this possible?
Please and thank you!

Answer:Excel Formula using multiple worksheet to calculate into a summary worksheet.

Moving thread to the Office Forum for better results

2 more replies
Relevance 69.7%

Hi,

I have one worksheet with 3 colums and rows.
I need to create a new dinamic worksheet from the data on the 1st sheet.
Columns in the 1st sheet are:

Material Plant Quantity
------------------------------------------
AAA 1 100
AAA 2 50
AAA 3 20
BBB 1 30
BBB 3 10

I know descriptions for the Plants: 1 - "East", 2 - "West", 3 - "South".
I have to create macros or formulas to build a new worksheet from information on this one. It is basically take a Material group by, then Plant and sum of Quantity for that specific Material and specific Plant , and build a column for that specific Plant, with provided description. So if its Plant =1 , then column is "East", and so on.
So, essentially the new worksheet shooud look like this.
Quantity for Materials based on Plant.

Material East West South
-----------------------------------------------------------
AAA 100 50 20
BBB 30
BBB 10

Can someone give me tips on how to build that new worksheet and how should i build macro?

Thank you,
Vadim.
 

More replies
Relevance 68.47%

Hi Wayne, I have another one...

I have two Excel Sheets. One is a list I call database with all of the information in a list. The second sheet is ?prettied up? into a the looks of a nice form (but not a form, just formatted to look nice).

I have the same column names in both locations. The list layout is landscape and the ?form? is portrait. The data in each row of the list/database is what I would like to have prepopulate into the ?form? below to print a single record, but I can?t figure out how to make this work. The data in the list will change continue to have data added at the bottom.
 

Answer:Excel - Prepopulating a worksheet from a worksheet list

would you change the image to an actual spreadsheet with a sample
also the image is a screen shot of the other post
 

1 more replies
Relevance 61.5%

I have a spreadsheet that I put on a group drive for another region of the state to use. This spreadsheet was done in Excel 2007. It was working fine until the other region updated their Excel to 2013. Now the other region is having trouble with the spreadsheet; namely the drop-down boxes are showing that there are no values, but there should be a list of people in the list. When I open the spreadsheet it works fine. Because the other region is four hours away, I can't just go and look at it on their computer. Is there something that the other region (or that I) need to do to make the spreadsheet compatible with Excel 2013?

Answer:How do I make an Excel 2007 worksheet work in Excel 2013?

Take a look here:http://www.ozgrid.com/forum/showthr...

7 more replies
Relevance 60.68%

Hi

I am looking to create some code to move a sheet from one file to a new excel file. SO the code needs to open a new excel workbook and place the required sheet in the resultant new file.

I have managed to do this with an existing file "Moved Pivot" per the code below. This is ok but other people will be using my sheet so the location needs to be chosen by them. A new file seems to be the only solution?

Workbooks.Open Filename:="C:\desktop\Optegra Installer\Moved Pivot.xls"

Dim oTargetSheet As Worksheet
Set oTargetSheet = Workbooks("Moved Pivot.xls").Worksheets(1)
Call ThisWorkbook.Worksheets("PIVOT_TB").Copy(oTargetSheet)
Set oTargetSheet = Nothing


Any help much appreciated. Thanks

Jeremy
 

Answer:Solved: Excel VBA to move worksheet to new excel file

8 more replies
Relevance 60.68%

With due respect and credit to DerbyDad03 whose earlier post gave me the code below; is there any way to have the new worksheets created from a variable length field e.g. a persons name in a list or a field of fixed length other than a date as the script below uses?Sub CreateMonthlySheets()Dim lastRow, mMonth, tstDate1, tstDate2, shtName, nxtRowOn Error Resume Next'Turn off ScreenUpdatingApplication.ScreenUpdating = False'Make a copy of the data sheet and sort by date Sheets("Sheet1").Copy After:=Sheets(1) Sheets(2).Name = "SortTemp" With Sheets("SortTemp") lastRow = .Cells(Rows.Count, 1).End(xlUp).Row Rows("2:" & lastRow).Sort Key1:=Range("A2"), Order1:=xlAscending 'Using SortTemp Sheet, create monthly sheets by'testing Month and Year values in Column A'Loop through dates For Each mMonth In .Range("A2:A" & lastRow) tstDate1 = Month(mMonth) & Year(mMonth) tstDate2 = Month(mMonth.Offset(-1, 0)) & Year(mMonth.Offset(-1, 0)) 'If Month and Year are different than cell above, create new sheet If tstDate1 <> tstDate2 Then ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count) 'Name the sheet based on the Month and Year ActiveSheet.Name = MonthName(Month(mMonth)) & " " & Year(mMonth)'Copy Column Widths and Header Row .Rows(1).Copy ActiveSheet.Rows(1).PasteSpecial Paste:=8 'ColumnWidth ActiveSheet.Rows(1).PasteSpecial 'Data... Read more

Answer:Excel Macro to create new worksheet in Excel 2010

I created a quick macro to help you out. This macro creates a new sheet and names it using the contents of cell "A1".Sub CreateNewSheet()
Dim NewSheet
Dim SheetName As String

SheetName = Worksheets("Sheet1").Cells(1, "A").Value
Set NewSheet = Sheets.Add(After:=Sheets(Worksheets.Count), Count:=1, Type:=xlWorksheet)
NewSheet.Name = SheetName

End Sub
Law if Logical Argument: Anything is possible if you don't know what you're talking about.

4 more replies
Relevance 59.04%
Question: page length

Not for default but for a single page, I want to extend the printing below the point at which the print begins a new page.
 

Answer:page length

Welcome!

In what program do you wish to accomplish this? (Excel, Word ... etc)?

Have you tried setting a custom paper size, specifying it as longer?
 

2 more replies
Relevance 58.22%

So im using Excel 2010, and i making a timetable.

Right now the row going across saying period 1 2 3 they are all different sizes, some will be bigger and some would be smaller. I was wondering if there is a way to make them all the same size.


If you dont know what im talking about ask for a screenshot.

Im to busy to upload one now

Answer:Row Length in Excel

do you want the rows to all be the same height?

click on the first row number on the left - shift-click on the last one to select all the rows.

then right-click on the row numbers >> row height >> type in a number...

you can do a similar thing with the columns too.

is this what you meant?

4 more replies
Relevance 57.81%

I recently downloaded a pdf doc from the Intel support site. When I open the doc it says it is 14 pages long. When I try to print the pages all I get are very small (and I mean small )thumbprints of other pages
On closer inspection I find each of the 14 pages is not the usual A4 size page. The pages can be as long as 25 x A4 size long. In total the whole doc is about 200 normal A4 size pages.

Is there any way I can insert page breaks into the numerous pages on each page.

I suppose I could always set my printer for banner printing but I would end up with individual pages feet long.
 

Answer:Solved: pdf docs page length

8 more replies
Relevance 57.81%

I am new to Excel and can't find out how to limit my "book" to 2 pages. I know how to print only 2 pages (the other 424 are blank and will remain so) for my own purposes. However, I am e-mailing the file to others, so I want to simplify their work by eliminating the blank pages.

Still looking for a way to convert this to Word....

Thanks in advance for your help!
Tricia
 

Answer:Excel - document length ???

10 more replies
Relevance 57.81%

Not very fluent in Excel. I am setting up a positive pay format for my company to transfer check information from my PC to a bank via an ASCII Flat-File. Question is, I have so many columns that need to be set at 10 characters fixed length.

Is there way for this to be done? Example if I key in a check for $1.95

I want it to automatically put it as 0000000195.

Can this be done?

Thanks
 

Answer:Fixed Length in Excel

6 more replies
Relevance 56.99%

I have an excel spreadsheet which is 3 columns wide by about 100 rows long. When I print it out, it squashes the columns over to the left hand side of the A4 landscape page leaving a big blank space on the right hand side of the page. Because of the number of rows, it prints it out onto 2 pages.

I would prefer if it could have the first 50 rows on the left hand side of the page and then the second 50 rows on the right hand side of the same page.

I have chosen to fit 1 page wide by 1 page tall but all this does, is squash all the rows over on the left hand side of the page, still leaving the right side of the page blank.

I just cannot seem to make it do this at all.

Any ideas?
 

Answer:Printing a worksheet on one page

7 more replies
Relevance 56.99%
Question: excel worksheet

Hi
may be a dumb question but can i assemble a series of "loose" worksheets into a workbook? someone sends me a monthly report as an excel WS I want to put them all in one book from the folder they download to so I can analyse the data across all the sheets.
Regards Bloodaxe

Answer:excel worksheet

See if this helps click here

6 more replies
Relevance 56.99%

I have a folder with .csv and .txt files in it that I get every month from clients. 1. I need to get them into one Excel spreadsheet to do analysis with the information. I know I need to create a macro or a series of macros to be able to do this, but I really don't know how to begin. The information consists of three parts, I ultimately would like the macro to be able to seperate these individual parts and drop it on a seperate sheet within this workbook.... OR 2. I would like to be able to eliminate this first step and create an append query in Access to import the information into a table.

I ultimately need to have the information in Access and would much rather be able to do the entire process from an append query in Access.
thanks again.
 

Answer:.csv to Excel worksheet

6 more replies
Relevance 56.99%
Question: Excel Worksheet

I have a large Excel Spreadsheet that lists equipment (unit#, make, model, serial-no, branch location (1 to 5), status of equipment codes (0=avail, 1=on rent, 2=sold, 3=used for rent, 4=repair, 5=to be scrapped) and my assignment is to summarize how may pieces of equipment are in each of these categories at each location. Would I use a "countif" or a "vlookup" formula? I am using Excel 97.

Thank you
 

Answer:Excel Worksheet

None of them! I think you should use sumif or even sumproduct!
But also it can be done even easier using pivot tables!

If you wanna us assist you with that post a sample with some dummy date, bu with the real structure of the worksheet!
 

3 more replies
Relevance 56.99%
Question: Excel Worksheet

I was told if changes are save on current excel worksheet that you can recover the original worksheet or that it no longer exist on the hard drive is this true?

I need to find old worksheets. I created a worksheet to keep track of proceeds and updated it almost daily for 9 months. Is it possible for all of these worksheet to still exist on the hard drive?

Sorry with my pea brain I don't even know if this is a dumb question.

Thanks in advance,

popupgotme

Answer:Excel Worksheet

To the best of my knowledge, unless you saved each worksheet separately before making changes to it and then saved THAT worksheet, then you have overwritten the same file with new data. There would be no different files to retrieve practically.
Regards,
John

2 more replies
Relevance 56.99%

A while ago I installed Vista, then installed Word 2003 and then updated to sp3. Ever since then, my word 2003 doesn't format like every other word 2003 in the world. I see slightly less lines per page than other people.

For example, I just got a document with a table of contents that lists the last page as 29, but it's 35 pages when I view it. This screws up formating something awful. I have to take it to a campus computer for the final formatting so it looks fine.

Anyone know what might cause this? Thanks
 

Answer:Word 2003 incorrect page length

Make sure your stylesheets and templates are squared away.
 

1 more replies
Relevance 56.99%

I scan every piece of paper in our house into my "virtual filing cabinet." Most things work nice. But when I get a really long document, it usually cuts off the end of it when I feed it through the feeder. It's because it's configured to scan in 8.5x14 papers. I wish I had a program that would allow me to scan in 8.5 x infinity papers. It would just keep scanning until the paper finishes feeding and make the virtual page in the computer that length. Any ideas or suggestions?

Answer:scanning software with unlimited page length

Can't be done because the vertical travel of the scanning head/lamp is limited to 14-inches. It has nothing to do with the sheet feeder.

5 more replies
Relevance 56.58%

For years I did something on my w98, using Word97, with my Epson LQ-570+ dot matrix printer.

I have tried the same thing on my wxp, using Word97, with my new Epson LQ-590. It won't work. Epson says it is a problem with Word97, of course.

I got the LQ-590 because my 570+ was old and probably not doing well, and because my w98 had failed and I was trying to get everything taken over by my newer wxp.

This is the problem:

I print out progress notes on transcription paper that is on a large roll, with tractor feed holes and with no perforations (i.e., the sheet is continuous).

The progress notes are of varying length. I don't want to have the end of the page split a progress note into two parts. But I also don't want to waste large amounts of transcription paper by printing a page that has a lot of space on it, as would be true if the last PN ended fairly high on the last page, or as would be true if I had to insert a lot of space in order to start the next note at the top of a page (to prevent it being split).

So how had I been doing it?

I would go through the long document of many progress notes and put in page breaks, making each page a "section." Then I would change (reduce) the page length (through Page Layout) so that the space after the last PN on that page would be eliminated. My Epson LQ-570+ would print each page with the appropriate (assigned) page length. Of course, my 570+ was obeying what Word97 was sending it with regard to page lengt... Read more

More replies
Relevance 56.58%

In one workbook I have a number of worksheets that I wish to summarise.From the summary sheet is possible for excel to supply the worksheet name in a cell ?If so how ? I have tried '=sheetname!' but it does not work.

Answer:MS excel worksheet linking

except that you haven't defined the cell to be linked after the exclamation mark

10 more replies
Relevance 56.58%

I have a question on adding a hyperlink from my intranet website to an excel worksheet:
The actual complete workbook is located on a LAN folder on our computer system... I want them to be directed to a specific worksheet w/in a workbook in excel. Is there a way to do this? Thanks so much!
 

Answer:hyperlink to an excel worksheet

I think all you need to do is something like this:

"C:\\My Documents\\MyExcelFile.xls#MySheet!A1"

If your sheet name contains a space, then you need to enclose it in single quote marks, like this:

"C:\\My Documents\\MyExcelFile.xls#'My Sheet'!A1"

Best,
Dan
 

1 more replies
Relevance 56.58%

I have a file in Excel. I recently added information to the file but when I tried to save it, a message said I cannot save it because it is a read only file. I check the Help information and it showed how to change the properties but when I tried that and went to remove the check mark from the 'read only' box there was no check mark in the 'read only box'. No matter what I tried I could not get the file to save the changes I made. Then it said to save with a different name but when I tried that it said I couldn't because the file was 'read only. I have run into a brick wall. Does anyone have an answer for this?

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: AMD Athlon(tm) II X4 630 Processor, AMD64 Family 16 Model 5 Stepping 2
Processor Count: 4
RAM: 4094 Mb
Graphics Card: AMD Radeon HD 5700 Series, 1024 Mb
Hard Drives: C: Total - 476387 MB, Free - 409840 MB;
Motherboard: Gigabyte Technology Co., Ltd., GA-MA74GM-S2
Antivirus: Windows Defender, Disabled
 

Answer:Cannot save Excel worksheet

try saving with a different name
and closing the spreadsheet
Now using file explorer , goto the original file and rename that to somethink like OLD
now you should be able to rename the new file, back to its original name

have you emailed or shared the file at all
Anyone else on the PC - different user - open it
Does it contain any Macros at all?

I find this problem , when using dropbox or onedrive to save a copy into
often I have to save a copy , as dropbox/onedrive will be syncing the old file and locked it out
 

3 more replies
Relevance 56.58%

I made an Excel worksheet and I want to set limits to where a user is able to tab to. Ie...The user starts in A2 and presses tab to get to B2, when the user presses the tab key again I want them to be taken to tab A3. Any Ideals? Thank you in advance for your help.

Answer:Excel worksheet tab order

Do you only want them to have access to the columns A and B only?? If so, try this.. Select the range of cells that you wan them to have access cells (EX: A2:B20). Right click on one of the selected cells and Select FORMAT CELLS. Then find the "Protection Tab" and UNCHECK the box next to" Locked". Close the FORMAT CELLS box. Then we are going to protect the worksheet and/or workbook depending on whichever you wish. This method will vary depending on which version of Excel you have. If it is the 03 version, go to Tools, Protect. If it is 07+, go to the Review Tab. Once you select Protect Sheet, you should see some options or "permissions" with check boxes next to them. Here we want to DESELECT "Select Locked Cells" so that they will only be able to select the cells that we previously "unlocked".BEST OF LUCK!

2 more replies
Relevance 56.58%

Printer shows "Printing 1 of 1862" how do I get rid of this number

Answer:How to print a worksheet in Excel

It should be somewhere in your Printer Setup or Page Setup.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 56.58%

I need to print a worksheet (to make an order form) that contains 5 columns, but split into 2 so that one sheet looks like 2 sheets of A5 (A4 landscape, but wit two pages like a book - does this make any sense to anyone, !!!!!!!!!

Answer:Format Excel Worksheet

VoG's territory!!!

9 more replies
Relevance 56.58%

writing a program in Excel... would like to have a "information page" where user info is collected then used to name tabs of worksheets in the program...
anyone have a solution?
 

Answer:Macro to name worksheet Tab in Excel?

http://www.ozgrid.com/Excel/TipsAndTricks.htm

http://www.mrexcel.com/
 

1 more replies
Relevance 56.58%

I have checked the threads and can't quite find an answer.

I have a spreadsheet with multiple worksheets (16), but one, lets call it worksheet 4, is very slow to be selected. The workbook itself opens quickly, and all the other worksheets select quickly enough.

This particular worksheet, when selected, displays whatever worksheet info I was on before, I get the old egg timer, and often get that the sheet is not responding. As long as I sit there long enough, it eventually displays. The formulas & formatting on this sheet are the same as on 8 or 9 of the others, and I am not having this problem with any other worksheets.

It isn't a small sheet - 2.7MB, and it is formula heavy.

Operating on Windows 7, running Excel 2007

Any ideas? I have checked for objects and hidden code and can't find anyhting.
 

Answer:Slow Excel Worksheet

What type of formulas do you have on that particular sheet? Are they referring to other cells on the same sheet, to cells on another sheet, to cells in another workbook...?
Even if it wasn't confidential (which I suspect it is) your workbook would be too large to upload, possibly even if you zipped it.
But unless we can compare the bad sheet with one that behaves normally or have a lot more info, I can't think of a lot to suggest.
 

3 more replies
Relevance 56.58%

Hello guys, this is my first post here.I have a work laptop that is on a domain. When I try to open any colored document in Excel 2002, I am not able to see any color in cells at all. Others can see them but not on my laptop. I tried the Detect and Repair option but it did not work. Do you guys have any suggestions? Thanks in advance and glad to be here.

Answer:Excel 2002 worksheet

Welcome to ComputerHope.What happens if you save a file in Excel 2000 with colored cells and open it?

8 more replies
Relevance 56.58%

tab scrolling buttons will not advance the worksheetI've turned them off and don't know how

Answer:worksheet won't advance in Excel

tab scrolling buttonsNot sure what you mean.What version of Excel are you running?MIKEhttp://www.skeptic.com/

14 more replies
Relevance 56.58%

i need a formula for my excel workbook

Answer:i trying to complete my excel worksheet

Here, use this one:=IF(IF(INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,5)<>0,5,6)=5,INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,EQUIV("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,IF(INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,5<>0,5,6)),-INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,IF(INDEX(temp.xls!A:F,SUM(MATCH("EENU",temp.xls!A:A,0),MATCH("BF304",OFFSET(temp.xls!A1,MATCH("EENU",temp.xls!A:A,0)-1,0,MATCH("FCLI",temp.xls!A:A,0)-MATCH("EENU",temp.xls!A:A,0)+1,1),0))-1,5)<>0,5,6)))Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 56.58%

If a2 is less than $65000, 0, but if a2 is $65000 to $70000, $100, but if a2 is $70001 to $74999, $200, but if a2 is $75000 to $79999, $300, but if a2 is $80000 to $84999, $400, but if a2 is $85000 to $89999, $500, but if a2 is $90000 to $94999, $600, but if a2 is $95000 to $99999, $700, and if over $100000, $800 . I will manually enter the amount in 'a2'. How do I do this calculation in my excel worksheet?

Answer:Excel Worksheet Calculation Help!

Why did you start a whole new thread?You could have just answered my query in the last one.Try this:=IF(A2<65000,0,IF(A2<=70000,100,IF(A2<=74999,200,IF(A2<=79999,300,IF(A2<=84999,400,IF(A2<=89999,500,IF(A2<=94999,600,IF(A2<=99999,700,800))))))))MIKEhttp://www.skeptic.com/

4 more replies
Relevance 56.58%

Windows 7
Office 2007
Computer is approx 1.5 years old as well as the printer also.
Ram is a train load (gigs)

Having trouble with my Excel spreadsheets printing.
In any given Workbook, some worksheets print, some won't.
The ones that won't, I get a dialog box stating a few things, eg, not enough memory, drivers, etc., generally a generic dialog.
I have checked these avenues out, update Windows daily, as well as uninstalled my printer (HP C309a), reinstalled printer, I've had a computer technician out here a couple of times and he's done the same things I have done, but to no avail.
It may print, it may not. Depending on mood swing I guess.
Any suggestions?????????
Please help,
Thank you.
 

More replies
Relevance 56.58%

Can not remove Worksheet menu bar from Excel 2002
 

Answer:Excel worksheet menu bar

14 more replies
Relevance 56.58%

I have 250+sheets, summary sheet in excel. I did a formula an IF THEN statement it works ex; IF(sheet1'!$B$1<=5,sheet1'!$B$2,sheet1'!$B$3) but now have to repeat that formula 249 more time on my summary sheet.

Answer:Excel Worksheet Problem

Hi,If you are trying to do the same as before then the initial 'formula' looks like this:="XXXIF(Sheet" & G3 & "!$B$1<=5,Sheet" & G3 & "!$B$2,Sheet" & G3 &"!$B$3)"The formula you posted has an extra ' in it, sheet1'or a missing ' depends on how you look at it.The worksheet name can be used without single quotes if there are no spaces in the name, so =Sheet1!B1 is OKbut with a space it has to be ='Sheet 1'!B1Regards

2 more replies
Relevance 56.58%

I am trying to build a shop schedule to keep track of work being performed in 14 different bays. I have started the work sheet but run into difficulties with keeping the customer names below each other in the next cell. I end up with gaps in the work sheet where the formula does not find a value. Can someone assist me with completeing this worksheet? Please have a look.
Thanks
 

Answer:Solved: Need Help with an excel worksheet

16 more replies
Relevance 56.58%

Please can anyone remind me how to type in the formula for accessing data from worksheet 1 and using the data on worksheet 2 for instance all in the same work book. I used to do it but forgot how . I am using XP.

Answer:Excel - using data from other worksheet

Something like='First Sheet'!A1 + 'Second Sheet'!C3The ' are only necessary if there are spaces in the sheet name.

2 more replies
Relevance 56.58%

I know this may be an obvious question, but I have a number of Worksheets in my Excel Workbook.

How do I send just a single Worksheet via e-mail?
 

Answer:Sending Excel Worksheet

It's not obvious at all. Questions:

1. Always emailing to the same person?
2. Email as an attachment? Or as part of the message body in Outlook?
3. Want a button on the worksheet?

You can check here:
http://www.rondebruin.nl/sendmail.htm
 

3 more replies
Relevance 56.58%

I am looking to setup a simple worksheet, but I am having problems with tabing from one cell to the next. Is there anyway that I can assign a tab order to the cells, instead of the tab going where it wants to? This is after I have unlocked the cells that I need to type into.

Answer:Excel Worksheet Setup

Hi,If you are referring to how the selected cell changes after entering data, there is a setting in Options to set Up, Down, Left, Right or No move.I can't remember the exact location of this setting in Excel 2007, as I don't have that version on this PC.It's likely - Office Button - Excel Options (at the bottom of the pane), then select the Customize or Advanced tab from the tabs on the Left and look for Move Selection after Enter (or similar wording).Not sure if that helps you in your specific situation.Regards

2 more replies
Relevance 56.58%

Hi, I am new to Excel and I just need help with linking to another worksheet. So if the user clicks on a cell, they will be taken to another worksheet with more detailed information. I realize this is very basic to most people but, as I said, I am new to Excel and I could not find information on this in the help files. Thanks for your help.
 

Answer:Excel - need help linking to another worksheet

ac11 said:

Hi, I am new to Excel and I just need help with linking to another worksheet. So if the user clicks on a cell, they will be taken to another worksheet with more detailed information. I realize this is very basic to most people but, as I said, I am new to Excel and I could not find information on this in the help files. Thanks for your help.Click to expand...

See the Help file for Hyperlinking
 

1 more replies
Relevance 56.58%

Could someone please tell me the shortcut to enlarge the worksheet in Excel.

Thanks
 

Answer:Enlarging Excel Worksheet

Timeferret, depends what you mean by "enlarge".

From the Help file:

"If you use the Microsoft IntelliMouse pointing device to zoom more often than you use it to scroll on a sheet, you can set the wheel button to zoom instead of scroll. On the Tools menu, click Options, click the General tab, and then select the Zoom on roll with IntelliMouse check box."

This works with my non-M$ mouses too.

Rgds,
Andy
 

1 more replies
Relevance 56.58%

I have a document that is read only suggested...not password protected. I have been adding worksheets as necessary. I only have 6 worksheets at this time. Today when I tried to add a worksheet the worksheet option is inactive.

Any ideas?

Thanks so very much!
 

More replies
Relevance 56.58%

Have a project from work to fill in worksheets for phone calls received each week. Column headers are Phone Line 1,2,3,4,5. Rows are days of the week - with totals at the end of each column/row. Is it possible for me to have a separate worksheet which will add each of the weekly sheets up as a running total. I know I can do it as an autosum for existing sheets, but is there a way for it to auto-update to include each new weekly worksheet I make?

Answer:excel help - totals worksheet

Other than using a macro, this isn't easily possible. However, if you enter the names of the sheets - Sheet1, Sheet2 etc - in Column A of your summary sheet then the formula=INDIRECT("'"&A4&"'!M4")and copied down will retrieve the value of M4 from each sheet. You could adapt this to sum them.

4 more replies
Relevance 56.58%

A couple of months ago my Excel worksheets became immobile - unable to be reduced in size or repositioned on my monitor. The minus button works, and the X button works, but the middle button works the same as the minus button. As a result, I see the sheet covering the entire screen or not at all. When I try to Restore from the bottom bar I only get the maximum screen again. The individual windows within the overall workbook can be repositioned within the maximum screen. I am using XP Home and Office 97 on a Toshiba Satellite Laptop, with a 19" CTX auxiliary monitor. Unable to find out what I did to cause this, or to find any help. Any suggestions would be greatly appreciated. IREBob
 

Answer:Excel Worksheet Resizing

13 more replies
Relevance 56.58%
Relevance 56.58%

Is there a way of only displaying the columns which I am working with, on my Worksheet.

I am only using the columns A-K, but if I use the horizontal scroll button at the bottom of the screen I keep scrolling to unused columns to the right.
 

Answer:Viewing worksheet on Excel

8 more replies
Relevance 56.58%

I have 4 work sheets:worksheet one has pending ordersone ordered confirmed i have a column confirmed i have a row that says YesI want the information in that row to go to the next worksheet#2 which is on route to delivery. Once delievered I have a row that saids YesThat row would go to the next Worksheet that states Delivered row with Yes to next work sheet for billing.What is a formula to activate a whole row to move?

Answer:Excel Moving a row to another worksheet

There is no formula that can "move" a row. A formula/function can only return a result in the cell in which it resides.You'll probably need to use VBA to accomplish your goal.re: "one ordered confirmed i have a column confirmed i have a row that says Yes"I don't understand this. Please try to explain it differently and we'll see if we can help.Posting Tip: Before posting Data or VBA Code, read this How-To.

2 more replies
Relevance 56.58%

Hi,

I am sure this is going to be something simple?
When entering a number in a cell (i.e mobile) and clicking away from the cell
the zero is not saving? i.e 7766.
I did go into the format options and play about with the numbering and general options but was unable to solve?
 

Answer:Zero not saving in Excel worksheet?

First select the column and format as text.
Or enter with an apostrophe in front of the value.
Or you could format, for instance, a 7-digit number with a custom format of 0000000
 

3 more replies
Relevance 56.58%

How can I restrict the use of an Excel worksheet to one computer? I believe that macros can be used to ID the serial number of a PC's hard drive and that an algorithm can be used to generate an activation code which would prevent migration.If it is possible (by any method), I would appreciate advice on how to achieve this.

Answer:Excel Worksheet Security

That is actually incredibly difficult to do.Would validation using the user's Windows logon name be an option?If you are trying to create a secure environment in Excel then forget it - Excel security is pants. Anubvody can crack it.

10 more replies
Relevance 56.58%

I have created an invoice using Office Excel.

As a test I sent it to own e-mail address.

The problem I have is when I received it, it was sent directly to my deleted folder.

I have both Norton Anti Virus and Internet Security installed on my PC.

Could these two programs have anything to do with it???

Thanks
 

Answer:Sending Excel Worksheet

8 more replies
Relevance 56.58%

Is there a way to remove or dim(so they can't be accessed) the functions on the worksheet menu bar, i know i can go into tools>customise and turn it off but i would like to do this using vba for a particular workbook/worksheets so that when the workbook is closed the menu bar returns, i think you can cover the worksheet menu bar with a custom menu bar but i am not sure how to do this either.

any help please
 

Answer:Excel worksheet menu bar

Yes, you should check the link I sent you (Pearson) you have to look a bit but there are many options like disactivation copy and paste, delete sheets, you name it.
It will take some thinking and doing but it's all there
 

1 more replies
Relevance 56.58%

I have been given the job of merging around 2,000 workbooks, each having around 12 worksheets. So I expect to have 24,000 worksheets in total. I am looking for a utility that will merge these onto one continuous worksheet, or if this is too big, I will initially group them into smaller worksheets. My problem is, I need to audit which workbook each row of data is taken from, so the utility must insert a column with the workbook name inserted against each row.

This is a nightmare, but I have to do it. Can anyone suggest any utility, at any price, that might carry out this function ?

Thanks in advance
 

Answer:Excel worksheet merge

A friend of mine goes here for help,try it
http://ozgrid.com/forum/index.php
 

1 more replies
Relevance 56.58%

In my excell, whenever I open an workbook, the colour or the cells and chart colours changes to different (randomly) than I originally set. Any information/help what's causing the problem and how to resolve this?Regards!

Answer:Excel worksheet problem

closing without any resolution.

1 more replies
Relevance 56.58%

I have a code that runs when an Excel workbook is opened. The code runs on all the worksheets within the workbook. When the code stops running the worksheet selected is always the last worksheet. There are 12 worksheets (named by each month).

How can I get the code to select the current month worksheet when the code reaches the end?
 

Answer:Solved: Excel -> Worksheet Name

6 more replies
Relevance 56.58%

I have created an Excel spreadsheet but cannot limit its size. In 'Print Preview' it fits nicely onto one A4 page, but when trying to email it spreads to 26 pages! How do I get rid of the thousands of extra rows and columns? I have Office XP.

Answer:Excel worksheet size

Try selecting the area that you want to print then File > Print Area > Set Print Area.

10 more replies
Relevance 56.58%

Hi ,

I had an excel sheet having 26 worksheet of 6mb size and that too file is sharing, now the actual problem is whenever i save a file or save as, without doing anything in the file one of the sheet randomly get disappeared, sometime the file size get decrease without doing anything.

Does any one have face any such problem, because what i think that there is no limit on file size and number of worksheet.

Best,
Ashish Sharma

More replies
Relevance 56.58%

i applied allinternalpasswords.xls to unprotect a worksheet. it has done it job. i opened the xls. when enabled macro i got a addin on the toolbar of excel. then i opened the problematic excel worksheet on the same window. i clicked on the addin and i got the link to remove password. it has done its job. now i still have the addin on the excel which i want to remove. how to remove it?
winxp-sp3-amd-asus-1 gb ram-
 

More replies
Relevance 56.58%

Hi All

I am trying to create a grading template on Excel. I have included hyperlinks, dropdown boxes and comments with no problem, but what I am trying to do is this.

I have the first 10 rows for static information - they don't change. I want to be able to change to next 10 rows without affecting the rows above. I want to be able to change column width, for example, without affecting what I have written above. Any ideas?

PS: If you know any sites that have intermediate tutors for excel, I'd love to know their addresses - especially any for info on creating grading templates.
 

Answer:Splitting an Excel Worksheet

11 more replies
Relevance 56.58%

I did something to make a worksheet that I had prepared in Excel to go to my external drive G. Now each time I need to get the worksheet for some reason it tells me that it is not there, but I can see it in the external drive. I want to it on drive C.
Suggestions?

Answer:Excel Worksheet in Drive G

Why not copy & paste or move the worksheet from the G: drive to the C: drive if that's what you want. What's stopping you?

3 more replies
Relevance 56.17%

Hi i am Jo

would need help in finding the length of the third side of a triangle in excel

I have three points number: AB- 235 BC- 156 need to find length AC - it's not a right angle triangle,
 

Answer:Find length of side of triangle in Excel

Welcome to the forums Jo.

Having the length of two sides of a triangle isn't enough to calculate the length of the 3rd side, for a non right-angle triangle. You'll also need to know one of the angles.
 

3 more replies
Relevance 56.17%

My lady wife is having a small problem with a formula she is trying to use in an Excel spreadsheet.

She is trying to make a formula that she can copy and paste into various spreadsheets she utilises to organise her staff's workflow.
The five staff deal with about 30 suppliers and she wishes to be able to associate each supplier with a particular member of staff, so, for example, if column A is 'Suppliers'and column B is 'Staff Member', a formula using the IF function is placed in column B using the following syntax:
=IF($A1="aaaa","Rashmi",IF($A1="bbbb","Laura",IF($A1="cccc","Linda",IF($A1="dddd","Denise",IF($A1="eeee","Mark","")))))Click to expand...

This works just fine with only a few suppliers, but if the string is lengthened to more than about 9 suppliers, as here:
=IF($A1="aaaa","Rashmi",IF($A1="bbbb","Laura",IF($A1="cccc","Linda",IF($A1="dddd","Denise",IF($A1="eeee","Mark",IF($A1="ffff","Rashmi",IF($A1="gggg","Laura",IF($A1="hhhh","Linda",IF($A1="iiii","Denise",IF($A1="jjjj","Mark",IF($A1="kkkk","Rashmi",IF($A1="llll","Laura",IF($A1="mmmm","Linda",IF($A1="nnnn",&quo... Read more

Answer:Solved: Excel formula length problem

11 more replies
Relevance 56.17%

the answer to this might of been found with a search but hey i'm lazy today and wanted to see who the excel masters are

using excel 2007, cell a1 contains an array formula (CSE) like so - {=MAX(LEN(A2:A470000))}
cells a2 through a470000 contain dates such as
12/12/2011
etc, you get the idea, i need the formula or something else entirely to return 10 not 5

thanks in advance
 

Answer:Solved: excel length of date field

i'll answer if myself thanks to another web site, Mike these guys are slackin' 'round here it looks like

=MAX(LEN(TEXT(A2:A470000,"m/d/yyyy")))

exit celll with ctrl, shift, enter
 

1 more replies
Relevance 56.17%

Hi all,
I am wondering how to overcome the problem of Excel chopping off data.Is there a way to set a large limit or possibly keep the record length unlimited.This data is the results retreived from Access queries. The data after querying is exported to the Excel sheet via the following do command:

DoCmd.OutputTo acQuery, "queryName", "MicrosoftExcel(*.xls)", "Report" & ".xls", False, ""
Thanx
 

Answer:Exporting from Access to Excel-length limits?

If you are trying to put the entire string as one line it will never work. I believe the charachter length is 255. You can however create a new cell in Excel for each record like a line break.
 

3 more replies
Relevance 56.17%

Excel has a limitation of 240 characters when saving a file as .PRN. I need to create an ASCII file of greater record length with multiple records.How can I do this? Is there an Excel workaround or will I have to use another program? Will Access allow me to do this?Thanks for any assistance in advance.Squeals

Answer:ASCII fixed length files in Excel

You MIGHT be able to do this using a macro click here

2 more replies
Relevance 55.76%

I am copying some URLs from websites into an Excel worksheet. I post them as text (Paste Special) so that it is easier (otherwise it screws up the size of my cells, and posts info I don't want)

My question is once they are in my spreadsheet as text, how can I convert them back to live hyperlinks?

Thanks
 

Answer:Pasting hyperlinks into an Excel XP worksheet

6 more replies
Relevance 55.76%

Extracting data from one Worksheet and populating to another using same value from both
Hi,
I have 2 spread sheets which have a primary value, linking (not a formula) both sheets together "account number".
Spread sheet A has the following columns:
account number, account name, postal name, address 1, address 2, address 3, address 4, postal code and account balance.
Spread sheet B has the following columns:
account number, account name and account balance.
I would like to populate spread sheet B with the following columns (contents) from spread sheet A:
postal name, address 1, address 2, address 3, address 4 and postal code.
This document will be getting used as a source for a mail merge job, thanks.
At the moment I have both sheets open and I'm using find and replace and copying from spread sheet A to spread sheet B, unfortunately there is nearly 2000 records, thanks.

More replies
Relevance 55.76%

Hi there,Sorry for the nebulous title question but there are only so many words available in the title! I've trawled your site for an hour or 2 already today, but couldn't find anything exactly relevant (or close enough), so thought I'd ask directly.I'm trying to run a fairly simple Excel spreadsheet showing a summary of all the previous worksheets results.The 'Summary' sheet format is that A6:A17 are accounting status names (eg. Not started yet, Not Due Yet, Completed etc), range B6:B17 is the number (count) of applicable clients that fall into this category.I've imported the data from Access into new worksheets within the same workbook and want the summary sheet to autopopulate based on these sheets.eg. Sheet1 is 'Summary', sheet 2 is '2003-count' (I will be repeating this exercise ad infinitum for each year).Row 1 in '2003-Count' shows accounting status from an Access query, and only returns those statuses that are applicable in that year - <> (for blank - which we need to amend on our systems!), Annual return filed, and Completed - Row 2 shows the count - 2, 1 and 38.What formula or macro will I need to populate fields B6:B17 with the relevant amounts from row 2 based on the 'title' in row 1, and populate the ones that have no corresponding 'title' with 0? (Column C is a percentage field, so needs to be a 0 to work).I used the LOOKUP formula originally and added the IF funtion and the ISBLANK to the mix and still cannot get it to return what I need... and now am so co... Read more

Answer:Excel-Grab a specific value from a worksheet

I'm Confused!Perhaps it would help if you posted an example of the sheet layouts so we can better understand what you are trying to do.Post an example of some of the inputs and the corresponding desired output.Please read the How To referenced in the following line before you post your examples. Click on "How To"Posting Tip: Before posting Data or VBA Code, read this How-To.

12 more replies
Relevance 55.76%

 ::)I am not new to Excel but am having a mind glitch.  I have created a worksheet in Excel 2000.  I do not want the form to print.  I want to set it as a background, type in my information but only have the information print on a pre-printed form.  I do not want the form to print.  Also with the form protected can I hit the "all clear" and only have the information deleted not the form?  I have tried to set it as background and to stop the background from printing but it will not allow me to do this.  Maybe I am telling it to do the wrong thing.  Boy do I need help.  It is driving me nuts.  Thank you for your help.NanetteI created the form as a spreadsheet and saved as a template.   I believe when you save it as a template it saves it as a workbook.  My problem is that  I am unable to set it as an on-screen form only.  I have used the help on the windows program but it does not tell me how to do it.  Is it possible in Windows Excel 2000 to save it as an on-screen form only?Thank youNanette

Answer:Worksheet Printing in Excel 2007

How did create the form?  Is it a "data form" or a "worksheet form"?

1 more replies
Relevance 55.76%

Hi there

I know that it is very easy to copy and paste an Excel worksheet into a notepad. However, my boss wants me to write a macro in Excel that can do that automatically, since we have staff that is not comfortable in using Excel. I tried to record a macro to get me started but that did not work. Any ideas??

Mario
 

Answer:Exporting an Excel worksheet into Notepad

16 more replies
Relevance 55.76%

For reasons unknown, there is a black gridline in one of my worksheets. Even if I opt to view the worksheet without gridlines, it is still there. How can I make it a normal blue gridline? "HELP" was no help on this question.
 

Answer:Solved: MS Excel worksheet gridlines

6 more replies
Relevance 55.76%

When working with a spreadsheet with lots of worksheets, I believe that it may be possible to view the worksheet name tabs as a drop-down list, instead of having to scroll backwards and forwards through them at the bottom of the window.Can anyone help please?

Answer:Microsoft Excel worksheet name tabs

Right click on the arrow keys at the bottom left (next to the sheet tabs).

1 more replies
Relevance 55.76%

I'm working on a sales journal and need to have the total for a certain set of repeated values. I have over one hundred entries per month. How do I get away from entering cell names and numbers repeatedly. For example, I need to have all the 'gas' totals add up automatically without having to type in all the cell names. See attachment - it's much easier to explain using it.

Plz HELP!!!
 

Answer:Solved: Excel Worksheet Dilemma

Take a look at the SUMIF function.

Rollin
 

2 more replies
Relevance 55.76%

When working with a spreadsheet with lots of worksheets, I believe that it may be possible to view the worksheet name tabs as a drop-down list, instead of having to scroll backwards and forwards through them at the bottom of the window.Can anyone help please?

More replies
Relevance 55.76%

I'm using Excel 97 under Windows 98 and I'd
like to ask if anyone can tell me how I can re-set
the default page size. The margins are pre-set,
I'd like to make re-set them all to 0.5 and it is
time-consuming to keep doing this manually
each time.

Many thanks
 

Answer:Excel :: Default worksheet margins

11 more replies
Relevance 55.76%

only one of my workbooks has missing arows on the sides/corners and load with grey borders within the window frame. How did I lose them and how to get them back, please

Answer:how do i get arrows on the sides of excel worksheet

Do you mean the scroll bars, and what version of Excel do you have?

7 more replies
Relevance 55.76%

I'm working on a Macbook Pro with Mac OS X, version 10.6.7.  Recently, when opening a new excel worksheet or existing file, the toolbars do not appear at the top of the sheet.  I open View>Toolbars and both Standard and Formatting are checked.  I have to uncheck one, reopen View>toolbars, recheck the one I unchecked and then the space for the toolbars appears without the toolbars.  Finally, when I place the cursor in that space and click, they will appear.  Each time I close and reopen a file, I have to go through the same process.  This annoyance started recently, but I can't link it to anything that may have caused it.  Any help would be appreciated.

Answer:toolbars do not appear when excel worksheet is opened

I would try repairing the permissions using disk utility that can help resolve little glitches like the one you are having

2 more replies
Relevance 55.76%

I need to check that value entered in any cell of column A in active worksheet is less than or equal to difference between values in A1 and B1 in another worksheet of the same workbook. Later I need to loop the same check. For example value entered in column two of the active worksheet must be compared agains cells A2 and B2 in another worksheet.

Answer:Compare cells in different worksheet in excel

Sending this to the Office forum, where it has a chance of being answered.

3 more replies
Relevance 55.76%

Hi. I have a question that I hope someone can answer. I have been working on an Excel spreadsheet for about 2 weeks & today as I was woking on it an error message came up ( I cant remember what it was ) Now, when I try to open this file, it is blank. Although when I look at the properties, it says that it is 14KB big. How is this coming up blank? Any suggestions? thanks


 

Answer:Excel: Opens to blank worksheet

6 more replies
Relevance 55.76%

Hi,
I have a problem when I try to open excel worksheet. When I click on the filename, I get "File cannot be found. Check the spelling of the file name and verify that the file location is correct. If you are trying to open the file from your list of most recently used files on the file menu, make sure that the file has not been renamed, moved, or deleted."

But when I open the microsoft excel program and then open the worksheet from file - open, it opens just fine. The file is still there, not renamed or moved or deleted and opens fine through the file - open menu. But when I click on the file name, it gives me the above dialog box. Can somebody suggest a solution for this?

Thank you,
JS.
 

Answer:Solved: Excel worksheet problems

9 more replies
Relevance 55.76%

Can anybody tell me how to archive data or text from one worksheet to another.
I have a so called calculator that works out how much money i will need to do .
Then on another sheet i input manually the amount of money and where it is going, date etc etc

Instead of doing both processes i would like the spreadsheet set up and i just enter all details in the calculation part, then to click a button and the whole lot transfers over neatly into the spreadsheet.

Hope this makes sense.

Thanks

Answer:Excel - Archiving Text To Another Worksheet

Hi there,

First, you will need to define - clearly - where your data will be going from and where it will be going to. That's pretty much it. You've already told us you want to trigger it with a button, the rest is fairly straightfarward (with that info).

2 more replies
Relevance 55.76%

All of a sudden my excel worksheets with borders &/or shading will print the first copy with borders/shading. All other copies on multiprint request have no borders &/or shading?? (all text is in it's place) Could my trying out F11 on worksheets to produce charts have caused a problem in the applications files? It is the only thing I can think of I did differently than normal prior to this problem arising.
 

Answer:[Resolved] Excel 97 worksheet borders

Sounds to me like you need to take the steps in Article III under hard drive maintenance:

Tech Support Guy's April Newsletter
 

2 more replies
Relevance 55.76%

I am trying to print the gridlines in an Excel file. I did a search and followed the instructions, went to File/page setup/ then in the Print section I put a check mark in the gridlines box, clicked OK, then clicked Print but did not print the gridlines. I followed the instructions to the letter. What can I be doing wrong?

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 32 bit
Processor: Intel(R) Celeron(R) CPU B800 @ 1.50GHz, x64 Family 6 Model 42 Stepping 7
Processor Count: 2
RAM: 1893 Mb
Graphics Card: Intel(R) HD Graphics Family, 818 Mb
Hard Drives: C: Total - 238372 MB, Free - 196442 MB;
Motherboard: Acer, HMA51_HR
Antivirus: avast! Antivirus, Updated and Enabled
 

More replies
Relevance 55.76%

Hi all,

I have a large worksheet (see attached for a sample with fake data) that has 29 regions. What I want to do is to put each region into a separate worksheet while retaining the original worksheet.
Certainly, I could copy the sheet 29 times and delete all the extra data per each sheet, but....

I need to later randomize and extract 100 lines of data from each of these regions.

Thanks in advance!!!
 

Answer:Solved: Excel - want VBA to break a worksheet into several

16 more replies
Relevance 55.76%

I have a worksheet that I want to concurrently print a hard copy and save to a .pdf file in a folder on my computer. The worksheet that I want to print and save to .pdf is not the active worksheet.I would like for the worksheet to be saved to .pdf with a unique file name. The worksheets saved as .pdfs will be archived, and it's important that they are not written over.Could someone help me with the VBA code to do so? Thank you for any help you can be.Sincerely,Mark1011

Answer:I want to use a macro to save an Excel worksheet to a .pdf.

Try here:http://www.rondebruin.nl/pdf.htmMIKEhttp://www.skeptic.com/

5 more replies
Relevance 55.76%

Hi,

I would like to collect data out of another worksheet with more than 600 lines; this worksheet is structured like this:

Column A: Name or "not required"
Column B: Sum

I'm OK with the formula which searches through column A and retrieves the sum of all amounts with the same name (=SUMIF) in column B.

What I can't figure out is a way to skip lines with "not required" or where a name has been found before, i.e.

A1:SOPHIE
B1:20.00
A2:SOPHIE
B2:50.00
A3:JOHN
B3: 40.00

should bring up in my new worksheet:

A1:SOPHIE
B1:70.00
A2:JOHN
B2:40.00

not:

A1:SOPHIE
B1:70.00
A2:SOPHIE
B2:70.00
A3:JOHN
B3:40.00

Cheers for any hints!

Andreas
(New Zealand)
 

Answer:EXCEL Collecting data from worksheet

10 more replies
Relevance 55.76%

Is it possible to open a specific worksheet in Excel by default ?Thanks

Answer:Open specific worksheet in Excel

Yes, you could save it as a .xlt (template) file, to have it open by default it would have to be called, Normal.xlt and replace the existing Normal.xlt file. There might be a better way, so hang around until VoG gets here, he'll tell you the definitive answer.

9 more replies
Relevance 55.76%

I cannot seem to copy worksheets any more. I right-click on the tab to bring up the menu, check the [move-or-copy] box, check the [move-to-end] box and then - nothing! I can enter data in just fine and have no other problems with Excel, I just can't copy worksheets. Anyone experienced similar? Thanks.

Answer:Excel copy worksheet problem

cspIf you click on Help then Detect & Repair, maybe that will cure your problem.

3 more replies
Relevance 55.76%

Hi, i have a question in creating a file in which i can fill out the worksheet "form" and by clicking a save button, the data will be saved into worksheet "database" in the next row. basically i do not need to amend data from the "form", but i will rather update in "database" manually.

thx for your help in advance
 

Answer:excel - saving data to another worksheet

Hi there, welcome to the forum.

I think you should take a look at the link blow, this is something similar

http://www.contextures.com/xlForm02.html

If you get stuck, let us know.
 

1 more replies