Excel Forum
-
About dated if function Closed
Hey again, i had to use this formula to find the deference between two dates =DATEDIF(E4,F4,"d")+(1) it shows me (1) in all the empty cells...
-
compare values in multiple columns in excel Closed
Hello, i have multiple columns with numerical values and I need to determine which one is the smallest value by row is there a function that can he...
-
Excel Macro to list current costs by code and extract previous Closed
Hello, I am looking for a macro, that will list one set of values by a code and then move a precious list of codes with values and subtract one from t...
-
macro gives me expected en sub error Closed
Hello, I have the below macro, but it gives me compile error expected end sub. This macro below I have copied and paste hoping it would work becau...
-
excel-create a compounding interest calculater Solved/Closed
I want to work out the after three months dates between two dates ex: 01/03/2013 as the starting date and today date as the last date.
-
data arrangement problem (very difficult) Closed
I have a lot of data A1:CET100 This is the initial set of values that I have A1 B1 C1 ... CET1 A2 B2 C2 ... CET2 . ...
-
Type name into a cell removing name from another unique list Closed
Is there a way to manually type a name into a cell on one worksheet, that removes that name/entry from another large list, with unique names, whether ...
-
Merge the selected sheets data into one data Closed
I am having 5 sheets (Name as Ricky, Rambo, Input, Output, Time) data combined into combined sheet , for this i need to run through macro Please hel...
-
Comparing values in multiple columns Closed
Hi All, Would appreciate if you people can help me, as am not that excel expert :( My argument is like this- Column: 1. 2. 3...
-
Use of Max and Min functions. Closed
hello there ,, I have two column names & numbers in different cells i need the highest number to display with the name next to it same with the...
-
Delete name from Sheet1 as I type same name in cell of Sheet2 Closed
I have a list of 10,000 unique people with corresponding statistics on a worksheet. These are also included on additional worksheets into smaller subc...
-
Automatically calculate random number as invoice number Closed
Hello there! I am fairly new to macros and am trying to create an excel document that automatically insert a new randomly generated number (as the ...
-
to start the sumif from partial text on first row of the day Closed
Hi, I have formula IF(COUNTIF(A$2:A1747,A1747)=1,SUMIF($A$2:$A$10000,$A1747,$G$2:$G10000),"")), which sums daily figures only for agencies by days....
-
Autofill Destination Closed
I created a macro to add a column and then to make the number in the column to the left of that column a negative number. I do that in the first cell...
-
Duplicate rows based on cell value Solved/Closed
Hi, Can somebody help me out with this. I want to duplicate rows based on input in a cell. can it be done in VB or macro or formula array? User wi...
-
Macro/VBA find match but copy/paste to the wrong place Closed
I found the VBA below to find the matches, unfortunately, it copied to the wrong place. Instead I need those matched codes, copy its corresponding va...
-
macro recorded to copy and paste only values Closed
Hi, This is the first time I use this site and hopefully will get some help with this. Basically, I have a basic workbook which is populated everyd...
-
chosen Text in dropdown adds number in cell Closed
Hello, I have a problem with my formula, If i choose a product "text" in a dropdown menu in cell C2, i want it to display a serial number in C...
-
Macro for new workbook from "database spreadsheet" Closed
Hi all, Have been looking around the forums for some help, and there's been some really useful code but am struggling to put it all together to ach...
-
excel payroll work Solved/Closed
Hello, I'm using Excel to do payroll system. e.g. I create worksheet that showing data as below table :- basic more than 0.01 less tha...
-
need help in date conversion Closed
Please help me with a formula to convert ' 17/08/2013 02:06:02 PM' to ' 08/17/2013' in XLSX . Thank you.
-
Move Data from one workbook to another Closed
Hi I would like to move data from one workbook to another (copy & paste basically but there's tons of lines). The second workbook is in a differen...
-
take out the ceros of specific cells, not the whole worksheet Closed
how could I make the 0 ceros of an empty cell not to appear? I've tried going into customs and entering £#.##.00, which I got from somewhere though do...
-
Excel formular Solved/Closed
Hello Sir, Can you let me know the formula in Excel: I have a table as below: 1 A B ...
-
excel equation Closed
i want to formulate for eg:- inv date pymt terms amount payment due date jan feb mar apr 01.01.2014 30 1000 31.0...
-
excel greater or less than Solved/Closed
Hi all, I'm having a problem that with multi counting with less than, eg. case 1: A1 = 1000 (total revenue) B1 = 3% (rebate) C1 = 2000 (free ...
-
Create worksheet based on lists & populate data from another... Solved/Closed
Hello, I've been recently working on trying to create a fairly large excel workbook & trying to automatically populate sheets inside of it. I h...
-
Highlight cells based on a specific day of the month Closed
Hi there. I have a bill spread sheet that is layed out pretty simple. I basically have all of my bills listed in the order they are due each month. Th...
-
conditional formatting Solved/Closed
hello I did a table in Excel ( its a vacation tracker) I'll give you an example for what i'm trying to do Ex : my vacation starts from 15-mar ...
-
Attendance sheet Closed
Hi, I'm getting Confused and just need someone to help. I know I am looking for something simple but can't figure it out, i got some manhour she...
-
Search column B for matching value from a row in column A .... Solved/Closed
Search column B for matching value from a row in column A and populate D with the value that is in the matching row of B that was in column C, ie XYZ ...
-
Automatic transfer- with just one word Closed
I just started a new job and my boss asked me to see if I could have the clients information automatically sent from the master page over to the overd...
-
excel protect a column and a cell Closed
Hello, how can i proctect excel column and cell Configuration: Windows 7 / Firefox 23.0
-
Compare Column A to Column B and return Column C Solved/Closed
Hello, I have spreadsheet with names in Column A, phone numbers in Column B. Column C has the same names in different order. How can I ha...
-
Monthly Spreadsheet for Equipment Hours- I'm stuck! Closed
Daily log for equipment hours I want to make a file with 31 days of worksheets in the workbook for the complete month. The order of the workshee...
-
convert datagrid data to raw data Closed
Hello, i've a excel grid with data in rows and coluns with values in each pair (row/column). i need to transform each combination in raw data to p...
-
how to implement this formula in excel Closed
The formula is x= [(A-B)-(C-D)/log((A-B)/(C-D))] It is a iteration where value of A,B,C are taken from excel cells the value of D=1 to 200 ...
-
Copying data from one sheet to another conditionally Solved/Closed
Hi gang, I have a spreadsheet with columns A thru H being populated with text. I need to copy columns A thru H from spreadsheet 1 to spreadsheet 2 i...
-
Excel Macro to List one set of values and subtract another Closed
I am looking for a macro, that will list one set of values by a code and then move a precious list of codes with values and subtract one from the oth...
-
highlight row on one sheet if a number matches on another sheet Solved/Closed
Hello, I have a spreadsheet with multiple tabs. I am trying to figure out how to get a row to highlight on the tab called "Directory" if a number in ...
-
A macro to create new spreadsheet and copy data Closed
Hello, In the example below, I want to copy all the date from all the worksheets present in excel. In addition to my requirement to edit value of ...
-
How to define specific format for number? Solved/Closed
Hi, I would like to define specific format in excel. For example, if I type 123456789 and hit Enter, it should be 123-456-789 or 123-45-6789 autom...
-
Macro won't paste in second sheet "Run-time error:9" Out ofRange Closed
I am trying to copy from sheet 1 and paste in sheet 2. Checking row "G" for the letter "x", the "x" marks the rows I would like to copy from sheet1...
-
If statement using date to change row colour Solved/Closed
I have a sheet with the following header row: Reference Client MAWB / BoL Date logged Date completed Days to resolve Logged by Caller type Error ar...
-
Excel 2010-VB Macro formula into many spreadsheets Solved/Closed
Hello Everyone, I am new in VB programming and I am trying to write a macro in Excel. Basically, I have written a formula in Excel which enable me ...
-
automate the sheet in order to calculate costs Closed
I have an order sheet and 3 reference sheets. I would like to automate the sheet in order to calculate costs and for selling different types of produ...
-
IF function using dates Solved/Closed
Hi I am trying to write an IF function for an escalation calculation and need some help please. What I want to achieve is to have a date filled ...
-
IF function using Dates Closed
Hi I am trying to write an IF function for an escalation calculation. What I want is to have a date filled into cell B13 (22 February 2014). The I...
-
Data comparison Closed
I have a database compiled in my office of current students in a college program for a particular semester AND a database from administration with the...
-
Macro Syntax Error Closed
HELLO THERE NEED HELP TO RESOLVE AND MAKE THE BELOW CODE WORK IN EXCEL(MACRO) ActiveCell.FormulaR1C1 = _ "=IF(RC[-2]=""10X"",""Acquisition on do...