General

Looking forMacro to do this Sheet to Sheet copy &sort
Hoping just like the previous time you experts on here can help me. I'm assuming a Macro is the way to do this If Sheet1 column F starting at F2 has a y entered, then copy data in cells A2, B2,G2 to Sheet2 to the first available empty row below the headers in row 1. At the same time as it looks for a y I ne... 8 Feb 2010 16:51

Need data result in last cell of array that contains blank cells
Example: A1=200 B1=300 C1=400 D1=[blank] E1=[blank] F1=[blank] G1=(last cell from above that contains data...i.e. C1) I'm a bit of an Excel novice so could really use a little help. Thanks! ... 8 Feb 2010 15:42

add rounded numbers using the rounded value
I want to add the value of 2 numbers that are rounded and want to use the value at 2 decimal points, not the whole number. ... 8 Feb 2010 15:42

DOS..BAT file problem from VB
I have a program that prints to the screen. From a DOS window, or with a BAT file I can redirect the data to a file via the following command "Path Arg1 Arg2 >Filename. But, when I execute the BAT file from a VB program, using either Shell or FollowHyperlink, the output file is created or recreated but remains ... 8 Feb 2010 14:33

Can you change case settings on excel as easily as on word
... 8 Feb 2010 13:24

Linking chart title to a cell 2007
In 2007, how do you link a chart title to a cell? In my situation, I have a pivot chart and I want the chart title to change when I change one of the filters. The filters are different sites. I would like the chart title to change to the one item I select from the list. For example, I have sites 1, 2 and 3.... 8 Feb 2010 12:16

windows7 excel2007 problems
I cannot open more than 1 worksheet at a time. Aero shake and snap not working with Excel. Thank you. ... 8 Feb 2010 11:07

Value Exchange with a Button Click
Barry - Record a macro where you copy / paste special values that you want. Then have the button call the macro you just recorded. -- Daryl S "Barry" wrote: Using Excel 2003 in Windows XP sp3 My workbook has two worksheets. On worksheet 1 in cell B3 (Named Payperiod1) is a date value. On... 8 Feb 2010 11:07

Hyperlink does not show full address
I am using a file that shows a partial address for a hyperlink. I would like it to display the full address. How can I fix this? ... 8 Feb 2010 14:33

Quarter Hour time conversions for timesheet
Users enter a time that needs to be converted to quarters of an hour. For 8 to 22 minutes past the hour = x:15, for 23-37minutes past the hour = x:30 For 38 to 52 minutes past the hour =x:45 and For 53 minutes before the hour to 7minutes past the hour = x:00. Many may ask Why? Its the way its always been d... 8 Feb 2010 10:00