• Vlookup repeated dates

    I have a spreadsheet (A) with various data, where one column contains variuos dates, and one column with values. I want to be able to distinguish all values for each year, so I have another spreadsheet (B) with a long list of all dates for 2010, 2011 and 2012.  I use vlookup...

    Msva5 pointsBadges:
  • how to create autonumber

    while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don't think its an autonumber because i used manualy so, hlp pls

    Army125 pointsBadges:
  • Adding “days” to a cell in Excel 2007

    I have a list of # of days' inventory for a product and wish to add "days" to each cell. For example, "29" would appear as "29 days", with the numerical value unchanged, so my formulas still work. How do I do this?

    Chirofriend5 pointsBadges:
  • use Data connection wizard / Microsoft query to get data from as400 to excel 2007

    Hi, I know the way to download data from as400 to excel 2007. It can be done by using Data connection wizard or Microsoft query. However, when using (1) Data connection wizard, i don't know which kind of database i should choose. ODBC DSN or Other / advanced ? after choosing the kind of database,...

    Clarksonneo15 pointsBadges:
  • Keep Text to Column format in Excel 2007

    We're wondering if there is a way to get Excel 2007 to remember the previous Text to Column settings. We are receiving reports in an email that we copy into Excel. We run the Text to Column>Delimited>Delimiters (Only Other = |)(Text Qualifier left as default = *)>Column Data Format...

    Littlejuanito7420 pointsBadges:
  • Excel 2007 ‘Edit Links’ Command deleting information

    I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit...

    Hporiginal15 pointsBadges:
  • In Access 2007 for query exports to Excel 2007 – How do you turn off Automatic backups

    How can Access 2007 be set so that when it exports queries to Excel 2007, backups are NOT created in Excel each time the Excel file is saved?  How can Access 2007 be set so as not to cause EXCEL 2007 to backup exported query files?

    2010475 pointsBadges:
  • Create a macro in Excel 2007 to disable save

    I need to create a macro in Excel 2007 to disable save

    Basilmartin5 pointsBadges:
  • How to call Microsoft Excel from Oracle Forms 6i

    I have a form that has to put data to excel. The excel file is being created but my problem is the data is failing to insert from oracle to excel. I am using forms 6i. My machine is running Windows 7 Enterprise and office 2010. I have tried it on one with Excel 2007 and it works fine. I am using...

    Taps5 pointsBadges:
  • Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows

    How do we transfer/export data with over 575,000 rows in Microsoft Access 2007 to Microsoft Excel 2007? Is there a way to change the export data # of rows restriction of 65,xxx rows to 1 million rows in Microsoft Access 2007?

    MLM10 pointsBadges:
  • How to accept user input and display the value in Excel 2007 macros

    I Created an Excel macro that prompts the user to enter two cell numbers. I want to then display a msgbox back showing the cells that were entered. Problem. My msgbox shows the text in my message and instead of showing the values the user entered, it shows 'TRUE'. Any ideas?

    jkeri360 pointsBadges:
  • Excel 2007 – creating a graph from CSV data with a macro

    I want to create a macro that will take a CSV file and remove the same columns each time. BUT the number of rows can vary.  Can I create a macro that will create a grapgh ? The problem is, like i said before, the number of rows can vary each time but the number of columns is consistant.

    jkeri360 pointsBadges:
  • Excel macro – create a chart

    I created a macro that reforms my data and creates a chart. Teh macro also includes selecting a chart layout that has an x and y axis field that I want to enter in some text. My macro works all the way except it does not record the content I put into the X and Y axis.   Why is that? and how can i...

    jkeri360 pointsBadges:
  • VBA to separate overlapping times

    I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here...

    Jace75 pointsBadges:
  • Search for column header in Excel 2007

    I use a macro for a weekly report. In the macro i use "Column ("C:C").Select to select that column to filter out the zeros. Sometimes the information is in a different column when the data is downloaded, but the header of the column is still the same: "90_day_Late". How do i search for...

    Francino5 pointsBadges:
  • Why are my Word and Excel documents automatically zipping in Microsoft 2007?

    Why are my Word and Excel documents automatically zipping in Microsoft 2007? When I save a document, is there a specific way to name them that will prevent this?

    Celticgirl5 pointsBadges:
  • Problem creating during hyperlink recall with Excel 2007

    if am copying a folder in desk top that folder contains xl2007 sheets, in one of the sheet i was inserted some hyperlink for supporting folder.if am pasting this folder in desk top it may creating some problem means after opened the xls file am clicking the link that time file could not be found...

    Msn8525 pointsBadges:
  • Excel 2007 and Picture mode

    When working in Excel 2007 Compatability Mode (XP, 2003 Office) when i go to cut, copy past the data into another spread sheet it pops into Picture Mode and locks up the data. If I put the data into 2007 and then cut, copy, paste it is editable and I can work with the data. Is there any way to turn...

    Fischerman7229260 pointsBadges:
  • Sending Excel 2007 spreadsheet without calculations

    I want to save a copy of my spreadsheet to send to someone, without them seeing my calculations. I need to convert the equation, save the answers as they appear in number format. I know there is an easy step but can't find the terms to search it properly. (Excel) Can someone please assist me?

    Matilda5 pointsBadges:
  • rows don’t line up or text does not appear with excel 2007

    I have instances where the rows (left freeze panel) do not line up ( and right panel)!!! sometimes the text does not appear on the screen, OR looks like it writes over itself. Happens when i do a control f to find text usually but not all the time. Anyone else having this problem?

    Peasandcarrots5285 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