formula & macro

Hi there I would like to know how I can set the following type of invoice numbers to be recorded on a different sheet by the use of a button form control and how I can use another button form control to automatically generate the next invoice number when I press the button as the sequence...

I have to create several thousand alphabelical codes and I usually use the formula below but for some reason it is not working anymore. I usually just type the first alpabetical code I need add the formula below to generate as man as I need. Could some of you look at this I am stumped...

I have a challenge, if anyone is kind enough to assist. I can probably put a formula together for 1 condition, but the mix of mileage/date has be stumped! I am attempting to create a spreadsheet for my boss that tells him if a vehicle is due a service. (I have been in this job 1 month and I...

Hi, i am still in learning process with Excel i am trying to make head to tail of a thing so here is my question and please if you can give me some guidance on how to sort this out for me, so i created this excel form that i am trying to introduce to work and i managed to get most of the thing...

Hi all, I could use some help. I am creating a predictor for roulette and I am trying to figure out a way to count the distance(s) between the winning number and the nearest number (in regards to the winning number) of the combination that I get from the predictor. To better explain my...

Hello everyone, I am noticing a problem with my macro, but I can't find where I broke it. The reason it broke is because I was trying to fix a problem where my macro deletes the =SOM formulas that were in the same column. Here is an explanation of what my macro does: My macro needs to copy...

Good Morning. I have two sheets that I am working with essentially a calendar for individuals so I actually have one master sheet and 60 individual sheets. The "individualcal.xls" sheets gets sent to out 60 individual members each year who update their sheets according to their availability...

In my Workbook there are 20 Worksheets using vba. These codes in each ws removes formula from different cells at a particular given ‘time’ & leaves the value in these respective cells, although the ‘time’ differs from ws to ws. In a new ws (tab named “Record”, Sheet98), C2:C21 contains ws “tab...

Hello there, Here, we have a Red and White Coloured cells in "Remarks" Column. The white coloured cells are fine and need not to be worried about. As shown, there is a continued red coloured cells upto S.N 5 Row starting from S.N No 2 Row. So, I want to copy its corresponding "Ending" Column...

Sir, I'm looking for a formula that generates the Date ID from Date value like below in mini sheet, I found a pattern using CountIF on A1&B1 that is 1/1/1900, I don't know how to use this pattern for 05.09.21(todays date) to get a Date like in the below cells. Thanks in advance Date ID...

I am trying to create a macro for a small business to help with their payroll. It would be simply the user typing in the name and the hours worked. The other cells would have formulas to help calculate the net pay. The table below shows an example of what I am doing right now. On one tab, I have...

I am struggling to get the expected output as below. Input data: Output data: In the output data - Column 2 is unique concatication of Column 2,3, and 4

I need to know what the VLOOKUP FORMULA is for moving numbers between these 2 sheets because I can not figure out the formula myself. I have tried all day, and I can not get it. JUST LIKE IT SHOWS IN THE SCREENSHOT ABOVE. I have 2 sheets named "Testing Day 1" and "Month 1 Week 1". I want to...

Company Name Count of Names 1 2 3 4 5 6 Deco-Mica Ltd 4 Deco Mica Ltd Deco-Mica Ltd Deco Mica Deco-Mica Bharat Textiles & Proofing Industries Ltd. 4 Bharat Textiles & Proofing Industries Ltd Bharat Textiles & Proofing Bharat Textiles & Bharat Textiles Sainik Finance & Industries...

I am having 2 sheets in excel and I am trying to combine the data such that for every record in Sheet1, I get records from Sheet2 based on the common key. Below is the sample data to clarify: I have SHEET 1 and SHEET 2 Data and I want to generate something like SHEET 3. Can you please suggest...

HI I am exporting a 6 digit number from a system into Excel. When this is pasted into excel, this is reformatted as a number instead of being left as a text value. Column A with the code shows what the reformatted number looks like. Column B shows what I want it to look like. AB1CodeOutput...

Dear VBA experts, i have set of words in column A, i need a excel VBA macro to get the meaning for each word in column A on corresponding B column. Please help me with a code. Thanks in advance ! Regards, Karthikha.

I have a requirement where there are set of values in A column of sheet1. These values in column A are mapped to multiple values in sheet2 of A and B column. I need a VBA code where it gives me the unquiet list of mapped items in horizontal manner. So the result must reflect in B2, B3, B4 etc...

Hello again. I need to copy a row of formulas from a specific row (Row 16) down but only if there is data in a specific filed on another tab. To explain a little bit better. Some people fill in data on a specific tab (Tab 2) Other people fill in data on tab 4 My formulas concatinate and/or...

Hello Fantastic Excel SuperUsers: I always like start off with saying thanks for all the help in the past! I have two formulas I would like to combine. =IFERROR(IF(SEARCH("specific text",cell value,1),other cell value I want to copy,cell value) and a INDEX MATCH formula. Caveat would be...