The discussions

How can i transfer data in a row in a work book to another book

Hi, I will be downloading data each day which consists 150 rows. Each row contains a data set pertaining to an individual item. Each of these ite...

2 replies Last reply on 15 Nov 2013 by
bull2013

Finding a subset

Please help me to find subset of A=(1-39). All subsets should be having six (6) numbers, e.g (1,2,3,4,5,6), (1,4,7,23,34,39), (2,8,9,21,29,30). Or hel...

1 reply Last reply on 15 Nov 2013 by
rizvisa1

Archiving an order

Hello, Hi all, I wonder if anyone can help, I am trying to make a macro that will archive an invoice before the next order. Thanks for any help...

1 reply Last reply on 14 Nov 2013 by
ac3mark

Link data with image

Hello, I have C:\Photo folder with all jpeg images. All the names are unique and exactly matches with my product code number. In excel 2007 ...

3 replies Last reply on 13 Nov 2013 by
rizvisa1

Automatically transfering data from one worksheet to another

On excel is there any way you can get rows to move over automatically if their status changes?? So for example on a spreadsheet if you had a list of v...

1 reply Last reply on 12 Nov 2013 by
TrowaD

Autofill of information from another worksheet

Hi! I am currently making a report wherein I need for the information from another worksheet to be automatically inputted once the code is typed in...

1 reply Last reply on 12 Nov 2013 by
TrowaD

Conditional formatting analyzing the a range of cells

Hello, I have an excel workbook with multiple tabs that contain many internal checks. Therefore, I created a "summary tab" that uses conditional ...

1 reply Last reply on 12 Nov 2013 by
TrowaD

Merging two excel sheets

Hello guys im totally new here and i want to ask a question. I have two excel sheets that i want to merge. Let me explain what i want to do and i ho...

11 replies Last reply on 12 Nov 2013 by
TrowaD

Conditional formatting for a range

Hi! I am working on a file where I have to format the cells in one column based on a list place in the same sheet in a different column. Basically...

1 reply Last reply on 10 Nov 2013 by
rizvisa1

Duplication

Hi, I a have a column A i.e names . for ex. 1 Row shailendra, 2 Row sailendra, 3 Row shylendra. above (3) names are same but spelling change now i...

2 replies Last reply on 10 Nov 2013 by
9000966

Dating problem!

 Solved

Hi Can you help? I need a cell to only input if a lead cell is blank but if the lead cell has a date format i.e 24/11/13 then to input that sam...

6 replies Last reply on 8 Nov 2013 by
rbmastertitan

Matching data from two spreadsheets

I have 2 spreadwheets. One is a master equipment list with info stored according to Equipment #. The second is an invoice for equipment that is on th...

1 reply Last reply on 7 Nov 2013 by
venkat1926

How to add a value to a cell if the other cell has text

Hi, i am not able to find how to do the following formula in excel. what is the exact formula for: "if the value of the cell A2 is text then t...

5 replies Last reply on 7 Nov 2013 by
ac3mark

Link image as per cell value : complicated

The explanation of the required details is in the attached sheet itself http://speedy.sh/M5SHA/Images.xlsm regards Pooja

2 replies Last reply on 7 Nov 2013 by
BunoCS

Hide/unhide an autoshape or picture in excel

 Solved

Hi All, Could anyone tell me the method to Hide/Unhide an Autoshape or Picture in Excel Spreadsheet? I know it is possible through Macro Codes, an...

6 replies Last reply on 7 Nov 2013 by
jerangkung

Conditional formatting of a cell if another cell is blank

Hello, All i am challenged in resolving the following problem I have and am hopefull that someone can help in Column E I have specific text "tier ...

4 replies Last reply on 7 Nov 2013 by
venkat1926

Trying to copy data from one sheet to another and rearrange

I have an Excel sheet, and I need to clean the data and copy it to another sheet. The cells change by 11 between records. I tried creating the initial...

1 reply Last reply on 6 Nov 2013 by
wakesk8

Need to copy a whole sheet into another

Working with 2 sheets, one as the invoice and the second as the master record. Everything entered into the invoice will be automatically copied into t...

1 reply Last reply on 5 Nov 2013 by
TrowaD

Excel count sheets in a workbook

how to count the no of sheets in my workbook, like a list or whatever, also get the sheet name against it,

1 reply Last reply on 5 Nov 2013 by
ac3mark

Excel how to change to value

Please help me to change this data which is highlighted in Yellow color to the other cell in values.. i cannot do any calculations on it...

1 reply Last reply on 5 Nov 2013 by
ac3mark

Excel if statement using time

Hello, I am trying to do some conditional formatting using if statement. I have a spreadsheet that is supposed to flag targets based on a 24hr clo...

1 reply Last reply on 5 Nov 2013 by
Kevin@Radstock

Nested and/if statments

 Solved

Hello and good day. I am in the process of putting together an annual bonus/vacation accural sheet and need some assistance with building a comple...

3 replies Last reply on 4 Nov 2013 by
nelsojm

Excel worksheet auto generator

 Solved

Hello, i have a workbook with a names sheet that has all the info I need put onto timecard and a master sheet with the timecard that the employee wil...

10 replies Last reply on 1 Nov 2013 by
rizvisa1

Conversion of excel files to dbf files

need to convert excel (win 7) to dbf what software options are available

3 replies Last reply on 1 Nov 2013 by
ClarkShane

Formula to count if cells in consecutive columns are populated

Hello, I need an equation that will return a 1 in column F if data is available (cell is populated) in 2013 or last two years (2012 & 2013) or las...

1 reply Last reply on 1 Nov 2013 by
venkat1926

Need help with lookup? or if? command

 Solved

Hi Everyone, Can someone help me with a command or macro that will look up the price of a product in a country from a reference worksheet and then fi...

3 replies Last reply on 31 Oct 2013 by
nycm

Formula needed.

Hi dear i am looking for an formula that can resolve the following issue. I have a table of: Actual...............................................

2 replies Last reply on 31 Oct 2013 by
Kevin@Radstock

Compare cells of two columns excel 2007

 Solved

Hello, I have two columns with identical cells and I need to find those that are not the same. For example: Column1 Cell1 = "a", Column2 Cell1 = "...

5 replies Last reply on 31 Oct 2013 by
Rajen

Cap-locks

Hello, Is there a way to make a spreadsheet only type in all caps? Configuration: Windows 7 / Internet Explorer 10.0

1 reply Last reply on 31 Oct 2013 by
TrowaD

Conditional formatting

 Solved

I need a formula stating that if cell R7 is blank, then Q7 is yellow. So if anything is entered in R7 then the cell Q7 is no color

6 replies Last reply on 31 Oct 2013 by
KGRIFFITH

Excel enter key

Viewed your site to advise how to press the enter key and have the cursor move right in lieu of down as it is doing now. The instructions listed ...

1 reply Last reply on 31 Oct 2013 by
venkat1926

Copying data into a master spreadsheet

Hi i am trying to copy different worksheets on to a complete worksheet, i have recorded a macro but it doesn't collect any new information, how do i m...

1 reply Last reply on 29 Oct 2013 by
TrowaD

Formula help

I have a huge excel spreadsheet that I am needing to sort by type of loan (J3:J132) and then select the totals from that type of loan (D3:D132) and to...

1 reply Last reply on 29 Oct 2013 by
TrowaD

Help with major excel problem

Please help with the problem if you can I have a single column of data numbering in 650k The Problem I have here is within this column I have com...

5 replies Last reply on 29 Oct 2013 by
TrowaD

Need macro- copy row and insert 10 times

 Solved

Hello, I have a similar question as this previous thread: https://ccm.net/forum/affich-107673-copy-row-and-insert-n-times but I'm not sure which ...

2 replies Last reply on 29 Oct 2013 by
nycm

Delete selected data in excel 2007

Attached a link which will give the details http://speedy.sh/bQWZM/OutletsCode.xlsm thanks JS Desai

2 replies Last reply on 28 Oct 2013 by
JS Desai

Attach and excel file in kioskea

can you send me a stepwise info to attach an excel file. I am new to Kioskea and do not see any button or option. I have a question but need to at...

2 replies Last reply on 27 Oct 2013 by
JS Desai

Looking for a excel formula.

Hello, i have rate sheet of 20,000 entries. rate sheet have data like this. ---------Rate-1------Rate-2-------Rate-3 A-------0.16211 B-----...

4 replies Last reply on 26 Oct 2013 by
ahamaz

How do i create a seperate .xlsm workbook for each list item?

Here is the data: A B C 1 Data1 Data2 Data3 2 0002 ABC $3.00 3 0002 ABC $4.00 ...

1 reply Last reply on 26 Oct 2013 by
venkat1926

Excel to find a word within a cell within a sentance

2 things... 1. I need to find a word (several individual words actually) within a cell that is part of a sentence. The search will need to cover...

4 replies Last reply on 25 Oct 2013 by
venkat1926

How do i change the formula based on text in another cell...

Example: In column C, I have either "C&D", "Concrete", "Dirt", or "Asphalt". Column D is a weight. Column E is the weight *$30 for "C&D" only....

1 reply Last reply on 25 Oct 2013 by
ac3mark

Using vba to assess the result of different input variables

Hello, I have absolutely no idea how to go about this problem, and my VBA skills are quite weak. I have this data, consisting of 3 columns and a n...

1 reply Last reply on 25 Oct 2013 by
venkat1926

Add blank rows

Hello, I am facing a problem in my excel sheet. i shall highly grateful to you if kindly give me a solution to my problem. In b column of the sheet ,...

3 replies Last reply on 25 Oct 2013 by
venkat1926

Excel vba

 Solved

Hi all, Greetings, could I get help, I am trying to write data into cells in a spread sheet, using an initial value, then adding a specific increme...

5 replies Last reply on 24 Oct 2013 by
ugo234

Yes or no...if so....

 Solved

Hi I need to ask a cell to do two functions. So if a cell (drop down list) has yes/no...then another cell will.....when yes is selected then d...

2 replies Last reply on 24 Oct 2013 by
Tim

Regarding email notification in excel 2010

Hello, I am preparing a sheet for my company leaves and in this sheet I want users to put their leave date and once they make changes in the leave it...

1 reply Last reply on 23 Oct 2013 by
ac3mark

Changing date format

i am unable to change my date format in excel sheet. please help me

1 reply Last reply on 23 Oct 2013 by
ac3mark

Converting rows of data into columns

 Solved

Hi everyone, I hope you all can help. I have a file in with 17,000 lines of data in rows that I need converted into columns. I don't work with Ex...

3 replies Last reply on 22 Oct 2013 by
chuaf24

How can i create a macro for a new spreadsheet

Hi I need to create a Macro that generates a new spreadsheet based on the values that have an X on the third column. Here is an example of the data. ...

1 reply Last reply on 21 Oct 2013 by
ac3mark

Macro to traspose data

 Solved

Hi I need a help I need to transpose my data following way for a longitudinal analysis; ID Day1 Day2 Day3 Day4 Day5 Day...

5 replies Last reply on 21 Oct 2013 by
TrowaD
Results 3501 - 3550 out of a total of 7,066