Excel Forum
-
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...
-
simple macro Solved/Closed
I am trying to create a Macro to filling in a series of columns starting with the current cell. simply if cell A1 is selected and you hit the ...
-
Merging multilple cells based on certain criteria Closed
Hello, I am stumped on how to attempt this. I have read through some posts but here but I'm quite a novice at Excel so not sure what way to go. ...
-
fill amount from a cell if date is before end of month Solved/Closed
Can someone please help. I'm trying to track outstanding bills due by the end of month as in the following example: If date in cell B5 (due date) i...
-
Excel Referencing Closed
Hi Experts, I am having the following columns in the excel AA BB CC REQ_3.1_1 REQ_4.1.1_2 ...
-
convert number to words in excel Closed
----------------------------------------------------------------------------------- there is some problem while we convert number to words ............
-
Macro to copy the same values between 2 sheets to a new one Closed
Hello all, I'm not very familiar with macros in Excel and I hope to find a solution. I need a macro that works with 5 sheets (sheet1,2,3,4 and 5)...