The discussions

Transfer from one worksheet to another with a codition

Hello, all i have question I'm trying to populate a work book in order to organized my warehouse. on the first sheet i have 6 columns with the follo...

Last reply on 1 Aug 2015 by
vcoolio

Need to add next loop in code

Thanks for this. i have little bit issue if you solve this Here is code, as you see i repeat code for next row and sheet calculation. i just want to...

Last reply on 31 Jul 2015 by
FaizanRoshan88

Need vba code to create loops please

 Solved

I have done loops before but it has been a long time. I need to loop through rows of data and the rows of data changes. The value in column "N" is t...

Last reply on 31 Jul 2015 by
FaizanRoshan88

Need help copying to another tab . .

Hello, I need to copy a row (multiple rows) if a cell in that row contains certain text. For example if C12 contains the word "expense" I need the...

Last reply on 31 Jul 2015 by
vcoolio

Common part numbers on bom

I have many many worksheets within an Excel file. Each one contains a list of components used to make a final product (assembly). This is called a BOM...

Last reply on 30 Jul 2015 by
iotcom

Vba

 Solved

I want to append the month name at the end of the tab names in my workbook I have 86 tabs which are named by employee name and every month I want to ...

Last reply on 30 Jul 2015 by
looneybin

Macros or formula?

I have a report to run for work each week. Simply said, I obtain the raw data and need to sort and filter it based on a certain criteria. Then I need ...

Last reply on 30 Jul 2015 by
TrowaD

Formatting cells

 Solved

I'm stuck.... I am creating an invoice of sorts for a company who deals in different currencies. Q1. I have created a drop down list of all products ...

Last reply on 28 Jul 2015 by
Stace123

Cutting last 10 charecters of a cell and pasting to next cell

 Solved

Hi Guys - Im back again with another excel macro problem. I can find all sorts of advice when I google this, but none of it quite matches my needs so ...

Last reply on 28 Jul 2015 by
TrowaD

Conditional formatting where 2 statements are met

Hello, I'm trying to use conditional formatting in excel 2010 where if the data in column D is 'In Progress' and the data in column N is a % betwee...

Last reply on 28 Jul 2015 by
TrowaD

Prepare summary sheet order by items from variuos sheets in work

Hello, I need to prepare a consolidated summary sheet .(Basically Timesheet) The description of the summary sheet as below. 1. A master wor...

Last reply on 28 Jul 2015 by
laxmi

Search using formula

I have around 10 sheets in excel say sheet name as 1 , 2 , 3 ..... I wanted to search a word in specific sheet and get the Number from the next cel...

Last reply on 27 Jul 2015 by
TrowaD

Vba copy and paste range to next empty cell(s) to right

Hello! I'm fairly new to VBA, and I'm new here, so please bear with me as I try to explain what I need. I have a set of data that will be updated on...

Last reply on 26 Jul 2015 by
micksv

Conditional text based on text in another cell

Hi, I'm trying to format a cell (D2) on Excel 2007 so that when the cell next to it (E2) contains "LFC-0.3", it will say "Downregulated", but if the ...

Last reply on 26 Jul 2015 by
M.Hanzla

Date

what is the formula to convert numeric date into words in excel

Last reply on 25 Jul 2015 by
xpcman

Excel formula needed to count a list of names

 Solved

Hi This is probably an easy one for the pro's, basically I have a list of names that will change as reports are generated. The report will inclu...

Last reply on 25 Jul 2015 by
LINA

Automatically copy new survey data to another sheet

Greetings, I'm trying to copy certain cells of data received via an Excel Survey to another sheet. Trouble is, when new data is received, the row num...

Last reply on 25 Jul 2015 by
vcoolio

Conditional formatting: find text and highlight from other cell

 Solved

I have a table with names and number values alternating in a table. I add all the numerical values and highlight based on the total value for each nam...

Last reply on 23 Jul 2015 by
TrowaD

Macros to add numbers

Hello, I need to create a button and on every click of that button it should add 1 to it. For Eg first click it should take data as 1 and second ...

Last reply on 22 Jul 2015 by
vcoolio

Change date format

Hello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2010 Please solve my problem urgently Configuration: Windows 7 / Chr...

Last reply on 21 Jul 2015 by
TrowaD

Need a macro to searched data in another excel

Hello, I have a requirement , where in in one excel sheet i have data with 5 columns (A, B , C , D , E) now i want to search the excel on data wit...

Last reply on 21 Jul 2015 by
M.Hanzla

Date format

Hello, In my system date is in dd/mm/yyyy but I required in this format dd-mm-yyyy how it will possible pl let me know Configuration: Win...

Last reply on 20 Jul 2015 by
TrowaD

Condition formatting on changing cell color based on another cel

hi, wanted to check if it's possible to do condition formatting on cell color based on another cell's text. For example I have cell A1 with Text Pa...

Last reply on 17 Jul 2015 by
Mazzaropi

To copy data to other workshet by suming the value based on co

Hello, I am having table like below with large data in DATA.xlsx file Pls see attached file for table details My requirement is to selec...

Last reply on 17 Jul 2015 by
ashishvb

Auto populating from one spreadsheet to another

HI there, this is my first question and I am hoping someone can help me please. I am setting up a database in excel and I am an basic to intermedia...

Last reply on 16 Jul 2015 by
vcoolio

Need formula to populate total sales for each employee by month

Hello, Im working on a spreadsheet and i cant come to a formula that works for me. I want to total the amount of apples each employee sold e...

Last reply on 15 Jul 2015 by
Mazzaropi

Get data present in row1 of sheet1 copied into row1 of sheet2

 Solved

Hello, I need to get data present in Row1 of Sheet1(Central OPD) to be copied into row1 of Sheet2(Departmental OPD) based on Department Column of Sh...

Last reply on 15 Jul 2015 by
vcoolio

Copying rows to certain worksheet

Hello, I think i can accomplish this without a macro but can figure it out. I have a project list on sheet1, I would like to copy a projects row to...

Last reply on 15 Jul 2015 by
vcoolio

Last value in a row

Hello, I want a cell which is a summary of the entire row values, but it should display the latest value in the row.Suppose I have entered a value a...

Last reply on 14 Jul 2015 by
Mazzaropi

How do you specify a different location to save the file to?

Hello, I was wondering if you could tell me how to save this file to a different location than where the current file is saved? Configuration: ...

Last reply on 14 Jul 2015 by
TrowaD

Sheet in which the next column gets automatically filled

Hi I need an excel sheet in which the next column gets automatically filled the moment existing cell is filled.Suppose, I have 10 employee names and ...

Last reply on 14 Jul 2015 by
TrowaD

Generating alphanumeric code

Sir, Can anybody help me in writing vba code for excel to generate alphanumeric code having first entry as L,P,G,T(based on a condition), next four...

Last reply on 13 Jul 2015 by
TrowaD

Formula - if c2 is not blank, and b2 is blank, then copy c2 to

 Solved

Hi all - Am looking for help on formula - I want excel to look at cell C2, then if it has anything (text or numbers), then to look at cell b2. If ...

Last reply on 12 Jul 2015 by
Eirualmac

Macro that copies a worksheet, renames it and copies data

I am trying to create a macro that when I select an option from the dropdown list in cell E3 it creates a copy of another sheet in the workbook. ...

Last reply on 9 Jul 2015 by
TrowaD

Transfer data and then apply formula

 Solved

Hello, I have a rather large spreadsheet which records the data from a number of different branches on each separate worksheet (labelled as "branche...

Last reply on 9 Jul 2015 by
Hydro

Command button (vba) to update a record.

Hello, I have created a userform for searching & adding records to a worksheet, but as I am completely new to VBA I am stuck. I wish to create a bu...

Last reply on 8 Jul 2015 by
iceberg51

Convert date into words(english) in excel 2003 or 2007

Hello i 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 Twenty Tw...

Last reply on 7 Jul 2015 by
xpcman

Macro to copy/paste specific range every 3 rows

 Solved

Hello, I am beginner in VBA and now have an Excel sheet with about 4000 rows, where I could need a macro. I already recorded a macro for the fi...

Last reply on 7 Jul 2015 by
Isa

Need urgently to find a macro in excel report across sheets

 Solved

Hi, Anyone a solution? I need a macro that will do the following: 1. Search for a word, a number, ... across all the worksheets in the workbo...

Last reply on 7 Jul 2015 by
moisdois

Change cell by clicking on another cell

Hello, I'm looking for a Macro/Formula to change value of a cell to (the row of the original cell I click on - 2). Is this possible? Cheers al...

Last reply on 7 Jul 2015 by
TrowaD

Excel challenging - please help

Good Day Everyone. I'm stuck on the below situation and your help will be much appreciated. Let's call as: Worksheet] 1: WorkSheet]...

Last reply on 6 Jul 2015 by
gutoazuk

Conditional formatting based on another cell

Hello, I'm trying to make a budget spreadsheet and want to format the cells if there is an omission. If a value has been entered into cell C3 ...

Last reply on 4 Jul 2015 by
Mazzaropi

Need automatically changed amount percentage.

Hello, I need to help to ms excel sheet PERCENTAGE% 0.25 ENTER AMOUNT PERCENTAGE% 25,000.00 AUMATICALLY CHANGE 300000 AUMATI...

Last reply on 3 Jul 2015 by
Mazzaropi

Count if rows contains specific year

Hello, I need to count how many rows contains a date with a specific year, but with the following doesn't work: =COUNT.IF(D3:D3394;"*2014") I cha...

Last reply on 3 Jul 2015 by
Mazzaropi

Insert a row after "," in a cell

Hello, I have a 2 columns such as below: Name Rules John T3456,T4567,T6799 Cersei T5643,T4532 I would like to have a macro that...

Last reply on 2 Jul 2015 by
TrowaD

Checkbox

I'm trying to use an Excel worksheet to take attendance. I've been able to find a solution using Apple's Numbers, but not so with Excel. Any ideas?

Last reply on 2 Jul 2015 by
TrowaD

How to convert number to word in excel using formula

Hello, HOW TO CONVERT NUMBER TO WORD IN EXCEL USING FORMULA Configuration: Windows 7 / Chrome 43.0.2357.130

Last reply on 2 Jul 2015 by
TrowaD

Copying text to different sheets based on criteria

Hello, I have a large speradsheet that records activity. I want to copy a row of items from one sheet to another if the status is 'done'. The if...

Last reply on 2 Jul 2015 by
Ronster444

Apply a number to differentiate cells with same value

Hello, Can someone help me please? Here is my issue. So I have a long list of memberships. The issue I have is that I have one primary member that ...

Last reply on 1 Jul 2015 by
xpcman

How to convert date into words(english) in excel 2003 or 2007

Hello i 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 Two Tho...

Last reply on 30 Jun 2015 by
sankar
Results 2351 - 2400 out of a total of 7,065