importing specific data into a new excel spreadsheet

[AllieR]

Hi there-
I worked with some terrific guys a week or two ago, and they gave me a
visual basic code to make data from a larger spreadsheet pull out specific
columns and put it into a new spread sheet.

I don't know how to make the code work, or where to put it. can you help??

Below is the thread from my initial "conversation."

thanks for any help you can give me - allison

Thanks again, Joel...this may be a stupid question, but what do I do with the
code?? I tried a couple of different things, nothing worked. Any chance you
could walk me through where it goes, and how to make it work?? thanks a
BILLION!

allison

 

[Eduardo]

Hi Allison
you have to create a button to run you macro, if you are working with excel
2007
go to Developer Insert Form Controls and choose the 1st button
Then right click in that button, assign macro, new, this will open the VBA
code. Here is where you paste your code, then close the application and when
you press in your button it will run the macro

 

[AllieR]

Thanks, Eduardo -

I'm using Excel 2000...would it be the same?

allison

 

[Eduardo]

hi,
No is not the same go to View, Toolbars, Forms, and then select the 2nd
option in your 2nd column and then proceed as I told you before, need more
help just let me know, if this was helpful please say yes. Thank you