Search results

Thanks Pavan. Last thing it there a possibility to reset macro ? File which i have attached Magic! I require a reset button which will reset it to its default look and position are running it. Is it possible ? Thanks again in advance Pavan. Regards, Maunish Patel

Pavan you are Genius !!!!! This is what i want :-) Now only question is if I look at formula from column D to Y, Match says = Dismissal COAF, do I need to replace this with all different sheet name ? Will data still be selected from each different sheets. Yes currently it is showing. But if i...

Hi Luke, As decrisbed in my first post that i have created a macro : here it goes : to check how does it work : Open Queue File - Copy Cltrl + A data from DISCH COAF and paste it in Magic! file and press Cltrl + J and see output in Vlookup : Will this help some thing for my request ...

These are list of people only working for this dedicated task daily : Aakash Patel Amit Bhatiya Baljindersingh Kang Dharmesh Purohit Hardik Shah Hardika Patel Monica Singh Naeem Patel Puneet Sharma Purvesh Parmar Rakesh Joshi Uwais Pathan Vishrut Thakar Wasim Ansari Yogeshkumar Sindha Rizwan...

Hi Luke, This is how dashboard is going to look like, all values from different sheet in single worksheet. Also i found a great article on this forum, where someone genuis like you helped someone for such thing using Index & offset formalu. Could you help to replica same here ?

Hi Luke, But suppose if i have fixed 20 team members, will it be possible to use Index or Offset formula? If yes, than how :-)

Hi Serena, Few questions : 1) Do you want to compile all data from different workbook to one ? ---> If yes, than do you want to paste data on a blank cell after active cell ? 2) Do you want to compile data from different folders to one ? Regards, Maunish Patel

Hi Thomas, Small edition done to your vlookup : Instead of =VLOOKUP($AA$10,$A:$L,AB$5,0) $ which is placed before cell number 10, I removed it and it worked. Please check and let me know. Regards, Maunish Patel

Hi Karthik, Do you want compile all data into Consolidated sheet? If filtering by than what do you want to filter and compile data ? Regards, Maunish Patel

Hi Ria, If you want to use formula in cells, then try below given formual. Insert this formula in cells where you want output as " 0 " = IFERROR(A1,"0") Regards Maunish Patel

Hi Team, Initally data which i use to get was in single worksheet, where i had created marco which will umerge all cell names, transpose to different worksheet from horizontal to vertical. But now, as new work increased I have now only 1 workbook with 12 worksheet and different team members...

Thank you Hui

Hi Team, Have a data which looks very simple while reading on excel, however cant think much more to put ideas on out on chart or some out of the box data visualization. Would like to have a chart which shows me trend, forecast variance, shows good week bad week, and much more statistical...

Hi Deepak, Thanks for differenet options however when used code 2. Data is getting overlapped where i dont want to have overlapped data, it should copy all information from each workbook and paste after the blank row. Above pasted code by me, copies all data available in sheet one and paste new...

Hi Team, I already have a code which is able to consolidate multiple workbooks into one sheet, however it only copies data from 1st worksheet, but i want to copy all data from worksheet 2. Naming structure for each workbooks for worksheet 2 will not be same. Please help where i can...

Hi Team, I have couple of websites which i need to scrub data from html format to excel format. Below given are steps which i perform daily : 1) Open Website : http://registers.maryland.gov/main/search1.html 2) Select County from the drop down 3) Select date range for last 3 months 4) Search...

Hi Deepak, I was succesfully able to open and use it. Thanks Hossam for asking question and thanks deepak for creating. But still i have few questions. Would it be possible to know login and logout time also? Also can different workbooks datarecord be opened by admin in single file ? Can...

Hi Hiu, Did you got a chance to review request?

Hi Hui, Attached image will help you describe more easier and also have attached updated file. 1) Select specific work activity from drop down. Based on work activity down, only aligned activity in Listing Column D should be reflected. 2) After selecting proper work activity, neccessary...

Hi Team, I have 2 worksheet sheet, TrackTime & Listing. In TrackTime if any team member selects any listing from Column E, he should only get option which are categories in Worksheet Listing in from Column E & F. How to use Offset formula. I have attached sheet. Regards, Maunish Patel

Hi Smallman, what if i want to copy data from Column A1 to P9784. How this macro will work? Regards, Maunish Patel

Hi Luke, Could you please help to solve this. Thanks in advance

Hi Luke, however rest columns are also locked i cannot write to edit them. Please find attached. I want only column K & L to be locked once data is inserted

Thanks Luke U are THE GREAT THE GENIUS

Hi Team, I have a VBA code which allows me to double click and insert timestamp in Column K & L, however every time I insert data in K1&L1, it should get locked and no one should be able to edit data. However if i move to next row then I can enter data in K2&L2 and follow same process Lock -->...