Search : in
By :

Macro to filter copy and paste to another wor

Last answer on Jul 31, 2009 8:10:34 am BST KM, on Jul 27, 2009 1:52:09 pm BST 
 Report this message to moderators

Hello,

I am a novice in macros.

I am trying to create a macro that finds a number in one workbook then goes to another workbook, filters the data using that number and copies and pastes the data of the selected rows back to the first workbook.

The data is in a spreadsheet called "Lines" (in one workbook). The other workbook with a spreadsheet called "Anlines".

In "Anlines" Row1 Column A is an account number.

I want to read this account number.
Goto the other workbook (spreadsheet "Lines") , filters the column "J" to find this account number.

Then copies all the filtered rows into the "Anlines" spreadsheet starting from 3rd row.

Is it possible?

Thanks for your help.

Regards
KM

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Macro to filter copy and paste to another wor » in :
Excel macro for copy & paste selected range (Solved) Show
Copy/Paste problems when using Firefox Show Copy/Paste problems when using Firefox Pushow Adware Extensions It happens that sometimes, Firefox refuse to copy/paste items. Two assumptions can be made: Pushow Adware You have been infected by an adware, named pushow**.dll...
Quick Copy/Paste under Ubuntu Show Quick Copy/Paste under Ubuntu Intro Uses: Intro Under Ubuntu there is a quicker alternative to make a Copy/Paste other than using the native CTRL V and CTRL C combinations . You simply select the target text (it is uploaded in...
Copy, Paste and Cut not functioning ShowCopy, Paste and Cut not functioning Issue Solution Issue I am having a problem, every time i want to copy, paste and cut my files, it's not working. Even am trying to use the keyboard combinations, CTRL+X, CTRL+C, and CTRL+V but it's...
Vi/Vim - Avoid tabs when making a copy/paste Show[VI/VIM] Avoid tabs when making a copy/paste By default, when you make a copy and paste in vi or vim (through an remote SSH session), it adds incremented tabs at each line. To solve this problem,simply type: set paste in the window or add the...
Centering vertically a web page ShowCentering vertically a web page e .js file e .html file Centering vertically a web page; consider it as a waste time trying to achieve it with CSS. The most practical solution is to use JavaScript. e .js file Copy/paste the...
Download IPod Copy Expert Show
Download Super Audio Editor Show
Download Fonter viewer ShowFonter viewer is a tool to view fonts. The program uses HTML to view the installed fonts on your computer. View all the fonts and print the font list or an example of a font text. Use the clipboard of Windows and copy/paste to compare various...
Linux - The Vi editor ShowIntroduction to Vi Despite its very limited ergonomics, Vi i is one of the most popular text editors texte under Unix type systems (with Emacs and pico). Under Linux, there is a free version of Vi called Vim (Vi Improved). Vi (pronounced vee-eye)...
Ask your question Reply

1

iveal, on Jul 30, 2009 3:42:06 pm BST
  • +1

Hi there,

follow these steps:

1. Go to Start>

Programs>

Microsoft office>

Microsoft Excel to open the application.

Then, go to Start>New to open a new spreadsheet.

Go to File>Save as and save the new file before going
further


2. Go to Tools>

Macro>Security,

and a pop up window named security will appear.

Select the Medium option under the Security Level tab and click OK to continue.

3. Go to Tools>Macro>Record New Macro.

4.In this step, you will record the macro.

You will see a tiny pop up window that will appear with a blue button you can press this blue button at any time to stop recording the steps


Thanks

   
Reply to iveal

2

KM, on Jul 30, 2009 5:48:00 pm BST
  • +3

Thanks for that but the two files/workbooks already exist and I am looking for the actual macro that will cut and paste between the workbooks.

Regards
KM

   
Reply to KM

3

 Sri, on Jul 31, 2009 8:10:34 am BST
  • +1

You will find two Macros in the same VB Script file, so you can select first and copy the code and then go to another macro and select( you will find in the same script file) paste it.

   
Reply to Sri
Ask your question Reply
They need your help