macros and vba

Hi, I've been trying to get this done to analyze the data. However, I am unable to un-pivot this table. Could someone please guide me here? Input table- <tbody> A A A A A B B B B B WEEK MON TUE WED THURS FRI MON TUE WED THURS FRI 1 100 100 100 100 100 100 100 100 100 100 2 150 150 150...

Hi, I have twoexcel documents, "Book1" and "Book2". Book1 is exportedfrom our business system. Book2 is a compilation of forecast from the businesssystem data that were exported. Today Ihave to manually put in the data from Book1 to Book2. I want to put a VBA Codein Book2 to import data from...

Hi guys, Hoping forsome guidance on how I can achieve a log of activity to be automatically generatedwithin a shared workbook. Currently I have a functioning code for a single userbut I don’t think it can work for multiple users looking at the workbook at thesame time. Presently,the below...

hi,pls help. i have a main excel 2016 with a vba code in a button. In sheet param, colum A is date and column B is file name.. After input the date DD-MON-YY e.g "09-Oct-18" and file name can be anything prefix with the "_09-10-2018.xlsx";in that sheet 'Param'.;; I want to use that data...

Hi all, I am wondering if something is possible at all. I have a calendar on Excel (month-by-month) and then another sheet with all the dates of all the different events that are happening. I want to be able to click on a date in the calendar and then below, a list of the events that are...