urgent

  1. V

    Urgent Help - VBA Macro_Need Guidance

    Below Macro is giving error message. Need urgent help.. Sub sbUnProtectSheet() ActiveSheet.Unprotect "9999" Set SourceRange = ActiveSheet.Range("B10:H10") Set FillRange = ActiveSheet.Range("B11:H39") SourceRange.AutoFill.FillRange Range("B11").Select ActiveSheet.Protect "9999"...
  2. H

    URGENT Help required Please!

    Hi all, I hope you can provide some urgent help. I was trying to disable the Paste options and used the following code in the Worksheet Private Sub Worksheet_Activate() Application.CutCopyMode = FALSE End Sub Private Sub Worksheet_Deactivate() Application.CutCopyMode = TRUE End Sub This did...
  3. R

    Multiple Embedded SUMPRODUCT Error

    Hello friendly people, I've racked my brain on a formula with no luck. I've read a few other posts focused on COUNTIF and tried to change my results to 1 & 0 by using "--". Still, I get a #VALUE or #N/A error. I would like to make a sum of data in a large array based on multiple criteria. I...
  4. R

    Help in USerform

    Hello Everyone, I am working on a Userform and need your urgent help on the same. Purpose of this userform to open relevant workbook which are attached in workbook as Object. I have to hide that sheet and sheet name is objectsss In userform I made on combo box and gave name - ComFruit...
  5. R

    Help in userform

    Hello Everyone, I am working on a Userform and need your urgent help on the same. Purpose of this userform to open relevant workbook which are attached in workbook as Object In userform i have a drop down by the name of ComFruit under that there are fruits name like Apple1, Apple2 and...
  6. I

    Sumproduct

    Hello ! Actually, I'm facing problem in sumproduct formulae. The file contains three sheets. The sheet “Data” contains the name of the stocks and the respective opening and closing prices. The sheet “Reponses” contains names of the various players of a Mockstock game and the respective...
  7. N

    Need help fast w/ vba!

    Need a macro that will find every cell that contains text within columns A to E all the way down to the bottom. Then paste them in that exact order, but all in column A.
  8. S

    Help needed for transfering data from rows to columns

    Hi, I was wondering can someone help me, i have a sheet with over 100K rows and what i need is to transfer the data from rows to columns, Tried already with index & match but when i drag and drop my excel is not working anymore. Can someone help me to create a macro code for this? On the left...
  9. A

    Automatic Distribution of Items based on Priority Level and Type Set!

    Dear, Need to Automatically distribute Items based on priority level and type set for different People. Find sample below <tbody> <tbody> Type Name Priority Level Distributed Summary Items Type Distributed VIP Mithun 1 4 Rubber Special Mithun Special Jonathan 1 4 Sharpner...
  10. D

    Index+Match/ Vlookup help

    Hi guys, hoping you can help with this. I currently have two tables, main and input/output below. I need a way to pull the "name" field that corresponds to the "main" code in the main table (which is in column D of input/output table). In other words, a formula to give me column E. Any ideas...
  11. S

    Unable to Get VLookup Property for worksheet function class

    Hi All, I am getting "Unable to VLookup property of the Worksheets Function Class" Erro for the below code. Kindly assist I am using this code in a userform Private Sub ListBox1_Click() Dim l As Integer Dim f As Integer EST.TextBox6 = EST.ListBox1 l = Len(EST.TextBox6) f =...
  12. P

    Surpaasing intervals flagging URGENT

    I need help with a certain data column that if it passes the 5000 mark each time. Example : data = 3567 no flag. Same data increases to 5003 it flags. Same data increases 5690 no flag. Same data increases to 10689 it flags. Same data increases to 10700 no flag. Is this possible????
  13. O

    Counting # of times a word appears when associated with name and date range

    Hello I'm looking to count how many times the word "forced release" appears when associated with a certain name within a date range. Name range is in column "A" Date range is in column "B" The Status name is in column "D" The date range i want to set is in column M1 and N1 please help...
  14. L

    Taking the Max Value from a varying range of data

    Hi, i have a data set I.e. a1 50 XX a2 62 XXX a3 6 a4 67 a5 69 a6 68 a7 84 a8 51 using VBA, i am wanting to take the Max value of Range(a1:a4) insert the value into XX then take the next set of 4 cells [Range(a5:a8)] and insert the value into XXX. this sequence needs looping till the end...
  15. D

    Dashboard Needed!

    Hi There, I am looking for a dashboard which can be modified as per the analytical needs and also can be utilized for various types of data sets. Can anyone help in the same. Regards, Darpan Sharma
  16. S

    Urgent question- count number of SKUs without duplicate with 3 conditions

    Hi I have a table with multiple columns and I want to calculate the number of SKUs using their codes without counting the duplicates with the condition of this sku being small griller, regular sku and in june my table looks like this month sku code sku type family 2 jan 1234...
  17. T

    Problem with blank cell in finding top n values

    I want to find the sum of top 3 values from several datas..But if my datasheet is not complete(that means i have less than two datas) and I want to get sum of the two datas..How can I do that?(if I put 0 on the blank cells,it works.But I dont want to put 0,I need to solve it by having the blank...
  18. F

    Remuneration spreadsheet using ranges

    Hi guys, I'm creating a spreadsheet for remuneration and there are three ranges: 0 - 20,000 20, 001 - 40, 000 40, 001 - They each have a percentage attached to them: 0 - 20,000 = 40% 20, 001 - 40, 000 = 45% 40, 001 - = 50% What formula would I input so that when I get a number i.e. 25,000...
  19. M

    Set Y and X axis values

    Hello I'm having a small problem which I just can't solve as I'm a very beginner in Excel VBA. I've been searching for different examples since last week but it doesn't really works. It's quite important for me so I'd really appreciate if someone could help me. I'd like to make a chart from a...
  20. J

    Excel Database Help needed Urgently!

    Hi all, This is my fist post. I am currently doing some work which is with a large database of products and I am stuck! Below is a screenshot of the sheet. How do I go about this problem? Urgent help would be appreciated! Thanks in advance <tbody> Current: abc1;abc2;abc3 random text 1...

Some videos you may like

This Week's Hot Topics

Top