• Excel Macro to parse list of excel files and move them depending on a single cells value

    Does anyone know how to creat an Excel macro that I can run on a directory of excel files that will look for a value of cell B47 and if it's > 600 move it to another directory and if it's < 600 move it to another one?

    Kferranti5 pointsBadges:
  • How to paste data directly from Excel to PowerPoint graphic as data

    I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste the data in. Any help...

    Charm20 pointsBadges:
  • Combining data from two Excel sheets into a new sheet

    Hi, I Have few leave detail excels wherein the leave details of each resource are present.I need help to create a macro wherein all months leave details will be clubbed together into a new excel for each resource.Kindly help me with the code or give me some ideas to do this since am very new in...

    Vaibhav1235 pointsBadges:
  • AS/400 to Excel

    Hi Someone, I am using FTP to send a data file fromthe iseries to the server as a .txt file usint put statement. Can anyone suggest how I would sent the file direct to an Excel spreadsheet, preferable to a pre-formatted sheet. Thanks.

    tjgm88995 pointsBadges:
  • Converting spool file output to Excel in RPG without third-party software

    I would like to know how to write an RPG program and have my spool file output be converted to an Excel file without using any 3rd-party software.

    AS400 - Ask the Expert485 pointsBadges:
  • Export from database to Excel and filter by DropDownList

    please provide me with all information on how to export my data to an excel sheet and how to filter the data using a dropdownlist (asp.net)

    Yaz5 pointsBadges:
  • Excel 2000 Chart Won’t Automatically Update

    My Excel 2000 chart won't automatically update when I change the data in one/both of the columns in the attached spreadsheet. I have checked the automatic button under Tools/Option/Calculate, but it still does not work. The only way I can get it to work is if I go into the chart and change one of...

    Bacham5235 pointsBadges:
  • Advice on buying new PC

    I have a Pentium 4 & need to upgrade. I teach Microsoft, use graphics in my manuals, & use CorelDraw a lot. I also design huge Excel spreadsheets with lots of formulas and design databases in Access - what would be a good PC processor, ram, etc? I have been quoted on a system with a Quadcor...

    Shazzie70 pointsBadges:
  • Import lotus notes view data from Excel

    I need to import frequently data from some Lotus notes views into my Excel Sheets, I want to know if they are a macro or a vb script which could do that.

    Witold200830 pointsBadges:
  • Copying a portion

    how can a copy just the last character from one cell to another?

    Richccac5 pointsBadges:
  • JDBC/ODBC to Excel 2007 getting Exception

    Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at...

    Ansipar288315 pointsBadges:
  • To connect to Excel 2007 using free version API Java

    Presently we are using JavaExcel(JXL) API to read/write from the Excel 2003. Now we have to update to Excel 2007. The problem was JXL is not supporting for the Excel 2007. The other API's are in the Beta version. Guys any API's are there to support Excel 2007 ......

    Ansipar288315 pointsBadges:
  • Importing email addresses from Excel

    I have a list of email addresses and names in Excel that I would like to send an email using outlook. Is there an easy way to do this?

    Rickthomp5 pointsBadges:
  • New to macros

    Hi, I'm just learning how to use macros and the first thing I'm trying to do is create a macro that will pull a character from a cell and place it in a new cell- for example "right(c10,1)". My problem is I have a large list that I want to do this with but everytime I click on my macro button it...

    Buyer5 pointsBadges:
  • Address Group List

    What is the best way to take over 600 contact emails from excel and create a lotus notes address group to send emails to?

    Bkey5 pointsBadges:
  • How would you calculate, using the spreadsheets statistical functions, the cheapest option at the fastest speed with the least downtime?

    i have 5 tables each including speed, price, download limit, average downtime and the average uptime. i was asked by my teacher to calculate all these so i get one number, to find out which is the best value for money for someone to go for. i just need to know what do i calcute to what to get my...

    Moron125 pointsBadges:
  • Updating a shared list

    I have 30 people in my group. I need a way that they can each document a problem with a particualr system we all use. I've been doing this with an excel file - everybody just opens the file and enters a new row of data when they find a new issue. Now, we need to do this so often several people may...

    SomeDudeinTX20 pointsBadges:
  • 2003 Excel crash

    Excel 2003 crashs when opening a Excel 2000 spreadsheet with graphs. Recovery removes the graphs.

    Prthibodaux5 pointsBadges:
  • 2 criterias

    I have 2 spreadsheets. The first one contains data for the mos of July and August. The 2nd spreadsheet contains Sept data. The unique columns in both are segment number and business center number. How can I get sept numbers into the first spreadsheet

    Bella5 pointsBadges:
  • Is there a macro to transfer a row of data from top to bottom row of range ??

    I use excel 2007. I have a s/s encompassing over 350,000 rows. Data consists of a series of ranges from columns A:N and rows varying in number between 3 and 30. There are two blank lines between each range of data. Each range is (with exception) numerically ordered down column H (e.g, 1, 2, 3,...

    Colwyn25 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