Prashant Gupta

Make Google Sheets enter "London" in column D every time I enter "Diana" in Column C

Return day of the week from date in Excel

Sum cell values below in a column until blank cell is reached in Excel

Extract time from date & time and compare from another time in Excel

Replace text with corresponding pictures in Excel with VBA code

Split text separated by comma into separate columns in Google Sheets

Count number of months between two dates in Excel

Enable Macro in Excel 2010

Remove all numerical values from a range in Excel in one go

Add scroll bar on an Excel worksheet

Extract value separated by comma in Google Docs spreadsheet

Create dynamic Option Button in UserForm in Excel VBA

Find and replace multiple values at once in Excel using VBA

Run a macro if value of a specific cell changes in Excel

Create CheckBox (ActiveX) in Excel VBA

Generate barcodes in Google sheets

Create sound alert in Excel

Generate lottery number in Excel using VBA code

Automatically save & close the workbook using VBA in Excel

Highlight values in one column which are not present in another column in Excel

Shortcut key to display any functions arguments in Excel

Excel: make entry of only valid email address in a cell

Automatically insert a column based on cell value in Excel

Make Excel to search for a specific word or a text string inside a text string

Calculate expiry date in Excel

Replace everything to the right of nth character in Excel

Quickly convert email addresses column in Excel to Outlook email list

Shortcut keys to enter only current date or only current time in Excel

Highlight misspelled word in Excel using VBA macro

Extract email address from text in Excel

Make Excel sheet print on one page

Count frequency of words in a column in Excel using Pivot Table

Add semicolon to each cell in Excel

Use of On Error Resume Next statement in Excel VBA

Check URL validity in Excel

Use Microsoft security essential and prevent spyware and viruses

Auto execute a VBA macro every 1 minute in Excel

Create data entry form in Excel in a blink with shortcut key

Excel: add same text to multiple cells

Apply conditional formatting with comma separated values in same cell in Excel

Extract text after space in Excel

Insert bullet points to a range of cell in Excel

Insert Option Button in UserForm in Excel VBA

Combine two lists into one in Excel using TOCOL function

Import web data to Google docs spreadsheet

Google Sheets: swap rows & columns

Excel: average if a particular range contains specific text

Excel VBA: On Error Goto 0 Vs On Error Goto [Label]

Password protect VBA code in Excel

Convert YYYYMMDD to MM/DD/YYYY in Excel

Change border color of active cell in Excel