• Conditional Formatting – Excel 2007

    Greetings. I was on hiatus from this excellent forum for some time. Got involved in too many other tasks & was unable to free myself to devote time to this forum. Now, I am seeking help on how to extend Conditional Formatting rule. The scenario is this: I have a worksheet with about 200 rows. In...

    SbElectric2,540 pointsBadges:
  • Graphing Challenge in Excel 2007

    I am working on a project, and was wondering if there is a quicker/better/easier way to do it than what I have been doing. I have two sets of data - one for 2009 and one for 2010 - broken out by department (there are about 100 different departments with which I am working). The data sets contain...

    Mchel275 pointsBadges:
  • Excel 2007 macros

    In Excel 2007: How to make current time/date (static) populate active cell when command button is clicked?

    Mcvla5 pointsBadges:
  • View row labels as column headings when scrolling in Excel 2007

    Row 1 contains the column labels, when scrolling the A, B C column headings are replaced with the row names. It is not "freeze" situation.

    Onthemove5 pointsBadges:
  • How do I disable save/save as and control +s and f12 in excel 2007?

    I want o disable those and only allow save feature through the macro I established

    Errtu5 pointsBadges:
  • Excel R1C1 referencing

    I have an excel spread sheet created via Crystal Reports export as a data only 2000-2003 excel (xls). Within this spread sheet are cells containing formulas with R1C1 referencing. When I open the spread sheet, the formulas are not calculated. I have changed cell referencing to R1C1 via the Office...

    BTod45 pointsBadges:
  • Matching data in Excel

    Hi, We have two sets of data in Excel that we need to match up and combine when they match. Spreadsheet 1 has two columns, A is a S/N and B is the page count. Spreadsheet 2 also has two columns, A is the S/N and column B is an ID number. We need to match the S/N from spreadsheet 1 with spreadsheet...

    Aslan5 pointsBadges:
  • How can I e-mail data to be viewed in Excel?

    How can I e-mail data, to be viewed in Excel, from a programme written in VB6, so that when the recipient opens it, the Excel workbook shows not only the data, but copies all the formulae, eg. Totalling columns etc. and the formatting, eg. colours?

    Martinyk10 pointsBadges:
  • Does excel 2007 on Win 7 64 bit create temp files?

    We have a user who was working on a file for a long period of time when the power went out. She had not saved it recently but shouldn’t we be able to grab a temp file? Excel 2007 on a Windows 7 laptop. 64 bit.

    Karl Gechlik9,860 pointsBadges:
  • Proper Excel 2007 macros to identify table

    dear sir/madam i have a table such as the left table and want to extract a table like the right one please give me the proper macro. best regards. hamid [table style="border-collapse: collapse; width: 300pt;" border="0" cellpadding="0" cellspacing="0" width="400"> [col style="width: 63pt;"...

    Hamidirani575 pointsBadges:
  • How to export excel data to Sql server 2005

    How to export excel data to Sql server 2005

    Rasheed1802075 pointsBadges:
  • Multiple Names in Excel 2007

    I have a Excel sheet with hundreds of names and the same person may be repeated twice How do I create a formula so that I can like it to a new sheet and it only show a persons name one time

    Maine325 pointsBadges:
  • Problem in Data Downlod from SAP to Msoffice 2007

    Problem in Data Downlod from SAP to Msoffice 2007. If i use data export option from SAP to Excel 2007 a blank xls sheet open but no SAP data apear in sheet.

    Mkamil5 pointsBadges:
  • I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell.

    Hi.  I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell.  i.e. the VB code should allow the "Cells.Find(What:=) to be VARIABLE based on what is pasted.  Any suggestions?

    ThomasRichardJohnson5 pointsBadges:
  • VBA Excel – paste not working

    I have the following piece of code attached to my Excel worksheet:         ActiveSheet.Shapes("Object 407").Select         Selection.Copy         Range("BP106").Select         ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. ...

    Paustin5 pointsBadges:
  • Excel limiting access

    I want to be able to give access to a spreadsheet for a certain period of time, or until a specific date. Can this be done, and what is the most effective way?

    AussieNewcastle5 pointsBadges:
  • Embedding Microsoft Excel spreadsheet 2007 into Notes 6.5

    My computer is running Notes 6.5 and Excel 2000. I have a request to display data in Microsoft Excel and for my computer it works fine. But when I try it on a laptop running Vista, Notes 7 & Microsoft 2007 the embedd statement doesn't work. I have it coded as: Set object =...

    Gsplmgc70 pointsBadges:
  • Excel Macro

    I created a macro and it is saved in personal.xls. How can I make this macro available to other users? I want to be able to give them the ability to run the macro - they do not need to modify it.

    lorit365 pointsBadges:
  • Converting Lotus Approach files to Excel 2007

    I received a Lotus Approach 97 .APR file extension file on a flash drive. I need to import it into Excel (Microsoft Office 2007). I am a beginner with Excel and I need to know the steps required to import the Lotus Approach 97 file on the Flash Drive to Excel. I would appreciate any information or...

    MelanieYarbrough6,345 pointsBadges:
  • Enter key does not get translated when doing a mail merge into word from excel

    We are using Mail merge to automate status report generation for our projects. The data source is excel 2007 spreadsheet. The merge field in excel has multiple lines concatenated with a enter key coded as Char(13) in excel. In some places this key gets translated as _x000D_ in word. This happens...

    Tskn5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following