Excel Forum
-
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...
-
Change the column [Closed]
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. [Closed]
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 [Solved/Closed]
Hello , 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 [Closed]
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 [Closed]
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 [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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 [Closed]
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 [Solved/Closed]
Hello, 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? [Closed]
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 [Closed]
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...
-
how do i change the result of a formula into normal text ? [Closed]
Hello , 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 f...
-
if cost is 18.66 what would be 0.6% of it (calculation method) [Solved/Closed]
and 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 [Closed]
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 [Closed]
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 ...
-
How to move data from one sheet to another [Closed]
I have an excel spreadsheet, and I need a macro , in sheet1 I have several values of 7 numbers in a cell, example 1|2|3|4|5|6|7| up to 93|94|95|96|97|...
-
how to formula the table [Closed]
Table 0 to 1000 value is 2 1001 to 2000 value is 3 2001 to 3000 value is 4 3001 to 4000 value is 5 4001 to 5000 value i...
-
Conditional Formatting with dates [Closed]
Hello, Your help would be greatly appreciated I have a cell with a date in it (A1). I want that cell to change colour if the following criteria is ...
-
Date issues [Closed]
Hello, i have the following problem with excel 2010 on windows 7 pro. i select col A and format it to Date yyyy-MM-dd i enter 2014-01-08 in A...
-
Data import from a Notepad [Closed]
Hello everybody. Hope you are doing well. please help me in the following situation. Suppose i have a notepad file where there are some company rec...
-
need macro help [Closed]
Hello; thanks for viewing this question.... I need help creating a macro, with detailed instructions on how to put it into excel and actually make ...
-
formulas [Solved/Closed]
sum a column if two other columns contain a specific text each so sum (if (A1:A20=1 and B1:B20 = "A", C1:c20)
-
Copy data from current work to another [Solved/Closed]
Hi All, Please can you help me with the VBA code which copies columns from current active workbook to another closed workbook at the end of rows.....
-
Excel column linking query [Closed]
Hi, I would like to know how to link one column with another therefore having the second column recognise it at the same. eg Typing a name in colu...
-
Excel 2007 - Conditional Format Using Calendar Months [Closed]
I'm have a workbsheet that has a bunch of dates that show when people have completed their annual training. What I'm trying to do is take the train...
-
Conditional formatting from another cell by range [Solved/Closed]
Hey, I need helpppppppp i want to change the color of a cell based on the range value of another cell eg. i need a1 to be red if b1 is < 70%, Y...
-
put the value from various excel sheets using lookup : [Closed]
In Sheet1, A B C D ...
-
#value [Closed]
Hi, am trying to correct a formula. Each time am using this formula: =IFERROR(VLOOKUP(B15;'Liste des Prix Net'!$A$1:$B$8;2;0);(P15/Q15)*(L15/1000)...
-
Auto sheets .... with common data? [Closed]
Hello, I would like to have a new sheet generated on open of workbook with sheet name generated in sequence (i.e. main sheet has common data the...
-
How to Attach a work book [Closed]
Hi Sirs, I was asked from a forum member to attach the sample file When I failed to attach as desired. Pl help me regards ansharma
-
Excel Formula [Solved/Closed]
I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria If nu...
-
Copying simple form data into new databse [Closed]
Hello, I'd like to create a simple form that I can then copy into a spreadsheet and will update another workbook for data. My form is very straight...
-
Compare and return the oldest date [Closed]
I have a shared workbook comprised of a full report sheet and sheets for individual employees that is being used as a weekly report. Employees enter ...
-
Excel IF help [Closed]
Hello, I am looking for a function I think an IF statement for some accounts. I want to say IF ( The value in column B="Tom") THEN (Add the v...
-
Comparision of Excel sheets [Closed]
I just want to ask for your help by providing me codes / references to compare the data in two worksheet, which it means to compare the data in sheet ...
-
Changing cell color dependent on date in a different cell [Closed]
Please help. I created an spreadsheet in Excel 2010 for new hires form tracking. I now would like to have cells change colors to remind me that certai...
-
code to move a row based on fix values and paste it [Solved/Closed]
Hello Gurus, This is my 1st question and I m a beginner in macros .I wanted a code to move a row based on a fix values and paste it in the same shee...
