one cell contains selected criteria, then copy the row ?
"OssieMac" wrote:
This could be done with a macro. If you are interested then if you provide me
with the following information then I'll write the code for you.
What is the worksheet name containing the data being searched? Data.xls
What is the worksheet name to where the data is to be copied? FullGoods.xls
Is it always the same column to search? (If not, I can set it up so you will
need to select the column before running the macro.) It will always be Column A
Am I correct in assuming that the row of data is to be appended to the
bottom of existing data in the worksheet to where it is being copied? Ideally i would like it to overwrite the existing data where it is being copied, if possible
Does the row of data need to be deleted from its original location or only
copied? Only copied
What type of data is to be searched for in the column? (That is Numeric,
String or text, date etc). Also is the data being searched the entire cell
contents or only part of it. Example: Cell contains "My apple". Search for
'My apple' or search for part like 'apple'. It is numeric eg. 09107045. It would only need to search the first 4 numbers
Do you know how to copy a macro into a workbook or would you need
instructions? I think i do, but instructions would be good (just in case)
Do you know how to create a Command Button from the Control Toolbox toolbar?
(Not from the Forms toolbar). Yes
What version of Excel are you using? 2003
If you want the macro, then please ensure that you answer all questions.
--
Regards,
OssieMac
"gcouch" wrote:
I have a master spreadsheet that changes everytime it is updated, and it
contains 5 columns of information. In a new spreadsheet i want to be able to
search for one column for a specific bit of information, and when found it
will copy the whole row of information ? Is this possible ? Or do i need to
enter different formula's in each column of the new spreadsheet ? Any help
would be appreciated.
|