Excel Forum
-
Copy, Find, replace from one excel to another excel [Closed]
Hi friends, Greetings ! could you please anybody can help me to make excel macro or VBscript which should do the following steps, 1.copy th...
-
Copy, find, replace from one excel to another excel [Closed]
Hello, i like to make marcro which should do the following step, 1.copy the cells from A2 to D100 in Excel A and it has to search the copied v...
-
Value of adjacent cell in new cell [Closed]
I have 4 columns of data and I want to put the value of of the cell containing the date which is in column b based on if the word start1 is found in c...
-
copying data from one sheet to another [Closed]
Hello, Configuration: Windows 7 / Chrome 38.0.2125.111 how can I transfer data from one sheet to another assume that i have two differen...
-
Merging two sheets [Closed]
Hello, I have two sheets sheet one has names, sales numbers per month, revenue generated per month and a Q1 combined total sales and combined to...
-
convert number in to alpha bet [Closed]
Hello, sir, we have required formula of number convert to alphabet Configuration: Windows 7 / Chrome 38.0.2125.111
-
number to words [Closed]
number to words
-
Date result in excel [Closed]
Hello, I am trying to solved this formula, I want to have a result in a cell Date now. This is the issue, =if(I9="Done", Now()) Kindly correct pl...
-
How to copy row frm 1 sheet to another depending on the value [Closed]
Hello, I am a beginner to this area of VBA coding. I wanted to know how can i copy a row from 2nd sheet (Sheet2) to first sheet (Sheet1) depending...
-
how to extract data from named sheets to summary sheet [Closed]
Hi, I have data in sheets, say Nov1, Nov2 to Nov30. I am looking for a solution, a) in cell B2 of the summary sheet, the values have to appear fro...
-
Seperating data by 1 condition to new worksheet and renaming [Closed]
Hello, I need to separate some data from Sheet 1 based on the numbers in column A, each different group of numbers should go to its own worksheet and ...
-
How to use a condition on a worksheet to copy a line from same [Closed]
Hello, I'm trying to use an input value on one worksheet to copy a line from one worksheet to another worksheet. Specifically- I'd like to copy ...
-
Macro to Move cells from one sheet to another if conditions meet [Closed]
Hello, I have Sheet with Two Columns and several rows.. This gets edited each week. But i want to copy these values onto another sheet. with simil...
-
How to insert images to my excel sheet by using a Macro [Closed]
I have my huge files and below is a sample. I need to add photos for everycode in coloumn "A" to the same row coloumn "E" and I want to run a mac...
-
excel conditional formatting [Closed]
can I make a cell = a value based on the value of another cell? example: I want to make A2 = 5 if A1
-
Create worksheet with a list,and fill the worksheet from another [Closed]
hello all, i want to ask.. if i want to create a worksheet with a list from sheet1, begin from b2, i figgured this out with macro from https://c...
-
date format [Closed]
hello, i ve an excel sheet and want to enter date in format dd/mm/yy, but cell automatically change it and treat as mm/dd/yy, i want excel treat i...
-
create worksheet with a list,and fill the worksheet from another [Closed]
hi all, i want to ask.. if i want to create a worksheet with a list from sheet1, begin from b2, i figgured this out with macro from https://ccm.ne...
-
How to convert existing date to another date format in Excel [Closed]
Hello, I want to convert existing date like- 18.5.2014 to another date format like- 18 May, 2014 in office Excel 2007. Existing format is- ...
-
Auto-update the last data in report sheet [Closed]
Hi all, Looking for help on my regular report. The water quality is updated regularly in the data sheet and need to transfer to the report sheet t...
-
Simple copy/paste macro sheet to sheet [Closed]
Hello, I am trying to use a receipt template in excel to print individual receipts. Once all data is entered, I will make single receipt printout ...
-
Conditional Formatting using Countifs - help [Closed]
=COUNTIFS(D$3:D$21,"Yes",$A$3:$A$21,$A3)>1 Above is my countif statement to count the number of times a particular criteria exists. D3:D21 should ...
-
Copy rows multiple time [Closed]
Hello Experts, I am trying to copy a row with multiple columns n number of time, here is an example SNo H No. Name State Times 67 ...
-
How to convert existing date to another date format [Closed]
Hello, I want to convert existing date like- 18.5.2014 to another date format like- 18 May, 2014. Existing Scenario is- 18.05.2014 19.05.2...
-
change the date format [Closed]
Hello, i wanna change the date format where the date is 10/5/2014 bur when i tried to filter month wise excel is taking it as 5th Oct'14 Config...
-
a table that filter makes problems [Closed]
Hi everyone, i dont know why but every time i filter something the whole screen goes blank. Any ideas? Thanks in advance!
-
How to transfer current data from one sheet to another sheet [Closed]
I have two sheets. The first sheet contains several columns for various vehicles wherein the first column is intended for the dates. Everyday I have t...
-
How to transfer current data from one sheet to another sheet [Closed]
Please refer to the figure below: My problem is that I want to see in Sheet 2 under column C the updated Odometer reading that I entered in S...
-
Highlight only if drop down menu changes? Excel 2010 [Closed]
Hello, I am trying to format my sheet so that it will highlight the cell only if my drop down menu changes from one value to another. I know how t...
-
error in macro search [Closed]
I made a vba macro to retrieve data from a database in Excel. if the data is not found; I get an error message and I have to restart the macro again. ...
-
return textbox value by combobox [Closed]
hi i have a combobox and a textbox.i want a vba to perform counting filtered range based on a the combox selected value.thanx in advance.
-
how to insert/add zero before a format of number [Closed]
i have an excel sheet in which column A contains value like a)1344.0001, b)1344.001, c)344.001, d)1344 i want all my information to be in 000...
-
Conditional formatting [Closed]
This is my first post and I need some help please. How can I format excel so that if E3 ="STO" then I3 Formula =F2*100*G2-H2, IF NOT I3=F2*100*G2+H2....
-
Copy data from old excel file (97-2003) to the new file (2007) [Closed]
Hello, Pls, could someone advise me. I cannot Copy data from old version excel file (97-2003) to the new version excel 2007 sheet. The optio...
-
Quote- Conditional automatic copy from sheet 2-4 back to sheet 1 [Closed]
Hi, does anyone know how to do the following. I want to automatically copy a product description and number of items to a front quote page (sheet 1) ...
-
formula for my result card pleaz [Closed]
Hello, MAdam i want position farmula for my result card pleaz if u help me than i m thanked for this given data is Name Eng Urdu Math's En...
-
how change date format in excel [Closed]
Hello, how to change and edit in date format dd/mm/yyyy in excel
-
Sum a cell with both numbers and alpha text [Closed]
Is there a way to add multiple cells that contain numbers but also contain alpha text?
-
Data Selection [Closed]
Hello, I am looking for a macro or formula in excel to select some information according to the same criteria: eg. from this table A 3.32 10 12 ...
-
Copying from master 'list' to new workbook [Closed]
Hello, I have an patient excel workbook which contains client columns for last name, first name, etc, and a (text) column titled 1:1, which contai...
-
Conditional formatting [Closed]
Hello, Would anyone know how to make this work in conditional formatting: =COUNTIFS(G1:K8,5,A1:E8,">=30")
-
How to format cells based on the text in another cell [Solved/Closed]
Help me! I'm trying to conditionally format multiple cells based on different texts entered in another. For example: I have selected certain cells to...
-
Create new sheets with template using data tab [Closed]
Hi, I'm a little new to macros but I'm making some progress. Basically what I need to do is create new sheets for each line of data, but I want tha...
-
Match value in 2 separate columns and return a value from a 3rd [Closed]
Hello, Here is my issue. I have 2 worksheets within 1 workbook. I need to add a formula that will look at the value in sheet 1 column A and t...
-
Need Macro code for Search, Copy & Paste? [Closed]
Hello, I have Two Excel sheets , In Sheet2: Database file(Row wise Data has been updated i.e only in A column- refer below A1: Name A2 ...
-
Automatic updation of date [Closed]
Hello, I am looking for a solution for the following The file format is as follows A : Name B: Date C: Time When some one enter the name...
-
Automatic addition of date [Closed]
I want to add the date of modification of the cell in a file . the format is as follows A : Name B: Date C: Time When some one enter the nam...
-
formatting a column with repititive lines of texts with same col [Closed]
Hi i have just completed a time and motion excercise and i have enetered the details into excel. i have also cleaned up my data, checked for inc...
-
How to Copy my all data in excel sheet1 to sheet 2 [Closed]
HI.. all I have a Question. I have some data in my excel sheet1 . i want same data move or copy sheet1 to sheet2 by formula. i wait response. ...
-
Making Buttons to direct to a certain cel location. [Closed]
Hello, I'm just wondering if its possible to make a button that redirects you to a certain cel information in EXcel. Sample: I want the button...
