Search results

  1. Nikhil Patki

    [Solved] Pivot Table - Update Data / Refresh

    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...
  2. Nikhil Patki

    [Solved] Pivot table - Refresh Data

    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...
  3. Nikhil Patki

    [Answered] Get Data from Password protected PDf - Bank Statement

    You have mentioned a complicated and critical method. Also these statements are originally sent by bank via mail in PDF format itself. 1) how can I re-scan a PDF file itself again 2. i'm not sure whether PDF can be opened in word. also even if it opens first i convert to word then to excel to...
  4. Nikhil Patki

    [Answered] Get Data from Password protected PDf - Bank Statement

    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
  5. Nikhil Patki

    [Answered] Automated Attendance + Salary Sheet

    I have ensured to use simple and basic formula as I work for such tasks at my residence using office 365. Whereas I have to finish my tasks in office on 2013 version. Also the error message is exactly same as mentioned. There are no error code or any other extra description about error.
  6. Nikhil Patki

    [Solved] Excel Table - filter messing

    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...
  7. Nikhil Patki

    Calculating Amounts and avoiding negative result

    Thank you once again, admin. it's really of great help in resolving my issue now I would face pretty few issues in maintaining my data and avoid complex formulas to get the column total of these headers.
  8. Nikhil Patki

    Calculating Amounts and avoiding negative result

    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...
  9. Nikhil Patki

    [Answered] Automated Attendance + Salary Sheet

    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...
  10. Nikhil Patki

    Attendance Sheet - extra column appearing

    the above vba is not working. i've changed the cell range as per actual in my sheet. later i identified that the format you have used in example is different than what I've used. Hence i'll share a attachment so as the vba code can be modified accordingly. or else if i need to change my basic...
  11. Nikhil Patki

    Automated Data Sheet

    I always clean up my spam and junk / trash box. Also all mails from exceldemy are been filtered to a separate folder in my inbox Hence i have not received any response regarding the above query from consulting services. or may be by chance i had misread and deleted it from spam / junk box. This...
  12. Nikhil Patki

    Automated Data Sheet

    I've already posted my requirement in detail to the consultancy services and waiting for the reply past one week.
  13. Nikhil Patki

    Links within the workbook

    actually i have a sheet in which there are almost of dozens of columns regarding employee details. in second sheet i only want to copy specific columns details as well as only active employee names. also in second sheet besides these details there is attendance part being placed. hence i am...
  14. Nikhil Patki

    Calculating KM running and Mileage of vehicle

    it was really great to have your reply and support received. I've learnt pretty much about excel. but not yet applied it in routine work also i'm in capable to use my logic in order to apply the knowledge in various scenarios i just understand the things / working for which examples are...
  15. Nikhil Patki

    Attendance Sheet - extra column appearing

    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...
  16. Nikhil Patki

    Calculating KM running and Mileage of vehicle

    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...
  17. Nikhil Patki

    Links within the workbook

    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.
  18. Nikhil Patki

    Advance Filter using Macro or VBA

    I have one more query. I'm attempting to build a attendance muster This includes multiple sheets - 1. Employee Record which will have all employee list even if someone has left and few are newly added 2. Active Employee which contains only active employees and not have employees who have left...
  19. Nikhil Patki

    Advance Filter using Macro or VBA

    It was really grateful of you. Now it's working totally fine as expected.
  20. Nikhil Patki

    Automated Data Sheet

    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...

Online statistics

Members online
1
Guests online
11
Total visitors
12

Forum statistics

Threads
311
Messages
1,378
Members
568
Latest member
WilliamHon
Top