Hello

i would like to know if it's possible to create a certain type of macro in excel,but
I have very little experience so far so i don't know even if it's possible.

I want to automate the following process:

-read a sequence of numbers in a worksheet (all in the same column)
-the go in another spreedsheet, search for these numbers (also in 1 column) and copy the contents of the cells that are in the same line with the numbers
-paste the numbers and the contents of the cells in another spreadsheet

is it possible?

thanks

Hi KDel,

Welcome to PCHF.

It is actually, possible to do absolutely anything you want in a Macro. More complex Macro's require some experience in writting in Visual Basic. But more simple Macro's like this, that only really require you to copy from one spreadsheet, and paste in another?

If so, all you need to do in this case, is start your Macro to record. Highlight the fields you want to copy, and go to Edit, Copy. Open up the second spreadsheet, and select the row/column you wish to paste and go to Edit, Paste. Finally close the second spreadsheet, and then end your macro. It's that simple!

Hello again tha thanx for the reply

actually what i want is a bit more complex. Because i want the copied fields to become search strings in another spreadsheet.

So,

i have a spreadsheet with some codes
i want to copy these codes and search for them one after another in a huge spreadsheet which has all the available codes
and then copy the lines which contain my codes,again one after another , along with their description which is in the cells next to the codes.

so the hard part for me now how to automate the whole process for a number of say 20-30 codes

thanks for your help

Hi KDel,

In that case, you would be better to look for a programmer in Visual Basic to do this work for you. Guru.com - The world's largest online marketplace for freelance talent. or Kasamba – Expert Advice, Live. is a good place to look for one, if there is nothing local.

EDIT: Marked as answered.