Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and copy
I have two workbooks A & B, A is a workbook that has a sheet for every day
of the month and is saved daily, B is only used each day to print off the necessary information and is not saved. The data in A is as follows: A B C D E F A1 1 1 1 B1 1 1 1 A12 1 1 1 B3 A1 1 1 1 1 C 1 1 1 1 1 I now need to be able to search Column A and pick out any rows where the data begin with A and then I need them to be able to copy these rows into workbook B for printing off. I was going to set up a macro for the printing and saving and searching, however I am struggling with a formula to search and copy the data in the rows. Any help would be much appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and copy
I believe you would need to use vba to achieve what you want, do you want to copy all rows from all sheets that have Ax in column A (where x is anything else) when running the code? Sj;443564 Wrote: I have two workbooks A & B, A is a workbook that has a sheet for every day of the month and is saved daily, B is only used each day to print off the necessary information and is not saved. The data in A is as follows: A B C D E F A1 1 1 1 B1 1 1 1 A12 1 1 1 B3 A1 1 1 1 1 C 1 1 1 1 1 I now need to be able to search Column A and pick out any rows where the data begin with A and then I need them to be able to copy these rows into workbook B for printing off. I was going to set up a macro for the printing and saving and searching, however I am struggling with a formula to search and copy the data in the rows. Any help would be much appreciated. -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123007 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and copy
No, the each sheet in workbook a refers to a day and I only need to link to B
for that day, A will then be saved and I will set the code to print off B and close without saving, it's the search and copying of the cell data to B that I am having problems as I am unsure what code to write. "Simon Lloyd" wrote: I believe you would need to use vba to achieve what you want, do you want to copy all rows from all sheets that have Ax in column A (where x is anything else) when running the code? Sj;443564 Wrote: I have two workbooks A & B, A is a workbook that has a sheet for every day of the month and is saved daily, B is only used each day to print off the necessary information and is not saved. The data in A is as follows: A B C D E F A1 1 1 1 B1 1 1 1 A12 1 1 1 B3 A1 1 1 1 1 C 1 1 1 1 1 I now need to be able to search Column A and pick out any rows where the data begin with A and then I need them to be able to copy these rows into workbook B for printing off. I was going to set up a macro for the printing and saving and searching, however I am struggling with a formula to search and copy the data in the rows. Any help would be much appreciated. -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search / Compare / Copy Value Up (cpm) | Excel Discussion (Misc queries) | |||
How to search column, copy row, and copy to another sheet in same | Excel Discussion (Misc queries) | |||
Search and Copy | Excel Worksheet Functions | |||
Search and copy certain text | Excel Discussion (Misc queries) | |||
Search and copy | Excel Discussion (Misc queries) |