The discussions
Copy and paste row 5- row 9 n number of times
Hello, I am trying to save size of my Workbook from blowing of, which has lots of vlookup's and other formulas. So, i am trying to copy row 5-...
Copy and insert rows and number of times
Solved/ClosedHello, I have a sheet with over 800 rows. I need to copy each row and insert/repeat each entry 4 times below the preceding row. Example: Bef...
Pulling informations from excel spreadsheet
Hello - can anyone please help me? I have a spreadsheet that has the information from a Realtor office. It has all the information from each sale ...
If function formula based on three possible values from adjacent
SolvedGood morning all, Excel 2007 - I need a formula based on the three possible values from an adjacent cell. 1st value: : if F5 is a date, a simpl...
Transferring from sheet 1 to multiple other sheets conditionally
Hello, I would like to create a workbook for an English school I am starting in Tanzania. Once registered, all students info will be entered into ...
Recording macros
Any one know how to record a macro From sheet to sheet? For example I want to copy and paste open task from sheet one to two and next week open t...
Conditional formatting - highlight overdue dates
SolvedI am a beginner with conditional formatting and researching the net for an answer has left me more confused than when I began! I am working with Ex...
Addition formulae
Hello, I need to add formula between two cells, when updating one cell with any value then add this to my resultant cell automatically like if ...
Search and copy and paste
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)
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
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.
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
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!!!!
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 ...
Convert
how to convert PDF to word?
How to pick a word from one cell and copy it into another cell
Hello, please get the function. Configuration: Windows 7 / Chrome 38.0.2125.101
Auto filter depending on cell value
Solved/ClosedHello, 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
SolvedHello, 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 !
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
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
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...
Corrupt pptx files. need to repair them. please help!
SolvedHey guys, there is big mess over here. Here I quote: I made some presentation files for promoting our new business. I showed them to my boss. She wa...
How to recovery cleaned up email ?
I unwilling click on clean up on my outlook 2010 inbox messages and finally loose all my emails in my gmail account, how can I recover them
Insert rows based on cell value (simple vba, i assume...?)
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
Hello, Please someone help me to figure out this problem. example : A1 + B1 = C1 A2 + B2 = C2 . . . . A9 + B9 = C9 If A1 ~ A...
Copying a row
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
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
SolvedHello, 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...
How to fix inaccessible ost file trouble?
ClosedI am unable to open Outlook OST files due to some unexpected reasons. Now I am looking for an instant solution to fix it.
Lost password to pst file
SolvedHi, I had a .pst file with a password set on MS Outlook 2010. Now I can't remember what the password is. How can I get back my emails? Thanks.
Date result in excel
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
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
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...
Job
Hello, Configuration: Windows XP / Chrome 38.0.2125.111 plzzzz download this file help me
How to use a condition on a worksheet to copy a line from same
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 ...
Can't log in to mail.com
Hello, the mail.com e-mail site does not work. It opens but does not provide the places to login and type the log in information. Configurati...
Excel conditional formatting
can I make a cell = a value based on the value of another cell? example: I want to make A2 = 5 if A1
Conditional formatting using countifs - help
=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 ...
A table that filter makes problems
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
ClosedI 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
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...
How to insert/add zero before a format of number
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
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....
How change date format in excel
Hello, how to change and edit in date format dd/mm/yyyy in excel
Sum a cell with both numbers and alpha text
Is there a way to add multiple cells that contain numbers but also contain alpha text?
Data selection
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 ...
Conditional formatting
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
SolvedHelp me! I'm trying to conditionally format multiple cells based on different texts entered in another. For example: I have selected certain cells to...
Match value in 2 separate columns and return a value from a 3rd
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...
How to copy my all data in excel sheet1 to sheet 2
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. ...