Re: Getting data from several worsheet/books

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mike Taylor (mtaylor_at_wwdb.org)
Date: 07/15/04 

Date: 14 Jul 2004 21:27:57 -0700

A couple of suggestions...first, search for posts that seek to
accomplish tasks similar to yours and study the replies. There is a
wealth of insight in many of the existing threads. Secondly, try to
organize your thoughts and offer more information so others know what
you are trying to achieve. And lastly, experiment with what you find -
and don't give up.
Best wishes...Mike

"CS" <anonymous@discussions.microsoft.com> wrote in message news:<2d3d901c469f4$964a6090$a501280a@phx.gbl>...
> Thanks for the suggestion. I guess it's time to learn how
> to write macros.
> >-----Original Message-----
> >I'm sure there are lots of alternatives, but I would write
> >a Visual Basic macro to do the job. You didn't mention if
> >you can write macros or not. If you can't you should put
> >some time in learning . . . it will solve a lot of
> problems
> >like this.
> >>-----Original Message-----
> >>I have 2 workbooks with multiple worksheets. They all
> >>contain columns of data labelled PartName and PartID
> >>(along with other columns). I would like to get all data
> >>from these 2 columns and put them in one spreadsheet. Is
> >>there a way to merge this info other than copy/paste to
> >>new worksheet? Thanks
> >>.
> >>
> >.
> >

Relevant Pages

  • Re: Need help making a spreadsheet for my business.
    ... To install the macros once unzipped see ... This thread illustrates one of the problems of not using a newsreader ... to read and post messages, you replied to Malik, but your ... their replies would be threaded directly under to the post they ...
    (microsoft.public.excel.newusers)
  • Re: Petzold debugged?
    ... > the problem is that the macros do not work for Windows 2000 ... regular ISP and news server, I can no longer see those replies, so I'll have ... the problem is that the author makes heavy use of macros to condition the ...
    (alt.comp.lang.learn.c-cpp)
  • RE: Macro efficiency vs other languages?
    ... insight. ... and perhaps quicker solution. ... macros are and if they are as efficient, less efficient, or more efficient ... than other programming languages. ...
    (microsoft.public.word.vba.general)
  • Re: using macros to import data
    ... thanks for the replies, the application is one a company I work for had ... built, All I really know is it is MS compatible and has the macros function ... >> I really only know the basics about macros and can use it to retreive data ... >> data from external applications but don't know where to start? ...
    (microsoft.public.excel.programming)
  • Re: Word Macro Issue
    ... insight into this problem. ... Terminal Services Program Manager ... that uses MS Word macros to display reports. ... When using Remote Desktop, no error appears; ...
    (microsoft.public.windows.terminal_services)