The discussions
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 ...
Copy data from another sheet if the condition is met
Hello, Can you help me how can I create macro that will copy the data from one sheet to another sheet in the same file? Wherein if the Posting Acc...
Transfer data if....
Hi, I am in the process of building a database for injury management (I am a Sport Scientist). I have a master sheet which is basically a monthly ...
Comparing columns in excel 2010
SolvedHello all: I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is mi...
Set rows height also exception in range
SolvedHello, I would like to request that rows from 10 to 40 their height will be Set to 12.75 but exception rows 11, 16, 21, 26, 31, 36 height will be...
Comparing rows on two worksheets and pull data into a new sheet
SolvedMy requirement is following: I need to compare Column A, B and C of worksheet 1 to column A, B and C of Worksheet 2 If Above condition is met then I...
Listing ignoring blanks and avoiding duplicates
I have a query but need to send a sample excel file for that. How do I attach a file as I do not see any link for that. Regards. jsexcel
If formula
Hello, I've got this formula that is supposed to give me two values however when ever I implement it, it seems to just give me one value all of time...
Excel: get value from sheet 1 to sheet 2
Good evening, I need help please about what I am wrong. I have Cells A6 to F6 in Sheet1 has formula in it and I was trying to get the value of tho...
Today function
Hi, i am using today function in excel, i don't want change the date, when i open other day, it should show the previous date. Thanks Bbbp
Remove (shape) straight line
SolvedHello I would like to request how to remove straight line shape through vba It was made through the following vba code Sub Str_line() ActiveSh...
Formula to count the duplication of a value in a range
Hello, I am looking for a formula that can count the number of duplication of a particular value in a range of cells. Example: I need to know the ...