#excelquestion

how to generate Next invoice number After search table1 in excel ? Dear Sir, pleased Solve My Query We need formula For increase invoice number......

I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code.... i was Create MODULE and put this VBA code , So Amazing Trick to ,make Print TO PDF with Duplex (Both-side),,,,, Kindly Provide set VBA code For both page Margin...

( i was try to making Auto filter data) "When I paste data into a table, the data should be sorted by invoice number, pleased Share to right way vba to possible Tricks"

All Question And Answer to save in "Sheet1) We Need Reference "Question" Sheet1 to Sheet 2 , Also need four Option reference data from Sheet 1 According Question Kindly make solution this query

How to Filter Both Pivot-table Data According After Select Drop-Downlist. "i Try select party name on drop-downlist , After filter both pivotable data on working with drop-downlist (WE NEED MULTIPLE PIVOTABLE AFTER SELECT DROP-DOWNLIST

Between two Slashs "/" Or Two and more Slashs how to work formula in this condition

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...

How to Match workbook to other workbook data & Get status (HOW To MATCH "BOOK2" WITH "BOOK1" , All data Match , to Get Status and Highlight 4 CELL matching How it possible ???

(NEED THIS CONDITION) C2= "20 ft" use 5,00,000 C2= "40 ft" use 10,00,000 Change value According "20 ft" Or "40 ft " ------------------------------Kindly Suggest Right Formula-----------------

* how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.

In cell C11, enter a formula to reference the date stored in cell B7. Insert a nested function in cell C12 to calculate the date for the next payment. Nest the YEAR, MONTH, and DAY functions within the DATE function. Add 1 to the month result. Copy the function to the range C13:C34. I need help...

Hi all, Currently I have an excel tracking file to keep track of the trainers’ availability for a list of scheduled programmes for the entire year. Based on their availability, I have to go through each programme one by one to match and see who to deploy. Typically for each programme I will need...