The discussions
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...
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...
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...
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 ...
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. ...
Insert/remove photos depending up on ref. cell value changing
SolvedHello, I designed a Student Profile in excel using LOOKUP function. In this profile, near the Student Name title I created one drop down list of stu...
Calculate difference in date
Hello all I have date column in following format- 21/09/2014 06:26 AM I want to calculate difference between above date and today. I tried doing ...
Excel vba copy and paste loop with logic condition
SolvedHi, I am new to VBA and would appreciate some help with a problem I am trying to solve. I would like a macro that is able to copy information f...
Excel workbook with two sheets
SolvedHi, i have an Excel workbook with two sheets and when i enter data in sheet #1 it automatically goes to sheet # 2. How on earth can i stop this fro...
Need help with formula if multiple cells are empty then another
I am using excel 2010, I need help with a formula that i can t seem to get i know i am close. example. A1,B1,C1,D1 - if B1 is blank and C1 is blank ...
Keep rules & formatting intact when data is copied to cells
Hi, I have an excel sheet made with few rules and formatting for cells but many times I have the requirement to copy values to these cells from tex...
How to copy data from rows with value to a new sheet using macro
I have a massive excel spread sheet that I am using to keep track of sales. I would like a formula or function that will take both the headers along...
%age of numbers
I have ten different numbers in a column. I want to calculate the percentage value of each number in next box to each number with respect to 350
Shared file want to get a pop up message when the file is opened
I am trying to share a file between 3 people. I found the share option but I want to get a pop up message anytime the file is already open & someone ...
Convert from one column using if function
hi i have the information in one Column "A". This "A"Column contains 100 address .(Each line of the address has been typed in separate row) but eac...
Auto transfer of a filtered item to a different sheet.
SolvedHello everyone, I would like to ask for some help regarding some EXEL problems. Example: I want some data from sheet1 E columns to transfer to...
Moving data in specific columns to another sheet
Hi there, I have a workbook with multiple tabs. I need to move the first 3 columns of data in a row on tab, "MV Data" to another sheet labeled, "Campa...
Sorting contents from columns to rows
Hi, I have data sets in particular file format. Total no: of rows : 3623 (Column A) Total no: of rate cards: 26 (Column E) Rates for each code...
Any way to keep the formatting when using a formula in excel2007
I would like to copy the contents and format of a column of cells and paste them in another column using a formula. All columns are formatted as ty...
Comparing data between two spreadsheets
I have two spreadsheets that includes account number, name, and a charge amount for one (positive number) and a waiver amount (negative number) on the...
How do i check for a blank cell in a range and replace them
I am looking for a way to check to see if cells in a column are blank and replace the blanks with a character (in the case a ?) in an Excel 2010 works...
Color cells based on input
I want to change color of my cells based on an input. eg: If I input 3 in a particular cell, 3 consecutive cells must be highlighted. Any thoughts?
Excel 2007 using vlookup function in vba
SolvedI have a list of name and employee number in sheet 1 in column a and b.. Then what i want is to by simply typing the employee number in sheet 2 column...
Conditional formatting-color a cell based on the value of anothe
Hello, I have 2 columns of cells: R1-R100 & S1-S100. The cells in column R are the sum of cells L2:Q2, etc are is labeled "Expected Time to Process ...
Comparing street address in two different worksheets
Greetings collaborators! I would like some assistance with comparing street addresses in two different worksheets. The lists are quite long (thous...
I am trying to add 10 days to a "custom" date
In the original cell I am using a custom date format of 00\/00\/0000 and in another cell I am adding 10 days to the date with the simple formula C1+10...
Strange problem with a macro
Hi, I've been using an Excel macro for some time that opens another spreadsheet, selects all of the cells, copies them, comes back to the .xlsm wor...
Automatically transfer data from excel forms into worksheet
Hello, I have a requirement to automatically extract data contained in Excel Forms, (there could be hundreds of forms) into a worksheet. Any assistan...
How to write vba macro in excel 2013 to delete cells in column
I am analyzing data of two column A1-A310632 cell and B1-B310632 cells to check and delete the first 2 columns i.e A1-2,B1-B2 while keeping the nex...
Hey may i ask you something please?
i have two columns "County" and "County Code" i want to check country code not blank , and country code blank then return a value from a County to a n...
