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