I get these catering summaries monthly, but each month the summaries' sheets are scrambled:
Figures (total number) of meals provided.
I do the job as the following...
I am returning back to VBA after a very long break and have managed to forgotten the code to run a macro that adds serial numbers on the left hand side of a blank column from start of the data up to the last row based on a column with last row data which can vary in legth
I have tried everything out there from google search to youtube videos but cannot find anything to help me get to the below example. Does anyone have a formula that would work?
The top set is based on the date and time in column b.
The bottoms set is based on the date in column b and the time in...
I've always been a big fan of Mr. Excel's YouTube videos and thought I'd participate in the forum as well. My first post is in relation to the project I am working on. I am hoping somebody could help me out. Been searching for hours on the web and stumbled upon some possible...
I am trying to have a serial number logic, as below:-
Column 1 is Sr. No., Column 2 is Code Number.
Now, I am need that Sr. no. should ignore while dragging, if...
I am having trouble coming up with a VBA code to find a part number I am searching for and then finding the highest (or last row) serial number, adding 1 to that number and creating a new line item.
Pan Head Screw
I have a list of student needs (comma separated) in one column, with the rank of those needs (also comma separated) in another column, but the problem is, the rank is not always in a logical numerical order:
I need to create a serial number that auto increments based upon the following format:
Last two digits of the year + Julian day of the year + two digit unique incremented number.
1610604 would be 2016 on the 106th day and the 4th unit and the next number would be 1610605.
I do not...
I've been searching for a few days for the solution to my problem, but nothing fits the bill.
Imagine a system for recording Invoices. The invoice number cannot be re-used, and must not change after it has been entered (or rather, looked up from a counter). Is there any way to...
I have data below mentioned detail
I currently have a great macro that, when a "generate" button is pressed, it puts out a serial number in the format of YYMMXXXX (where XXXX begins from 0001) and populates the next available row with this number. However we now need it to reset the last four digits to go back to 0001 every...
I want to track an individual across a number of years. I have their name eg: Smith, John and I want to track this across different years databases and find how this person's qualifications changed across years. I was thinking of assigning a serial number to an individual but need...
I am a novice in excel (2010). I own a t-shirt brand, when I put together a print run with multiple designs, that have multiple colored shirts per design (as shown in my screenshot). I need to then total up the number of: SMALL BLACK-T, MEDIUM BLACK-T, SMALL BLUE-T, ETC from all designs...
I am attempting to find a code that will grab the serial number of the pc and insert into cell A1. I have found the below code and it works, but it requires you to enter the name of the computer you need serial from, then displays serial in message box. I just want it to...
I need a formula that if i drag it down it gives me serial number with alphabets. Like if i paste that formula in cell A1 it give me serial number AAA 0000 and when i drag it down it give me AAA 0001. When serial number reaches AAA 9999 it automatically give me AAB 0000 and it goes on like...
Hi guys. I have a scanner that scans stock barcodes and serial numbers into a memory chip on the scanner.I then dock the scanner and download the info into excel.
I need to sort the data into 2 columns based on cell contents.
If I scan an item without a serial number, I just want it to...
I need to convert a date into a serial number. The serial number must return the format DDDYYNN where DDD is the day of the year, YY is the year, and NN is the sequential build number. As an example, if 10 units are built on 2/6/2013, the serial numbers would be 0371301, 0371302 ...0371310. Cell...
I have an excel file to keep track of inventory.
1st tab is an overview of the quantity available for each item. column A "Product Code", column B "Description", column C "Qty on 12/1/12", column D "Qty In", Column E "Qty Out", Column F "Total on Hand".
2nd tab in the tab where I insert...