Search results

Facing issue in updating / refreshing the Pivot Table data when i relocate the file from its original destination of creation. Pop up message arrives stating unable to refresh data, stating the file path ( location ) of pivot table / excel file 1) when the file is opened 2) when i try manually...

I have excel sheet created in my office desktop also created a pivot table using the Data from the file in other sheet of same file. having some extra work i transferred the excel workbook to my home desktop using whatsapp message. but when i finished my work in the workbook I tried to refresh...

it is not asking to input password hence unable to load data in excel from pdf about my bank statement. even using adobe acrobat the file is not getting exported to excel workbook it doesn't show any progress when i select the file and click on export also nor the file is being exported into excel

I am using a table to maintain fuel purchase and consumption data for every month I'm using a few formulas and Excel built-in features to make it simple for data entry as well as results as per requirements. 1. if / subtotal formula to have dynamic / auto serial number generation 2. dependable...

STUDENT NAME Annual Fee Discount Final Fee Book Amt Date 1st Pay Date 2nd Pay Date 1st Instal Amt 1st Instal Bal Aaroh 24000 720 23280 2000 15-02-23 21280 03-04-23 0 0 0 Vedika 26800 1434 25366 2000 20-02-23 5500 03-05-23 0 8455 955 Anvee 22500 22500 2000 17-02-23 7500 27-04-23 0...

I've created Automated Attendance + Salary Workbook on office 365 version. it compromises of 4 sheets in total Sheet 1 - detailed info about employees in table format Sheet 2 - Attendance sheet filtered data of employees in table format including attendance log advance filter macro is recorded...

How to avoid an extra column from appearing for e.g. my have created attendance sheet using 31 days month but when i change month and use either Feb or 30 days month extra column appears and have to be hidden manually. is there any method ( formula ) which will only generate columns as per...

This is the format in which vehicle fuel entries are done How do I calculate following using Excel Formulas 1. Total KM running. 2. Mileage of the vehicle Note: - Number of entries change each month hence each month I've to calculate Mileage and Running manually every month at present. Date...

Why links break which are applied within same workbook when we change the filename or destination What can be done to avoid this kind of link breaks How to make it get auto updated.

Dear Admin, I work in proprietary firm providing school bus service to students of various schools Unfortunately I'm the only person in my firm using System and Ms-Office. Even my Boss isn't tech savvy. He uses only basic features like sending, checking mails, and inputting data in my absence...

On same sheet where we have original ( main ) data i'm trying to extract specific data based on criteria using advance filter feature on same sheet as original data exists but on a different location from main data. when i try to refresh it changing the criteria, macro only refresh the one...