The discussions
How to copy sheets from one work book to other
Dear Team. My query is Iam having two workbook in d drive as 1.xlsx and 2.xlsx i want to copy two sheets from 1.xlsx and paste in 2.xlsx ...
Macro to add down a column
Hello all, I need a macro that will sum numbers down a column until it gets as close to 8 as possible. ex: 1 .5 .5 4 3 .5 3 2 so a ...
Nested formula with 'or' statement
Hi, I have formula IF(ISBLANK(A3)," ", C3-TODAY()), which works absolutely fine but and i want to include another argument on it so that if value in ...
Sumproduct gives me error
Hi, I am using the below formula, but it gives me error. Any ideas why is that? I really should work same as the countif formula but instead it giv...
Find text in one cell, add different in another cell
Please be aware, I don't have much hair on my head to begin with and really don't have much to pull out either.. I'm frustrated. I've tried every ...
Moving columns based on text
Suppose data is like this: 3 3 OPG 4 5 2 5 3 MCG 0 4 3 0 4 ELG 4 2 4 7 5 CTG 4 2 1 I want a macro ...
How to do recursive searches in excel
Hi, I have two worksheets. I need to be able to traverse a column in the first sheet and for each cell, compare it to a cell in the second sheet. If ...
Cell auto filled with dots
SolvedHello, I sow it once but not sure where and can't work out how to do it. Basically, if I write things in excel, I need it to be auto filled with do...
Automatically transfer data from one sheet to another
Hello, I have a workbook in sheet1 details of materials issued to dealer for job work Sheet1 Columns: Dealer name, Date, Challan No, Item, Qty, etc ...
How to copy data from one excel table to other
I have two sets of excel tables. The master table has got several columns with heads defined. Similarly, the row heads have also been defined. Now...
Error in date formate
find attachment of date format issue .......how resole the error please let me know
Vlookup problem?
I have 4 Column A,B,C,D A=date B=MarketValue C=Results D=Numbers when i use the vlookup formula in other sheet it not working =vlookup(A2,Shee...
Deleting rows with no data (in a range)
Hello, I have a sheet that I have been working on..all working fine, however I have one last bit that I cant seem to get right. Worksheet - "Fr...
Total and avg. data from another worksheet based on day of week
I am doing tracking for my employer. I have a sheet (Sheet 1) that I input data for every day of that month(i.e. 1st-31st) in the adjacent column I li...
Insert date from one sheet to another sheet ?
Dear Sir I have Two Sheets one Name is FirmDate and Other Event i want i put one date in Event and 260 Dates FirmDate uper of Select date in i...
Excel how to question
Hello, I did not intend to offend anyone when i originally posted this message, I am new to forums and was not aware of the policy. I do apologize. ...
Macro to rearrange data
I would like to enter a data as shown in the sheet 1 pic below and want it to be stored as shown in sheet 2. Can someone share how to code using macr...
Conditional formatting special
Hi, I'm trying to create a conditional formatting to highlight the column if the cell in row 4 ="S". I can do it one column at the time, like the ru...
If formula
hi all Please help me with this. Any help will be appreciated. Thanks in advance. if date in column A which refers to a text in column B..(A1 date...
Auto select print area and prints
can anybody explain the Macro for auto select print area and print with a Print button in any cell i've a sheet with receipt. and i want to print r...
How to delete strings of words from a range of cells
SolvedI have a list of website for which some start with www. and others start with http://. I have been trying to remove the "http://" from all the cells a...
Need formula for automatic date update in same cell
SolvedHi all, I was wondering if anyone knew of a formula that would allow excel to change a date in a cell automatically once a certain date had passed?...
If formula
What is the mistake in this formula ?? =IF((D10>(B10/2))&((F10)
How to show/hide excel worksheet using userform
Hello, I have prepared one user form and given option button & submit button. I have 4 worksheet. My queries is.... 1. If I select Option 1...
Using sheets in excel
Hi, I am using excel 2007 and have a product database in sheet 1 with multiple columns. I want to take selected columns from this product datab...
Changing cell background color based on another cells background
Hi guys. Quick question, is there anyway to change a cell background color based on another cell background being a particular color? I have a r...
Match formula in excel
to match data in one column to another and result from another column.
Excel macro to search for specific cell and subtract value
Good evening guys, My first question here. I'm being beaten by an Excel Macro, I've done some before but this appears to be beyond me. I'm tryin...
Wanted to insert column in excel sheet using macro.
Sub test() Dim j As Integer, k As Integer j = Range("B1").End(xlToRight).Column 'j is the last column For k = j To 2 Step -1 Range(Cells(1, k), C...
Excel conditional formatting
I have a worksheet that contains a row of payments per month....I want to include in a separate cell the amount of payments that are over $60 per mont...
Macro to move rows to a new location
Hi, I was hoping for a macro that if in column "C" of an excel spreadsheet it has the number 8 or 9, the whole row gets moved 5 spaces below the the l...
Conditional format based on another cell on another page
I have two databases. One is a list of parents and the other a list of students. The parents each have a unique 'Parent ID.' I need to evaluate each ...
Column change where pull values from according to the month
Hi All, Please let me know if the below are possible and how: I have a workbook with multiple sheets named "SUMMARY" (Master sheet), "MAR", "APR...
Creating a macro to find text and then merge cells
SolvedHi- I need some help with creating a macro. I haven't been able to get it to record correctly and I am completely illiterate in Visual Basic. ...
Convert numeric date into words
hi want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 or Twenty Tw...
Macro in excel to copy and paste selected from one sheet
Hi I have an excel with couple of sheets. 1st sheet contains summarized data. Now I want to scatter the summarized data and copy the same data in t...
Edate if then scenario
I have a date column of original date of action. I have another column that has a formula to give me 6 months from that date (which is when additiona...
Insert one new copy row
i need help pleas :) i want to insert one new row every time Verifies the condition and also copy some cells from last row like if(y3="y",...
Automatically insert the current date into one cell when "x" is
I'm trying to create and IF formula. What I want it to do it automatically insert the current date into one cell when "x" is typed into a different ce...
To get a price from price list while making a purchase order
Hi,I would like to know how to create a macro code I have two files one named Price list and other Purchase Order. Actually I wanted like this ,the pr...
Use conditional formatting to copy entire rows
Hello, My name is Brandon I'm new to the forum and am thrilled to have found a community that specializes in excel. The current issue I'm having i...
Page set up
Hi.. In Excel , I need to have at last paper from the sheet a different ( first row ) not matching the (repeated rows at the top of each paper from...
Bold text
SolvedHello Sir, I required the macro to bold some specific text in cell like: Below mentioned formula is written in cell ="We are enclosing herew...
Broken brain! can you help?
Hi guys, As a relative newbie to excel I've been trying to solve a referencing problem for days and I'd be hugely grateful to anyone who can solve ...
Auto-copy rows based on their values to a new sheet
Hello, This is my first time in a forum like this but I have already browsed through a lot of sites regarding how to do this. I have been using ...
Finding duplicate value and display the duplicate cell address
Hi, I'm a new member. I've data of different roads with their distance data in multiple sheets ie., different sheets for different years. I want chec...
Need vba code to transfer data from sheet3 to row1 of sheet2?
SolvedHi dears, I need a VBA Code which can transfer the LAST ROW's (ie 15 or 29 or may be any other) Data of Sheet 3 to ROW 2 of Sheet 2 . Reason to Trans...
Preguntas en excel en computacion
digame cual la funcion que de daba la fecha y hora en excel
Want to create macro...help required
Dear All, I have two sheet one containing first sheet containig below columns 1)customer name 2)customer type 3)customer tel no. 4)customer res...
Copy & paste in excel using macros
Dear Friends, I have a interesting query about the heading. I have a master excel file, in which I want to copy the content of the another Excel f...
