+ Reply to Thread
Results 1 to 2 of 2

Need advice on how to extract data.

  1. #1
    Registered User
    Join Date
    03-08-2010
    Location
    Us
    MS-Off Ver
    Excel 2007
    Posts
    2

    Need advice on how to extract data.

    Hello there, I am a very basic user of excel and have little to no experience with programming. I am trying to create a script of some sort that will allow me to grab data from certain cells in a certain excel file, and paste the data into a new excel doc and save this doc to a specific folder on my desktop. All automatically. At my work, we have a invoicing program that we export a daily excel file with information of sales for that day. I am looking to only grab certain data out of this file however....that is why I need a script that can automatically grab this data and put it into its own, new excel doc.

    If anyone could direct me to a good tutorial on this topic It would be greatly appreciated. Thank you.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Need advice on how to extract data.

    Hi,

    I don't know of a tutorial that will give you the information that you require but if you want some help putting code together that will do what you want I'm sure either myself or someone else here will be happy to assist. If so can you give some more specific information as to what you want copying and the process that you would go through manually to do this.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1