The discussions

Auto copy row from one sheet to another via info in first cell

 Solved

Hello everyone, hope you all had a great New Year. I am in the process of exporting a BOM out of Inventor and then opening it with Excel. Once I ha...

10 replies Last reply on 25 Jan 2016 by
TrowaD

Creating a summary sheet

Hello, I have a worksheet that is recording customer interactions, and I would like to create a seperate sheet to summarize all the customers that ...

1 reply Last reply on 23 Jan 2016 by
vcoolio

Desktop publisher

Hi, I have just installed Open Office in my Dell Optiplex 755 and I wanted to work on a booklet - it seems not working well with me. Any idea plea...

1 reply Last reply on 23 Jan 2016 by
Ambucias

Button to copy sum to next row on another sheet

Hi, I think i have almost go this (pretty new with vba). On first sheet 'comparison' i have a few variables which can be changed then the sum of...

3 replies Last reply on 22 Jan 2016 by
vcoolio

Barcode help!!

Hello, I am making a barcode system and I want to be able to display the information given in the barcode in the cells next to it. For example I a...

2 replies Last reply on 22 Jan 2016 by
ac3mark

How do i exclude a value when using counta?

Hello, I am currently using the following formula to count cells that are not empty =COUNTA (D4:D17) However in this range there are certain...

1 reply Last reply on 22 Jan 2016 by
RayH

Automatic transfer of data

Dear CCM, I have a sheet with combined values for different units and I manually sort into the different units manually by copying and pasting into ...

1 reply Last reply on 22 Jan 2016 by
vcoolio

Excel

Hello, if the column a and column b are equal, i want to put "-"(minus sign) before the data of column b for further technical purpose. eg. it lo...

1 reply Last reply on 22 Jan 2016 by
vcoolio

Vba: creating new sheets based on copy, nameing them the cells

Ok, i am gonna try to be so clear i can. on Sheet 1 (Start Sida) i have a list from cells A9 to A500 with names. atm only A9-A52 have names in them. ...

1 reply Last reply on 22 Jan 2016 by
vcoolio

How can i multiply a numeric value and alphabetic value in exce?

Hello,plz answer as soon as possible

1 reply Last reply on 21 Jan 2016 by
ac3mark

Difficult query

 Closed

Hello, I would like to request for a difficult query that may be not solvable logically. If user enter az123456789 or az-123456789 it always co...

Last reply on 21 Jan 2016 by
TrowaD

Automatically transfer data from one worksheet to various others

Hi, I am trying to figure out how to automatically transfer data from one excel worksheet to another worksheet but only when a specific cell(s) ar...

1 reply Last reply on 21 Jan 2016 by
vcoolio

Automatically transfering data after generating new worksheets

Hello, It has been a while since I have worked with code and would appreciate any help. I have one code already working which is gathering all ...

3 replies Last reply on 21 Jan 2016 by
vcoolio

Search and copy..

I have two Work Books open and I have filters on both WBs.. Let's say I have filters for Name, Birth Date, Address, and Phone# for both WBs. Is it pos...

3 replies Last reply on 20 Jan 2016 by
ac3mark

Macro to rename tabs based on cell reference on another sheet

Hello, I am attempting to rename 5 sheets in a workbook based on values from a sheet titled Raw Data Information. The first sheet should be named bas...

1 reply Last reply on 20 Jan 2016 by
ac3mark

When i transfer my pst file, not all of my files/folders transfe

Hello, I am copying over my pst file into an exchange database, I have been able to transfer over all files except two. These two files come up wi...

1 reply Last reply on 20 Jan 2016 by
ac3mark

Countdown in excel

Hi, I'm a bit of a formula novice in excel. I have been googling, but not sure if I'm typing in the right questions, or if what I want to do is eve...

1 reply Last reply on 20 Jan 2016 by
ac3mark

How to combine 2 formulas in one box?

Hello, I would gladly appreciate any advice on how to finish or redo my formula. I have most of my formula but I can not figure out how to do the la...

2 replies Last reply on 19 Jan 2016 by
stargazer

Automatically copy the row into the appropriate sheet

Hi everyone. I've set up an excel 2010 workbook to log maintenance repairs through the hotel. sheet 1 is an ongoing log of 5 columns. A= location ...

1 reply Last reply on 18 Jan 2016 by
vcoolio

Excel filter/macro

 Solved

Hello, Thank you in advance for any time/help you can offer! I'm working on a contact list in Excel and I need to be able to filter my contacts i...

4 replies Last reply on 15 Jan 2016 by
vcoolio

Run-time error with copy-and-insert rows macro

Hi, I am using the following macro to copy and insert rows in an Excel spreadsheet, based on a user inputted value. I place the cursor in the desire...

12 replies Last reply on 15 Jan 2016 by
Greg

Can't open microsoft office

Hello, i just install the business in box app to see an example of a document. but then there's something wrong with the Microsoft office. i fou...

1 reply Last reply on 15 Jan 2016 by
Ambucias

Colours for dates that are on 2 & 3 month cycles

Hello, In my current role, I have a number of people that I have to assess. I would like to be able to do the below so i can easily identify who i...

1 reply Last reply on 14 Jan 2016 by
ac3mark

Columns & rows help

 Solved

Hello all, In short, here is what I need help doing: I would like to take 15 items in one column and transfer them into a row in another spread...

5 replies Last reply on 14 Jan 2016 by
futurepsych92

Formula for if cell contains word, assign value for multiple

Hello, I am looking for a formula to help me assign a value for multiple words and values. If column A has the contains Apple, assign X. IF i...

1 reply Last reply on 14 Jan 2016 by
ac3mark

Excel conditional formatting

Hi All, I need your help with conditional formatting please? I've a project timeline on a week and month calendar form. I've applied conditiona...

3 replies Last reply on 14 Jan 2016 by
TrowaD

Need to search an excel spreadsheet column

but hoping I'm wrong? Need to search an excel spreadsheet column (say column D) for all rows with the text "3 Pounds" If the text is found in a cel...

1 reply Last reply on 13 Jan 2016 by
heyhere

Formula if you have credit in one column, debit in next column

 Solved

Hello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column. Many thanks R Horner Configurat...

4 replies Last reply on 13 Jan 2016 by
Jackthelad

Macros invoicing drop down list

Hello, Hope everyone it doing well. I am looking for some help with Excel 2010. I have a template that I use to invoice my customers. My customer ...

1 reply Last reply on 12 Jan 2016 by
ac3mark

How excel displays ascending order of data in other spreadsheet

hello, I try to prepare data of students details with random serial no.s in one excel spreadsheet. How I link it to display ascending order i.e.sma...

1 reply Last reply on 12 Jan 2016 by
TrowaD

Data subsets and duplicates

Hello, I have been trying to find the answer in a few forums but haven't found quite what I'm looking for. I have a column (A) of around 2000 n...

1 reply Last reply on 12 Jan 2016 by
TrowaD

Need a cell to change colour if another cell has an 'x

hello, i need a cell to change colour if another cell has an 'x' in it. so if cell r14 has an x in it cell r13 turns green can anyone help? tha...

1 reply Last reply on 12 Jan 2016 by
vcoolio

Excel conditional formatting w/date range and containing text

Hello, I need to make a conditional format based on the date in a cell being between 30-60 days past today's date and only if another cell contain...

2 replies Last reply on 12 Jan 2016 by
Dani

How to link my mail id

Dear Sir/Maám actually our company is secured our intra so please give istruction how to open my mail id thanks,

1 reply Last reply on 12 Jan 2016 by
BunoCS

Help with sumif function please..

Could someone please help me?? I need to sum the values of a range of cells that contain certain text (product codes) into another cell. For example...

1 reply Last reply on 9 Jan 2016 by
aquarelle

If condition

if a2=mathura then result plm a2=agra and b2

1 reply Last reply on 9 Jan 2016 by
aquarelle

How to re/name a cell if another cell contains x

 Solved

Hello, Apologies if this is a simple question but having some trouble figuring it out. I have say 1000 rows of data and I need to label them all...

5 replies Last reply on 8 Jan 2016 by
vcoolio

Data arrangement

Hello, I have 2 sheets in an Excel workbook. I am trying to code certain cells in a pre-made template on Sheet 1 to automatically sync with my dat...

1 reply Last reply on 8 Jan 2016 by
vcoolio

Fill in automatically

Hello, I have two colum in excel sheet colum A1 contain big list of job titles each one of it have a code for example: Job Title name ...

2 replies Last reply on 7 Jan 2016 by
iSaeed11

Daimary

Please accept me.

1 reply Last reply on 6 Jan 2016 by
Ambucias

Macro help

Hello All, In short, this is the issue I am facing: I have created a macro to copy and paste data from one spreadsheet to another. Specifically,...

2 replies Last reply on 6 Jan 2016 by
futurepsych92

Copy data from 2 sheets in 1 workbook to new workbook

Hello, I am new to macros in Excel and could use any help. I want to copy the basic name and customer info from 1 sheet(1) and create a new workb...

2 replies Last reply on 6 Jan 2016 by
DoubleDDD

Can i get the autofilter to work automatically without

I have the following which is filter my data based on a cell: Private Sub Worksheet_selectionchange(ByVal Target As Range) If (Intersect(Target...

3 replies Last reply on 6 Jan 2016 by
Matt

How to transpose and move data

Hello, Have a data set which is 2 columns and 596 rows, in which I need to transpose parts of the data set, remove empty columns, and then line up...

2 replies Last reply on 6 Jan 2016 by
Alex

Conditional data display depending on a dropdown list

Hello, I would like to creat a form which would display certain data dependent on what was chosen in a dropdown list. For example, if my dropdown...

3 replies Last reply on 6 Jan 2016 by
rizvisa1

If formula query

Hi there, I have a spreadsheet which using the IF formula should be bringing back either "update Required" or "N/A" depending on if the date in the...

1 reply Last reply on 5 Jan 2016 by
rizvisa1

Data consolidation

Dears Need your expertise advice. I have an excel data in below format , need a formula Column 1 has text like ABA, ABA , ABB, ABC, ABC, ABC . ...

8 replies Last reply on 5 Jan 2016 by
rizvisa1

Transfering data for a spreadsheet to another

Its not working. May be size (row height & Column Width) not same. Is there any other way to solve this problem.

3 replies Last reply on 4 Jan 2016 by
ep2789ccm

Auto-copy cells one to another + formation too

 Closed

Hi! I want to make intelligent excel, like.. i have many sheets and i want it to work the way, that sheet2 takes data from sheet1. so 1) ...

Last reply on 3 Jan 2016 by
nullun

Strike through when entering date

 Solved

Hello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last d...

3 replies Last reply on 2 Jan 2016 by
vcoolio
Results 2401 - 2450 out of a total of 12,267