I am trying to pass the contents of cell A1, A2 etc to a new worksheet only if the corresponding check box in cells B1, B2 etc are selected. I also need the new worksheet to show the cells neatly formatted with no blank cells.
Thanks
Thanks,
I had the first part with using the linked cells but was unsure about the formatting.
I'll try posting in the VBA forum and see if I can get something a bit neater but otherwise great thanks.
tait
I am trying to pass the contents of cell A1, A2 etc to a new worksheet only if the corresponding check box in cells B1, B2 etc are selected. I also need the new worksheet to show the cells neatly formatted with no blank cells.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.