how to transfer row to another workbook base on a cell value in colunm a

hi to all you excel gods

heres example of what im trying to if column A in workbook part 1 has value 80 i would like it to copy row and put it in part2 workbook sheet name 80 and add it to part2 workbook every time 80 is enter in column a workbook part 1 also if the value 90 is add to column a i would like it to add this to part2 workbook sheet name 90


thanks in advance

shane

can it be done with a macro?
does the row needs to be deleted or just flagged posted

hi rcm

yeah macro would be fine but would rather if it could be done on after save event (if possible) no i would not want it to delete the row just copy it
sorry i would post example but this website acting abit funny at the moment not displaying everything to me


thanks for the quick reply

shane

i have add some sample workbooks to explain a bit better what i'm trying to do would much appreciate any help
i have try some codes and google the hell out of it still no joy

part2 example.xlsx
part1 example.xlsx

Something like:

Please Login or Register  to view this content.

hi yudlugar

thanks for your help im getting error with the code i will highlight in red where. also do i place this code on workbook part2 or part1
at the moment i run it in workbook part 2 cheers you legend !!!!

Please Login or Register  to view this content.

shane

Sorry forgot to add a sheet reference
elseif wb1.Sheets("1").Range("A" & count)

doesn't matter if the code is in 1 or 2.

Another:

Please Login or Register  to view this content.

thank you both your code perfectly legends !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

hi all
i have now tried to playing about with code would like it to check column b in part1 workbook copy row to part2 workbook and paste the row starting in column a but it seems to only copy the last of the code which is 10.10 and does copy over the rest present over here the code
any help would much appreciated im sure there something im forgetting

Please Login or Register  to view this content.

cheers

shane

Please Login or Register  to view this content.

hi cheers i seem to be getting array error can't assign array compile error

Please Login or Register  to view this content.

Is it possible to check sheet 1 to 31 not just sheet 8


thanks for your help you legends out !!!!!


shane

could you send a sample so I can test it?
this should work in theory...

Please Login or Register  to view this content.

Yeah the dim choice(10) thing is the issue, if you dim the array that way you need to assign with a loop. taking out the (10) will make it work.

I don't know if this coding would work?

Please Login or Register  to view this content.

I think it should be:

Please Login or Register  to view this content.

hi thanks lads

still having problems with the code "object does not support this property" have attacth some test files. what i would like it to do check column b in workbook example 3 check for values 10.1,10.2,10.3etc.. to 10.10 and check sheets 1 to 31 then copy rows to workbook4 example but paste the rows in column A workbook4 example sorry for the poor description
part3 example.xlsxpart4 example.xlsm

thanks alot for your help

shane

Maybe:

Please Login or Register  to view this content.

BTW your example only had one sheet which has data too copy in example 3, sheet1.

Thanks ,John

work perfectly just one more thing sorry to be a pain but it checks for values 10.1 to 10.10 but i would like it to check for 10G aswell if possible
you total legend

shane

Maybe:

Please Login or Register  to view this content.