Good day, I am trying to create a button that will do the following;
- Search a starting point of data until the first blank spot. See below Img. (Data set begins at; Qty - A51, Item # - D51, Description - O51, Selling Price - O51 (Other data does not need to be copied))
- Copy/paste a tab to the same number of items found (If 4 items are found, then 3 tabs are created (1 tab is already provided)) Sheet # to be copied is Sheet5.
- Copy/paste each individual item into a separate tab. Item 1 goes in first tab, Item 2 in 2nd tab, item 3 3rd, etc... until all items are placed in a different tab. Qty, Item #, Description, and Selling Price will all need to be copy/pasted into a specific cell in the new tab.