Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Macro help


  • Please log in to reply

#1
EPounds

EPounds

    New Member

  • Member
  • Pip
  • 2 posts
Is there a way to set up a macro to search multiple excel files in a given directory and compile specific information from each spreadsheet into a master file?
  • 0

Advertisements


#2
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
why would u want to do that?

can u give me a little more info on why and ill help u out

like what kind of info are u searching for etc

Thanks

Stu Design
  • 0

#3
EPounds

EPounds

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
I am trying to track progress for a project. I would like a macro to search a specified column in various excel files that are based on a template and pull progress statistics like "in progress, completed or not started".

Basically put, have a macro or something that says go to this directory, open these files, and report this to a new excel file.
  • 0

#4
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
yes here goes, wait this take awhile...

im going to get on it i have to find out some stuff first

Stu Design
  • 0

#5
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
looked for it and i found this hope this helps

http://www.exceltip....excel_2000.html

if it doesnt message back

Stu Design
  • 0

#6
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
oh and i hope u know VBA, to do this otherwise, just try the link and muddle ur way thru or ask in the programming forum on geekstogo.com

Stu Design
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP