The discussions
Using the if function for dates
SolvedHello, I am trying to figure out in Microsoft excel 2010 the appropriate IF formula to use. I am trying to calculate the number of working days th...
Number conversion to code
Hello, Hello, I appreciate any and all who may give this issue some consideration. This is to change a number to a code of letters to hide ...
How to separate the worksheet based on data
Dear Sir. I had the data as mentioned below for your reference CODE EMPNAME EB HRA GROSS 175702 MAURICE J P 10,140...
Copy data without opening workbook using vbscript
Hello all, Is it possible to copy data without opening workbooks using vbscript? Thanks in Advance!
Help writing a if formula
SolvedHello, I need to write an IF formula for excel. Cell A2 will either say ''receive'' or ''deliver''. This formula works IF(A2=''receive'',1,2);...
If a cell in column contains "x", return the value
Basically I have a large spreadsheet and I want to pick out the values that I flag with an X. Not all of the rows have an x next to it, but the ones t...
Help with a formula
SolvedPlease help !! Looking to calculate totals based on the following... Entering the formula in the following field K4 I have rows (B4 thru B18) e...
Formula to add 1 with if statement
SolvedHi, Here's the breakdown of what I'm trying to do: The formula is going in cell 'Y28' and I'm attempting to do two different things: 1) I want...
Formula issues with various variables
Hello, I appreciate the time the forum are taking to view my message. I'd very much appreciate it if someone could help me, as I'm trying to make ...
Transfer data automatically from one sheet to other based in
Title->Transfer data automatically from one sheet to other based in specific dates. Hello and sory for my long title. How can transfer data from a c...
Updating existing worksheet
Hello, everyone I hope everyone's holiday's are great. I want to thank everyone in advance for their help with this situation I am having in excel. ...
Not pasting values in excel file
SolvedHello, I would like to know that I have a Excel Macro Enabled File. it has macros, sheet vba code, modules and user forms code and no merging...
Sort
Hello, On Column A I have DATES Column B a code (D1111, D2222) Column C Vendor num Column D Client num I want to be able to identify when f...
Coping formulas to next row using a macro
SolvedHello, I am trying to make a macro to copy a formula to the next row in a spreadsheet. Then paste the absolute values back into the original row. I...
Vba code
I dont know how but I managed to put together a macro that copies transposed info entered in a column of one sheet to a row in another sheet. The prob...
Restriction of @ and .com
Hello, Thank you for your reply, I have another question, if you can help me with that too? I want to add a restriction in a column for suppose C co...
Compare data in two excel sheets
Hello, I have huge data in two different excel sheets (same work book), approx. 10 columns & 5000 rows. I want to compare both the sheets and find...
Excel sheet alphabet count
Hello, How can I count alphabet on excel sheet. kindly send me the details Thanks & regards Pulakesh Medhi
Subtraction total
Good evening, please anyone who can help me, i have in cell J5 all products eg. 20 parts. In cells L5:W5 add how many parts i have used. How i will ...
Add a restriction to a column
SolvedHello, Can you please help me out, I'm stuck. I have to restrict the numbers 03 in a column that must contain 11 characters ( the number should st...
How to find a blank cell in particular column?
Hello, I want o identify the blank cell in Particular column, and in this my blank cell is my last cell even it would be helpful if anyone suggest...
How to copy multiple lines with a macro
Hello! I have never worked with Macros but I strongly believe they could save my current data crunching work (that I need to finish by tomorrow or ...
Conditional formatting through macro
SolvedHello, I would like to request that how Conditional Formatting would apply through Macro and the Conditions are Range is E11 to E510 if Colum...
Excel formula needed
Hello, Need excel code for min(1-5), N or X Example data: 1. 3. 5. 2 X. --> 1 X. N. X. X. N. -->N X x x x x x x. --> x X 3 2 N. X N...
Sum values from one column if another column equals x
SolvedHello, Is there a formula that can calculate the sum of cells from one column if the value in another specific cell equals x (or not blank)? I tried...
Vba - copying data to new sheets
Greetings Excel experts, I'm trying to figure out how to tackle a problem. Basically, I have a master sheet with a bunch of data and I would like ...
Weird date display in excel
Hello, This seems like a really simple problem to solve but totally has me stumped. I have entered my date as 30/11/15 (DMY) into the excel cel...
Worksheet_change event
Hello, I have a vb script worksheet_change I am trying to get a conditional If like statement to work in the code where a condition is met from...
Retrieve data from column a based on condition from column b
I have a set of data in a column. Say like below: Col A Sets Apple 1 Apple 1 ...
Autocopy row based on whether the cell in a certain column is
Hello, I have a detailed aging report that I am attempting to create monthly tabs in. Basically what I need is a macro that will auto paste the en...
Transfer worksheet
SolvedHello, How can I transfer an excel worksheet into another excel file. And when transferred I won't have to modify anything. Right now i'm cutting a...
Problem when format date option
Hello, I have a date "17/07/15" and "01/07/2015" i want to change it to "July-15" format for all cases. I go through format option and select the op...
Excel and dates
Hello, I have three columns, for example 19-Nov-15 then 26- NOV-15, I want the third column to = the most recent date of the two +7. because I nee...
Copy invoice dates to ledger
Closed@vcoolio Read your reply in an earlier post. copied it to my use, but this did not work. please help. I am copying a list of cell entries from invoi...
How to convert number into words
Hello, pl give the solution
Transfer data from excel sheet to excel sheets.
Hello I have a table contains about 5000 rows and 4 columns. The columns are Date, Codes, Department and Amount. I entered one year's data in that ...
Excel formula
SolvedHello, I'm trying to do a formula like: If value of celA3=sunday, then write dimanche Any help would be appreciated. thanks
Scroll mouse in listbox
SolvedHello, I would like to know that How do I enable mouse scroll in listbox inside a userform. Thanks Configuration: Windows 7 / Chrome 46.0.24...
Date change to dd/mm/yyyy to dd/mm/yy
Hello, I Want to change date format dd/mm/yyyy to dd/mm/yy in MS Excel 2003 Please revert me urgently Configuration: Windows XP / Chrome 46.0...
Calculation of age
Hello All, I have been trying to calculate the exact age of a person from two dates in Office 2007. In the first cell I have the current date and i...
Create a summary table from a master table
Hello, I need a formula to create a summary table from a master table as below : Item Des. year ...
Get other cells value
Hello, I am stuck in a formula and I cannot solve it. Please I need help. I am making a survey on excel, and I need the result for a whole month ...
Compare excel sheet1 to sheet2 and highlight changes in sheet2
I have explained my query in screenshot. Somebody please help me get this resolved.....
Export data from one sheet to another
I need help. I have a form call Purchase Request from where I want transfer data to different fields in next sheet and then need to raise Purchase ...
Copying cells if criteria is met
Hello, I have multiple sheets with sheet 1 as the main sheet for entering data. A cell for entering a order number Cells for entering invoic...
Copy a 'template' sheet onto multiple other sheets
SolvedHello, i have been trying to create a sheet that creates new sheets from a list and i have been using the following macro to generate the sheets from ...
Averageif function using dates
Hi there. I'm trying to set up an average function based on dates entered in column a, for the data in column b. I want to use the data in b if the...
Compare to columns in v lookup
Hello, hii i want to compare to columns in v lookup.. Pls advise ... Configuration: Windows 7 / Chrome 44.0.2403.155
Add sheets to combobox
SolvedHello, Hi I would like to know that how to add sheets (which are exist in active workbook) in ComboBox used in Userform. Thanks Configurati...
Conditional formatting on multiple criteria
Solvedhi, i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am ...
