beverage

Hi all, kindly advice me for a VBA code so that to run through col. “E” and where find the codes which are in below extract, should transfer them from “Credit” side col.”J” to “Debit” col. “I”. Please see below original data and expected result. Thanking you in advance Original data <!--[if...

Hello Excelsior's! I am trying to write a formula to collect a subtotal of sales based off time periods. EG: Breakfast 6am - 11am // Lunch 12:00pm - 15:00pm // Dinner 17:00 - 00:00 Giving me FOOD & BEVERAGE total for the above periods I was going down the Line of using a SUMIF function...

Hi, I have lurked here for a while with things I've needed help with and have usually always found what I needed. This time, I have not and need some help. I am looking to take line item(s) with a total quantity and break them out into multiple items with smaller quantities based on a lookup...

Hi all, i would like to write a vba so that where in col. "D" the number start from number 92 and in col. "F" is the category "BEVERGAE" should place on number's right side "APERITIF" and if in col. "F" and it start from 92 should place "SPICES" and so on. In sch.1. are the original data and in...

Hello, Need help! I tried searching google and the forums, but for the life of me I can't seem to find what I'm trying to look for. I have a list of data in sheet1 and I'm trying to copy/paste each line into sheet2 on every 3rd row and then fill down the blanks. The list of data changes daily...