mrexcel

Hi, I have created a stock inventory sheet for ten product in MrExcel podcast 1505 auto next invoice.I want to reduce stock automatically when generate invoice. Just like auto postregister podcast 1808. Thanks in advance

Forum Members, After the recent forum update, the MrExcel HTML Maker ceased to function as intended due to HTML colors being defined as hex (i.e. #DAEF5 ), which was triggering the hashtag functionality of the boards. I've updated the code to utilize RGB instead (i.e. rgb(218,231,245)) which...

Hi all, In a MASSIVE predicament and any help I can glean would be amaaaaaaazing! I am trying to do a simple SUM formula but with some cells that contain N/A and I REALLY need to find a way of the formula ignoring the N/A values / adding this as 0. I am not doing a simple '=SUM(A1:A10)' I am...

Hi all :smile: In need of help! I have a spreadsheet containing dates in columns (12/09/16 in cell A1, 19/09/16 in cell B1 etc). Underneath each date (which is effectively the column header) I have ten rows of numbers. I need to be able to type a date into a cell on another sheet and have a...

Hi all :smile: In need of help! I have a spreadsheet containing dates in columns (12/09/16 in cell A1, 19/09/16 in cell A2 etc). Underneath each date (which is effectively the column header) I have ten rows of numbers. I need to be able to type a date into a cell on another sheet and have a...

Dears Really i need your help as i want an equation or a code to detect the modification time of a certain cell as a static text

Hi I have been reading a few threads here today about adding cells together every 'nth' row and I am having some success and some failures. I have managed to add up a range of cells (every 6) in a column using this formula =SUMPRODUCT($C$10:$C$154*(MOD(ROW($C$10:$C$154),6)=1)) but it doesn't...

Hellow, I am preparing accounts receivable aging. Its working to extract. Records according to due days but i need formula which less the amounts according to fifo basis. I means if some amount amount i post in credit enerty it nuteralize oldest category rest other remaining same. Need help...

Is there is any method to easily select data from excel drop down list? as an example if drop down box contain 100 selected options and i want to go quickly options started from letter "U" .now i have to scroll down each and every select time. my requirement is very similar to option available...

Hello, Please Guide me On Following. i want to sumifs on second criteria >0<30 ist criteria is text based match which is working. Regards Farhan

i have 2 drop down list (form control combo box) 1st one contains A,B,C i want to set 2nd one selected list based on 1st one selected value.that means if i select A in 1st one i want to set D,E,F in 2nd one and if i Select B in 1st one and i want to set 2nd list G,H,I.how can i do this .please...

I am very new to the macros.I want to know can we develop a macro to download report from online website.based on the names which i can select form drop-down list,i want to download same reports for each name.can i do this using macros. Please help me to do this.

Hi All, There is a problem i am facing with CONCATENATE function. Here is in below table. <colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody> Harry AC DA PC KA Stu DA KA Neena PC...

Hi, Thanks for your videos. I have a question as below. I have a table containing some products. RCCO NK-3325 TRD 633 PL 1 KG NK IN RCCO NK-3325 TRD 633 PL 2 KG NK IN RCCO NK-5251 TRD 633 PL 1 KG NK IN RCCO NK-5251 TRD 633 PL 2 KG NK IN RCCO NK-6302 TRD 633 PL 1 KG NK IN Brand is NK-3325...

Hi, I'm looking to create a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> macro which will be ran from...

I am close on this, but can't quite get it figured out. Thanks for the help! Below is the data that I am working with. In a new cell I want to create a formula that will match the License # in column A with the correct Maintenance in column B and give me the latest date for that particular...