fluff

  1. W

    VBA code to table the data based on Weekending-date and names

    Can someone help me with a VBA code for below requirement please. I have a data in Source sheet that has weekending date, Sales Amount, Senior Manage and Manager as below. let us say the below data is in source sheet of the current workbook. Source sheet have data from previous week also. I...
  2. W

    VBA code to split the data as per requirement based on key words

    Hi, Can someone help we with a code for below scenario. I have data in A column and need to split it to B, C, D Columns. below is possible formats of data. 1. If it contains data with "AB" then it has to pull the 8 digit alpha numeric (8 numbers + 5 alphabets) ID and paste it in B column cell...
  3. pmeghnathi

    Automatically Moving from Cell to Cell when Entering Data

    A1 cell value 12345678 (8 any character number) to auto move a2.than a2 any value ENTER hit key enter to move a2 cell continue this one by one 2 column Move cursor
  4. W

    VBA Code to loop through Array and with criteria

    I have below code where we arrived at the list based on criteria and I have assigned it to an array called arr1. Now I am looking to apply a filter in "K" colum to select "Yes" alone loop through this array of items which are in "I" column and get the total sum from R column. I am fine if array...
  5. U

    Edit every worksheet in a workbook

    Hi Guys, I am trying to run a piece of code in all the sheets in a workbook. However my code is only editing first sheet and then courses through other sheets but does not edit them. PFB the code: Sub Worksheet_Editor() For Each Worksheet In ThisWorkbook.Sheets Cells.Select...
  6. U

    Delete and highlight

    Guys I am trying to clean all excels present in a folder and highlight required data in all excels. Using following code for cleaning excels Sub Looper() Dim wb As Workbook Dim myPath As String Dim myFile As String Dim myExtension As String Dim FldrPicker As FileDialog 'Optimize Macro Speed...
  7. Y

    Excel Code to Hide VBA rows based on Criteria

    Hey i have this code that i use to sort my worksheet however i want to include a special provision where if the text in the Range of column "C" equals "TOTAL" do not hide the empty row under it. For example i want the worksheet to have a row separating my tables after the, text TOTAL. Right...
  8. R

    Delay VBA before running

    Hi all I am using this code (Courtesy of Fluff) Private Sub Worksheet_Activate() Range("A:A").AutoFilter 1, "<>0" End Sub The issue that I'm having is that when I open the sheet with this code, it runs before the sheet is calculated. The reason for that is that I have calculation set to...
  9. T

    incrementing and checking till getting value less than specified.

    hi, i am new to VBA. how increment using VBA can be done to find minimum requirement for Length(L) and width(B) of foundation so that Modified bearing pressure(PMOD) is less than allowable bearing pressure(ABP). Attached sample calculation for visualisation and better understanding. Regards...
  10. P

    Highlighting cells and arrays

    Ok, so I would like to edit the following: If ActiveSheet.Name = "Example 1" Then Worksheets("Example 2").Activate Else End If With CreateObject("scripting.dictionary") For i = 1 To UBound(Ary) .Item(Ary(i, 1)) = Ary(i, 2) Next i For Each Cl In...
  11. P

    ActiveSheets.Range("").Copy Method

    Ok, so I am working on a macro seen below: Sub Data_Parse() Dim ER As Long ER = ThisWorkbook.ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row Dim Cell As Range Dim CriteriaRange As Range Set CriteriaRange =...
  12. M

    Related drop down list, Dictionary Keys for 3 columns

    Hello My Masters & Colleagues, I have 3 columns of data in sheet2 (A) for Branches (B) for Departments and (C) for Names A2:c5000 like the table below the 3 lists are related and has some duplicates and blanks. And I have 3 Columns lets say J,K,L in sheet1 I want to J2:J each cell is validation...
  13. M

    Open com addin window in a userform!!!

    I have excel Com Add-in it's name Mapcite for maps I want to open it in a frame inside userform. how can I do that I tried many ways but unfortunately all failed. I afraid this is cannot happened and I just lose time Thank you Excel Masters and my colleagues, for always support.
  14. S

    help. need a formula

    i have a spreadsheet with many rows that i need sorted. it looks something like what's below... (there are ~2500 companies in total) A <tbody> Company A Name Address City, State, Zip Phone Fax Email Fluff Fluff Fluff...
  15. S

    Two different formulas for two different conditions- Urgency High

    Hello Guys, Hope you are doing well today, Can you please assist me in providing the two different functions for each of the below two scenarios Formula required for the below condition for first excel sheet: If B7 = Receipt Amount E7 = Claim Amount · Claim amount = If Receipt...
  16. S

    Filter,. Create a new file along with the pivot

    Hello, Need your help to create a macro on the below query please. In sheet 1, data is there from column A to U for multiple companies. In sheet 2 there is a pivot table based on company-wise. So this is a consolidated file. Now, what we want here is a separate file for each company...

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