Recent content by Nikhil Patki

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

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

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

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

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.

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

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

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

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

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

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

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