restaurant

Hello everyone. I´m in a project where i need that the ingredients of a shopping list that have an allergen list can reflect them on the sub recipes and then in the recipes. On green i have the product list, I mark the allergen with a letter X on its right and then it should go to the...

Hi to all of you, I would like use a vba code so that to run through col. “F” and where the find the text like “Opening Balance” then to move the mentioned text from col. “F” 1 cell offset back in col. “E” and its numbers which are in col. “J” 2 cells offset back in col. “H” either positive or...

Hi all, I would like to use a VBA code, so that to run through col “G” and where find bold text should “SUM” the col. “I” less col. “J” in adjacent cell in col."K". Therefore, that the data start from row “7” and are more than 400000. Thank you in advance Original data <!--[if gte mso...

Hi all, I would like to use a VBA code, so that to run through col “G” and where find the text “Opening Balance”, should move the number in adjacent cell from col. “I” to col. “H” Therefore, that the rows are 100000+. I present below the original data and the expected result. Thank you in...

Hi all, I would like to use a VBA code, so that to run through col “B” and where find the name of each department, e.g. Restaurant, Pool bar e.t.c., should place it in col. “F” and rows down for each department’s records. Therefore, that the rows are 100000+. I present below the original data...

I'm attempting to forecast the sales for the last three periods of a restaurant. Given the way the sales vary overall, using a seasonal forecast sounds appropriate as I have last year's data. But, I'm open to other suggestions. I've come across the forecast.ets function. But, to say the...

Hi all, I would like to write a VBA code so that, to run through col. “F” and rows down and where exist bold descriptions should move them to adjacent cells in col. “A” Therefore, that the code should start from “F11”. Below I present the original data and the expected result. Thanking...

Hi all, I would like to write a VBA code so that, to run through col. “F” and rows down and where exist bold descriptions should move them to adjacent cells in col. “A” Therefore, that the code should start from “F11”. Below I present the original data and the expected result. Thanking you...

Hi all, kindly require to provide me support for a VBA code, so that to place in col. “D” the first 4 letters on the left side, from col. “F”. Please see below the original data and the expected result. I would be greatly appreciate any support Thanking you in advance...

Greetings! I am pretty new to vba and attempting to work through this problem as thoroughly as possible so any direction or help with be much appreciated. I have 3 worksheets that I am currently using: Sheet 1= "Table"- Which holds a list of profit centers (List is located in Range L3:L23)...

Hi All, I am a moderate level excel and VBA user, I want to create a billing system for one of my friends restaurant, I need suggestions from experienced excel users in the forum, how should I go about this. I mean what should be the approach for this system

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would like to write a vba, so that where in col. “D” the first two numbers on the left are like below, should place the relevant category on the right. The 1st schedule...