help is needed

  1. Q

    Excel newbie trying to do something moderately complicated (analysis of staff data over time)

    I guys so I am a bit of an excel newbie and need some help getting my head around the best way to create an excel sheet for the data that I have. I have a CS background and have done DB subjects as part of my course work however creating an SQL database isn't an option in this case. The data I...
  2. J

    Multiple Loan Calculations with Interest Only and different Start Dates

    Hi Guys, Looking to get this solved. Trying for hours to fix it, but not really sure how. Task: Trying to calculate a loan amortization schedule with multiple loans, which also include a interest only (IO) period. I also want to have the option to set multiple start dates for the different...
  3. L

    Vacation accrual formula

    I have been tasked with developing a spreadsheet to track employee vacation accrual. Employees begin accruing andare able to use vacation days once they have been with the company 90 days from their start date. After the calendar year of your hire date has been completed, your vacation...
  4. P

    Finding the minimum value that is not zero for each sub-set of data

    Hi - I have a data set that is sorted by Member ID and each Member ID can have multiple transactions. In my desired outcome I only want the non-zero minimum value displayed for the group next to the corresponding transaction in each subset of Member ID's. See example below: <tbody> Unique ID...
  5. P

    Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached.

    Hi - I'm trying to build an output model similar to the one shown below, please see the following explanations to help answer: Main Issues: (I) When a unique ID has multiple transaction with a selected product code input before meeting the selected threshold amount. (II) Once threshold is met...
  6. B

    VBA to loop through a data input tab to populate contracts

    Hello everyone. I wanted to see if anyone could create some VBA or suggest a better way of doing process that we are currently doing manually. An example file is saved to the Dropbox link below. We hire temporary labor for different events and our departments submit a temporary hire...
  7. S

    Excel 2013 repairing macro enabled file HELP

    Hi, I hope someone can help. I have a macro enable sheet which allows me to tick off order numbers as i go. Each number highlights green with red text so that i can see visually alongside the tick which numbers have been used. This was working fine on Excel 2007, but i started having massive...
  8. F

    Trying to scrape emails with VBA

    Hello Ladies & Gents, I am trying to scrape specific emails, but when I look at the source code & when I use my scraper, there seems to be 15 different emails for one email. for i.e. the email is hiding in in a with 15 tags --- and only one contains the email A better example... I am...
  9. N

    Filtering out exact acronyms

    Hi all, I have a (probably pretty stupid question) I work a lot with cleaning internal databases . I often have to filter out to particular job titles and one I always have a problem with is "IT" so that would be say and IT manager, a HEad of IT, an IT analyst etc etc etc (endless number of...
  10. smide

    VBA to extract only part of text from a cells (parse raw output)

    Hello. I need some assistance with an excel spreadsheet which contains very raw output report in row 1 (Sheet2) columns (A-NO). I'm not very proficient with excel-vba but I'm open to suggestions and willing to learn to get this to work properly. As I already stated in row1 in Sheet2 I have a...
  11. smide

    Need help to improve my VBA code

    Hello. I'm using the following code to parse my raw report from row1-Sheet5 and transfer data to Sheet4, creating this table: <tbody> O P Q R 1 2 id shop store factory 3 3456 23 15 25 4 3467 12 16 28 5 3468 24 19 33 6 .... .... .... .... </tbody> Data in row1-Sheet5 are...
  12. U

    Need help deciphering VBA code

    Hi, Can someone please take a look at the code below? I keep getting an error when trying to run the code. The code was given to me by a co worker whom is no longer around. I need help because I'm too amateur with VBA and need some pro tip. Thanks! About the code: It's suppose to copy specific...
  13. D

    Multiple checkboxes used to hide/inhide various columns

    I am new to macros and VBA, so please type slowly. I am trying to use a checkbox (true/false) as a trigger element to call one of two Macros (Hide and Unhide a column). When false, I want the column hidden. When true, I want the column unhidden. I will need a total of 9 checkboxes and columns...
  14. S

    Need VBA help with variable quantity mail merge lables

    Hello, I have a large inventory list I've created in excel. I need a macro to create X number of labels from data in the table. It has 13 columns and a running number of rows. I've been looking around for a few months now but haven't found anything that works for me. Is this even possible? does...
  15. S

    Copying Data From Closed Workbook Using Input Box to Search For Criteria

    Hello relatively new to using VBA & Macro's , i am trying to setup a macro that will prompt the user via input box to type a client name in , it will then search the closed workbook(Quick Test.xlsm)"Sheet 2" (Companies) for the client name and once found pull the entire row of data through to...
  16. S

    VBA Code for Saving

    I'm currently creating a macro to take a .txt file and applying some formula onto it to create a graph that I need. I now want to add in a code to save that new excel file with the graph to my desktop but I want the option to save it as a different name so it will not write over my .txt file...
  17. S

    Macro Code Assistance needed

    So I'm recording a macro to display an XY scatter plot graph. I have had to add a second data series to get the x-axis I need but when opening other .txt files this line of code fails as it has the name of the original .txt file used to create the macro. The problem line(s) of code are shown...
  18. J

    Conditional Formatting

    Is it possible to us conditional formatting to tell excel "if a cell in range A1:A10=number then format the cell next to it in column B if that number is not a number 1-10?" For example: A1= 10 A2= 1 A3= 9 A4=5 A5=6 A6=4 A7=7 A8=3 A9=8 A10=2 B1= 1 B2= 15 B3= 2 B4= 3 B5= 4...
  19. S

    Return the correct result

    Hello, I am using excel 2003 and have the below sample data (from a main excel sheet with 1000's of rows). <colgroup><col span="4"><col><col></colgroup><tbody> A B C D E F ID Owner Region Action Date Timestamp 1001 Shawn APR Closed 12/01/2015 12:52:06am 1001 Shawn APR opened...
  20. M

    runtime error 1004 paste method of worksheet class failed

    Hi All! I keep receiving an error when copying data over: "runtime error 1004 paste method worksheet class failed" at ActiveSheet.Range Sheets("Macro").Select Cells.Select Range("A1").Select ActiveSheet.Range Columns("D:D").Select Selection.Insert Shift:=xlToRight...

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