Search results for query: *

I have a spreadsheet with several rows. Is there a way to add a blank row after each at one time? I'm hoping there's a faster way than inserting one row at a time. Any help would be appreciated. Thanks, Linda

Without using MS Query, is there another way to copy an entire row to a new worksheet using a macro? I'm looking for a formula that would be 'If this cell is >0 then copy to new sheet with the entire row's information. leaving out the rows where the value is <0. Sorry to be so persistent. I...

I am using Excel 2000 and it does not give me that option.

I have created a workbook with automatic refresh each time its opened. I did this through MS Query and it works prefectly. However, I need to email it to others and when I do, it doesn't work. Should it be saved in a different format? So close...but not there yet. Linda

I am also trying to create a macro that will auto refresh each time the workbook is opened. I followed the instructions above. I'm not real knowledgeable about this. heres what I have. Sub AutoRefresh() ' ' AutoRefresh Macro ' Macro recorded 4/29/2008 by WVCO ' ' Keyboard Shortcut: Ctrl+r '...

Skip, Thank you. After much practice, I got it to work. I now have a workbook with one sheet that lists products and the next sheet is the order form. However, I still have two questions: 1. When I enter the quantity on the first sheet, it doesn't show up on the second sheet unless I do a...

I have a workbook that has two sheets. one sheet has many rows with our sales parts, description, qty and price. Customer enters (worksheet 1)the quantity and price is extended. The next worksheet is the order form in which I only want to copy over the items ordered. I need to copy over the...

Thank you, I knew it was something simple that I was missing...

How do you show the comment box in excel and print it?

Thank you so much, it worked! such a simple formula...DUH "you don't know what you don't know" Thanks again!!

How do I create a formula for a row of cells that have different prices in them to determine the lowest and highest value?

my computer was infected by a software SPY SHREDDER. I was able to uninstall it off my computer by using SPY HUNTER. However, when I go to My Computer/Control Panel/Display and click on the the DESKTOP tab I am unable to change anything. It's as if I am looking at a static screen. Does...

I have a report that has the date an order is entered and a date when the order is to ship. How do I calculate how many workings between the two? Any help would be appreciated. thanks, Linda

Thank you, I think that is what I was wanting. I was working on the drop down and I couldn't get the times right. Is there a way type in something in the drop down if what you want isn't there? In this case, I'm referring to another drop-down I will be making, one for the names. Again...

I need to create an excel spreadsheet for workers to use a pull down menu in one cell for START TIME, another for END TIME and then a third column that determines how many hours worked. example: 7:30 a.m - 8:30 a.m. = 1 hr. Can this be done in excel?

I have an 8 digit string representing time (i.e., 13111489) How do I convert that to HH,MM ?

I need Crystal to compute these quarterly summaries

I need to develope a crystal report that shows quarterly units sold, comparing one year to another. Then predict what the current next quarter would be. I need four predicted columns showing the following formulas: Linear Regression Quadratic Regression Moving Average I have no idea how to...

yes, I am in a cell and want to copy something and when I do the right mouse it is gray. I have to do a ctrl C and ctrl V to paste.

When I am in a spreadsheet in excel and I use the RMB to choose one of the following: cut copy paste paste special clear contents format cells they are grayed out and cannot use. Why is this happening?