Hello,
I'm trying to create a button that when pressed will examine a set of linked specified cells (basicly a record with a name in it and the record to its right with a quantity in it, such as A4 and B4). What I want is for excel to look at each of the 'B' cells and check if they are non-zero, and if they are copy the 'B' cell and its corresponding 'A' cell to a designated Text box. i'll give an example in case my explanation isn't very clear
Example
Socks - 100
shirts - 0
glove - 0
vest - 12
skirt - 0
trousers - 0
, What I'm trying to make happen is, I press a button, and Excel would paste into the text box, (socks -100, vest - 12) with a carriage return after each pair.
If anyone could be of any help I would greatly appreciate it. I'm not new to the basic uses of Excel but i'm totally stumped on how to even begin trying to put this together.
Many thanks,
Raven
Bookmarks