@fluff

  1. A

    Multiple Criteria in If function Returns error

    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"...
  2. B

    Formulas 1) to return the date of the first occurrence of the highest value; and 2) to count the number of occurrences

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

    On Save Lock Entire Row in a Table

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

    VBA to pop up a box and run the code accordingly

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

    Vba comparing two sheets

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

    ***PLEASE HELP : ) *** I need to create a snap shot of daily data from sheet 1 to create a monthly table on sheet 2****

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

    Copy/Paste Macro from Sheet2 to Sheet1 based on on another column values

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

    Historically record data set on workbook 2 pulling data from workbook 1, where workbook 1 data changes each day

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

    Copy values to new sheet if "Key" does not exist with VBA

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

    VBA Code to Search and produce results based on the criteria

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

    Listbox userform, multiple values into same cell.

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

    Next 5 April from any given date in Excel

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

    Copy the Workbook from userform i.e, load the workbook path and copy the output workbook path

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

    Macro to Merge the works with sheets

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

    How to Sort Excel Sheets from Multiple Excel files in one folder

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

    Excluding Worksheets from a Workbook Copy pt 2

    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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top