Blogs

Nick's picture

Nick's Day By Day Excel Experts Blog

Need macro to remove item and reset back to zero

I need help creating a macro that will remove a stock item from one tab and reset to zero so the macro can be run multiple times. The crux I am facing is being able to use this as a counter but in a negative sense. On the 'PRODUCTION'tab, I need to have the capability of removing stock item "TANK SIDE" from 'DS TANK' tab when a serial number is entered on the 'PRODUCTION' tab. The 'DS TANK' and 'PS TANK' tabs our inventory tabs and need the ability to add and subtract parts as they are produced and taken for assembly. I have attached a file for your perusal.

Adding value (5,2,1 year) to a cell value based on another cell value (DOB)

Hello All,
I have multiple excell worksheets with list of columns. Column C is Birth Year,column D is date of Approved, I want in Column C to calculate based on this criteria:

If Column C is <35 years add 5 years to Column D
If Column C is 35-45 years add 2 years to Column D
If Column C is >45 years add 1 years to Column D.
Please See my attached file!!
I used IF funciton but the outcome is not what i want
My formula:
=IF(TODAY()-C2>45,DATE(YEAR(K5)+1,MONTH(D2)+0,DAY(D2)+0),IF(TODAY()-C2<35,DATE(YEAR(D2)+5,MONTH(D2)+0,DAY(D2)+0))).

Nick's picture

XLA routines: EE_PivotRemoveTotals

EE_PivotRemoveTotals is a simple routine that removes the totals from a pivot
Sub EE_PivotRemoveTotals(Optional pt As PivotTable)
'http://excelexperts.com/xla-routines-eePivotRemoveTotals  for updates on this routine
    If pt Is Nothing Then
        If ActiveSheet.PivotTables.Count = 0 Then Exit Sub
        Set pt = ActiveSheet.PivotTables(1)
    End If
 
    pt.RowGrand = False
    pt.ColumnGrand = False
End Sub

VBA to paste Excel Range into Powerpoint (it should not be a picture and excel linked table)

Hello,
I would need a help to copy an excel range as editable table in a powerpoint. When i tried, It was pasted as a picture or as a excel linked table which were annoying.

and i would need to paste it as an editable one (similar to a powerpoint table). please post your reply soon.

Thanks,
Vinod.

Nick's picture

XLA routines: EE_SortCols

EE_SortCols sorts columns by a predefined range of headers...
Nick's picture

VBA Developer Jobs in the UK

Live VBA Developer Jobs in the UK

{"what":" VBA developer","where":"","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Developer Jobs in the UK

Live Excel Developer Jobs in the UK

{"what":" excel developer","where":"","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel VBA Jobs in the UK

Excel VBA Jobs in the UK

{"what":" excel vba","where":"","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel VBA Jobs in the UK

Nick's picture

Excel Jobs in Cardiff

Live Excel Jobs in Cardiff

{"what":"Excel","where":"Cardiff","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Dundee

Live Excel Jobs in Dundee

{"what":"Excel","where":"Dundee","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Perth

Live Excel Jobs in Perth 

{"what":"Excel","where":"Perth ","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Inverness

Live Excel Jobs in Inverness

{"what":"Excel","where":"Inverness","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Aberdeen

Live Excel Jobs in Aberdeen

{"what":"Excel","where":"Aberdeen","results_per_page":"20","country":"gb","widget":"job-feed"}

Nick's picture

Excel Jobs in Edinburgh

Live Excel Jobs in Edinburgh

{"what":"Excel","where":"Edinburgh","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Glasgow

Live Excel Jobs in Glasgow

{"what":"Excel","where":"Glasgow","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Belfast

Live Excel Jobs in Belfast

{"what":"Excel","where":"Belfast","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Leeds

Live Excel Jobs in Leeds

{"what":"Excel","where":"Leeds","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Bristol

Live Excel Jobs in Bristol

{"what":"Excel","where":"Bristol","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Birmingham

Live Excel Jobs in Birmingham

{"what":"Excel","where":"Birmingham","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Liverpool

Live Excel Jobs in Liverpool

{"what":"Excel","where":"Liverpool","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in Manchester

Live Excel Jobs in Manchester

{"what":"Excel","where":"Manchester","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

Excel Jobs in London

Live Excel Jobs in London

{"what":"Excel","where":"London","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Cardiff

Live VBA Jobs in Cardiff

{"what":"vba","where":"Cardiff","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Dundee

Live VBA Jobs in Dundee

{"what":"vba","where":"Dundee","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Perth

Live VBA Jobs in Perth 

{"what":"vba","where":"Perth ","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Inverness

Live VBA Jobs in Inverness

{"what":"vba","where":"Inverness","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Aberdeen

Live VBA Jobs in Aberdeen

{"what":"vba","where":"Aberdeen","results_per_page":"20","country":"gb","widget":"job-feed"}
Nick's picture

VBA Jobs in Edinburgh

Live VBA Jobs in Edinburgh

{"what":"vba","where":"Edinburgh","results_per_page":"20","country":"gb","widget":"job-feed"}
Syndicate content