The discussions
Automatically calculate random number as invoice number
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
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
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
SolvedHi, 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 recorded to copy and paste only values
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
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...
Excel payroll work
SolvedHello, 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
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
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
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
SolvedHello Sir, Can you let me know the formula in Excel: I have a table as below: 1 A B ...
Excel equation
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
SolvedHi 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...
SolvedHello, 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
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
Solvedhello 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
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 ....
SolvedSearch 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
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
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
SolvedHello, 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!
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
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...
Copying data from one sheet to another conditionally
SolvedHi 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...
Highlight row on one sheet if a number matches on another sheet
SolvedHello, 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
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/ClosedHi, 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
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
SolvedI 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
SolvedHello 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
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
SolvedHi 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
ClosedHi 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
ClosedI 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
HELLO THERE NEED HELP TO RESOLVE AND MAKE THE BELOW CODE WORK IN EXCEL(MACRO) ActiveCell.FormulaR1C1 = _ "=IF(RC[-2]=""10X"",""Acquisition on do...
Change the column
Hello, I have to do the same thing as you but instead of using the column B, I have to use the column A. I tried to change your code but I didn't...
Excel cmd button to transfer data from source to another.
Hello, Can someone help me with my problem. Is there a way to create button to transfer data from source sheets to any other sheets in the same wo...
How do i change the result of a formula to normal text or values
SolvedHello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that for...
If formulas with dates
Hi all, I have a large spreadsheet that contains revenue information tied to sales deals. Column A contains the expected deal closing date and c...
Data sorting
Hi Folks, I need your help in data sorting. Basically I just want to automate the data to be sorted to another table, Names from table1 to table...
Excel mmyy format in order
SolvedHello, I have a data set and a column currently with a selection of dates in MYY and MMYY, eg. 909 (Sep 2009) 1011 (Oct 2011) 1212 (Dec 2012...
Macro adding a row and numbering it in excel
Hi, Please could someone help I am trying to record a macro that will add a row below and number A2 with a number say 1, 2, 3 etc. I also need to...
Date format
Hi, can i have solution for this question how to change date format this case to 21/11/13 to this 21-Nov-13. Thank you............
Macro
Hi, I want to setup a Macro to cary these 2 rows and coloms when I hit the Macro button in excel. Can any one help me. I am staeting with E7:F7. T...
Excel formula help
SolvedHello, I would like to request some assistance with a formula I have been trying to figure out. I know it's a simple one, but it evades my mind. ...
Apply conditional formatting rule if value is true?
Hello all! I have been searching for this answer for many days now, and I am getting quite frustrated. I'm not sure if it will work or not, but here i...
Track office log in and log out timings
Hi Team, Thanks for providing me an opportunity to be a part of the wonderful Team. I would need a Macro to track the shift timings of the emplo...
If cost is 18.66 what would be 0.6% of it (calculation method)
Solvedand if basic pay 65000rs what would be the 2.5% of it(calculation method)
Copy data from one sheet and putting it below a particular cell
I have a excel with 3 sheets . My requirement is to pull data from sheet1 ,sheet2 and put it into sheet3. There would be two headings in sheet 3 1...
Moving information from 1 set to another based on an if
I have two worksheets. 1 is Proposals 2 is Projects When a row in Proposals is given a Project #(a cell in that row) I need the cells in that row to ...
