Excel Forum
-
search and copy and paste Closed
Hello, I have already created macro tool and I need to include another macro which is a value in cell D16 is the name. We have a list of 30 named ...
-
Macro help (copy last row of item and paste into blank row) Closed
Hello! I need help with creating a macro. Currently I have a macro which creates a blank row everytime an item code in column A changes. Instead of ju...
-
search, copy and paste the calue Closed
Hello, I have a named in column A and telephone number in column B. I need only phone number. if i find the name I need to have only telephone nu...
-
Calling Cell for name on basis of changing number 0,1. Closed
Dear. I have attendance sheet name "Attendance" of 70 people. having table of their names in 1st Col and Absent in 2nd Col. Absent col changes everyda...
-
Clear contents then paste from subsheets macro Closed
Hi everybody, I have 13 subsheets that need to have their data put onto a master sheet. The header in A1:M1 is the same in every sheet, the data b...
-
TEACHER IN NEED!!!! Closed
Hello! Let me start by saying I only know BASICS about excel. I mean, I am proud of myself for finding the average of a few cells! That being said, I ...
-
Auto Filter depending on Cell Value Solved/Closed
Hello, I have data in a table, lets say the table is (A7:M200) and the Headings in this table is (A7:M7). Column 1 (A8:A200) is the accounts numbe...
-
How to find out the data in six month record Solved/Closed
Hello, I have six month excel attendance sheet. which formula can i use to know in which month which of the employee has left and who has joined?...
-
Help making macro finds last used line + push down and delete ! Closed
Hello guys, im always here to find answer for my excel problems but couldnt find answer for this. Every single day i have to do a job that is co...
-
Date Format Closed
Hi All, I want use date 201201, how can this will be set in Execl Format. please help me. Thanks
-
How to Cycle through 2 different workbooks and adding row 2newWB Closed
Hi all I am totally new to this forum posting. So please overlook any mistakes. First let me apologize as my first post was not per forum guidelin...
-
Gather information from one spreadsheet and move it to another Closed
I have a spreadsheet that has the information from a Realtor office. It has all the information from each sale for all Realtors. I need to pull cert...
-
Auto-copy data from one sheet to another in excel Closed
Hello, I have a master excel sheet that houses all of my data used to create several reports. Looking to transfer/copy data from this master sheet...
-
Insert rows based on cell value (simple VBA, I assume...?) Closed
Hello, sorry about my newbie question, I think it's very simple to solve, but have spent a few hours on google now and haven't found the right answ...
-
Sum Data Validation Closed
Hello, Please someone help me to figure out this problem. example : A1 + B1 = C1 A2 + B2 = C2 . . . . A9 + B9 = C9 If A1 ~ A...
-
sum data validation Closed
someone help me to figure out this problem. example : A1 + B1 = C1 A2 + B2 = C2 . . . . A9 + B9 = C9 If A1 ~ A9 data changed using dropd...
-
Copying a row Closed
I need help please. I have a workbook with several sheets. Each sheet contains similar data with a 'total' row indicating the total number of occurr...
-
Copy data from one worksheet to another worksheet Closed
Greetings All, Let me begin by saying that although I have frequently visited this site and have learned valuable information from the experts, this ...
-
Nested if then Solved/Closed
Hello, I would like to have the contents of b1 displayed in m2 if t2=1, the contents of b2 displayed in m2 if t2=2, the contents of c1 displayed in...
-
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.