General

append multiple columns
I have a time consuming task and was trying to find a way to append multiple columns of data (with blank cells) under column "A". Currently, my columns have data out to column "M", but this may increase or decrease. From: A B C etc. Thru Column "M" 1 Data1 ... 31 Mar 2010 13:16

VBA Code to Export Data from Chart
I have a chart that is automatically produced from Cognos. I export the data into Excel, but the data for X and Y axis is contained in the chart. How do I export that data into a spreedsheet? ... 7 Apr 2010 18:03

Missing sheet tabs and horizontal scroll bar
A user cannot see any sheet tabs or the horizontal scroll bar even though show the sheet tabs and horizontal scroll bar are selected in the Advanced Options. Is this possible? If so, how do I bring the sheet bars and horizontal bars back? Thx. ... 31 Mar 2010 14:22

Compare 2 worksheets
I have two work sheets that contain bill of material information of about 3000 component items required to build a system. There have been updates to the bill of material therefore, I need to compare the two worksheets and create a detailed list of changes or updates from the 3/9 bill of material to the 3/30 bi... 31 Mar 2010 13:16

Forumal writing for imported sheets
I would like to move sheets from one Excel workbook into another. Currently, I have a template that requires me to copy and paste one sheet at from one workbook to the other. Workbook1 contains data from a report that I run. Workbook2 is my template. How can I write formulas in workbook2 so they will read d... 31 Mar 2010 12:08

INDEX and OFFSET Formulas
If I have a set of veritcal data for each employee, but each set of data could range from 1 to 4 vertical values, is there a way to change the following formulas to accomodate moving the data from horizontal to vertical?: =INDEX($A$2:$A$1690,1+(8*(ROWS(H$1:H1)-1))) =OFFSET($G$2,ROW(A1)*8-8+COLUMN(R2)-18,) ... 31 Mar 2010 12:08

email a worksheet
Is there a way to email, just one worksheet froma workbook, don't want to send entire workbook, right now have to do alot of copy/paste into an email with just content want. Excel 2007/Outlook 2007 on Vista enterprise ... 31 Mar 2010 12:08

Double If Statement help
Hi I am trying to create a formula that will look in column "b2" which will be a reference to a month i.e Jan then if the answer is Jan, then look in column "h2", to see if it contains a "1" (it will either contain a "1" or nothing). If it does i need it to take the value out of column G2 (which will be a number) ... 31 Mar 2010 13:16

reformat dates to yyyy/mm/dd
I have a worksheet with dates of mm/dd/yyyy I need to reformat them now to be yyyy/mm/dd Whats the formula for that? ... 31 Mar 2010 14:22

Compare worksheet data
I have two worksheets that are in separate workbooks that I need to compare. The information is structured the same in both sheets. However, there was an update to the bill of material which may have added rows of information throughout the sheet, or may have added additional information within the columns of o... 31 Mar 2010 11:00