@fluff

Dear All Senior Members I am new member in this thread. I would like to request you guide as vba with Sequence each duplicate value in multi columns (Scripting Dictionary). Example: Col. A Col.B Result: Col. C Col. D aa cc 1...

Hi! I need to calculate "Full Day" or "Half Day" in Sheet 2 at D3. Sheet 1 having data from A3:D504, where A3:A504 having "Date" e.g. 03-03-2024 C3:C504 having "Category" like Lunch, Hi Tea, Dinner, Setup, PMT, AMT etc D3:D504 having "Space" like ATR, ATR1, ATR2, ATR3, DRM etc. Full Day"...

Hello all, I'm having trouble with conditional formatting formulas for the following percent complete versus start and end date situations. I've also included a screenshot to give you a better picture. -On Track (Trigger- Based on the current date, the task will be completed on time by the due...

Gentlemen, I have a table that records for each day, the sales quantities of different products. The record is updated every day. The list will continue to be updated. @Fluff has helped me with a furmula that returns the highest sale quantity (of each of the products) that occurred within the...

Hey everyone ;) So I have a Sheet with a Table - called "TB_Request". This table contain a number of columns, some columns require user input, while other are pulling data from other sheet based on the user input. Initially the sheet, hence the table is protect, however it will have the user...

Hi, Can someone help me with the below requirement. I have a code that is running fine but I want to place a message box in between to give a break to the code to do some manual updates. I am looking for code that pops up with a message asking to do manual updates in workbook and with option...

I want to compare two sheets and highlight the rows in sheet 1 which are not present in sheet 2. For example if row 1 has a, b, c, d, e in sheet 1 and in sheet two check if a, b, c, d, e is present somewhere. If it's present then highlight in first sheet in green. Now comes the hard part. If...

Sheet 1 data changes each day, however I need sheet 2 to record each individual day of the months figures for historical purposes. Simple example provided below, Please let me know if this is clear. Sheet 1 (Figure changes on daily basis) on Nov. 3 = $5.00 Sheet 2 (Monthly View ) Nov. 1 =...

Hi all, first off thank you in advance for reading and considering to help. I am looking for assistance on a copy paste macro to copy data from Sheet2 to Sheet1. the macro must Compare the values of columns C in the 2 sheets and if they are equal: copy/paste the whole row in sheet2 Example...

I need to create a historical view of data based on end of day figures for the month. How can I have my sheet 1 record data for the month by day when pulling data from sheet 1, where sheet 1 updates each day. For example on sheet 1, November 1, 2021 risk amount was $1,000, how can I record...

I'm trying to create a Macro to copy the values from a table T1 of sheet1 and paste them into the bottom of table T2 of sheet2 if the value in cell G (key) of sheet1 does not exist in in cell G of sheet 2. If it exists, just replace the values of cell M of sheet2 by the values of cell M of the...

Hi, Can someone help me with the below requirement. I have data as below in the sheet1 of workbook1. Team RegionEmployee NameCurrent ManagerTS/GS26-Jul27-Jul28-Jul29-Jul30-Jul31-Jul01-Aug02-Aug03-Aug04-Aug05-Aug06-Aug07-Aug08-Aug09-Aug10-Aug11-Aug12-Aug13-AugCXYrYvYnYn XhYnmugYmCHYrXh...

Hello lovely people, With great help from hero member Fluff, I've got a code that adds values entered into a listbox by a user. This code is perfect at putting multiple values into multiple cells. For example, value X, Y, Z go into cells A1, A2 and A3. However, can anyone help me change this...

Hi All I'm trying to return the next 05 April from any given date, with the cell A11 holding the date. I was using this: =IF(MONTH(A11+1)=4,A11+1,DATE(YEAR(A11)+1,4,5)) Which works fine unless the date I'm using is a month less than 4 (eg jan,feb,march,April) as it will then return to me the 5...

Hello All Hopefully one of you awesome excel experts can help... I have to create a userform with Commandbutton to navigate on (Get workbook path) selecting the "Abc" excel workbook, it should copy with all the sheets that are available in "Abc" workbook and paste that in different path as...

Hello Team, Need a Macro where i have workbooks with 5 sheets. with sheets having different column headeres. Similary i have the workbooks with 5 users. currently i have to merge all the 5 workbooks with 5 sheets.

Hi All, I have multiple excel workbook ( 85) in one folder. Each workbook contain 13 sheets has same names with different order. Only Excel workbook name is different. Now I want to assign all workbook sheets in one order. Kindly note Its not assent or dissenting order. I had listed all...

Fluff you provided code to copy the contents of worksheets beyond the Summary worksheet. This works phenomenally however it is bringing in a formula and I was curious if I could just get it to copy the values. The other thread has the same title w/o pt 2