## The discussions

### Return value in cell address

Hello, I'm having an issue returning the value cell A32. I have "A32" stored in cell H3 (it was a long drawn out process to isolate the "A32" that i...

1 reply Last reply on 28 Dec 2016 by
Mazzaropi

### Compare data

Hello, I am working on ware house. We have different code for every material which was on system. Every month I need to take physical stock. I need ...

5 replies Last reply on 28 Dec 2016 by
Mazzaropi

### Copy a range of cell x number of times

Hello, Friend my query is I want to copy value from range (E1:F1) Base on the value from G1 And paste on range from A1&B1. It should continue ...

1 reply Last reply on 27 Dec 2016 by
ac3mark

### Transferring data from one sheet to another in excel

I followed the instructions for transferring data between Excel spreadsheets using the +Sheet(X)!((XY) formula. So glad I found your article! This w...

2 replies Last reply on 27 Dec 2016 by
vcoolio

### Popup reminder excel 2010

Closed

I am completely new to VBA and do not really know how to manipulate a code. I was hoping someone would be willing to formulate the codes I need to i...

Last reply on 27 Dec 2016 by
vcoolio

### Excel arrow keys are moving the entire spreadsheet

Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do no...

1 reply Last reply on 26 Dec 2016 by
santa

### Find what is the number, that will make 2 cells abs equal

Hey guys, I will appreciate your help on this. I'm trading on CFD's and trying to build something that will help me calculate different scenarios. ...

3 replies Last reply on 25 Dec 2016 by
yg_be

### Function in excel 2013

Solved

Hello Dear All. who I can do this function in excel 2013 If A2=AB return value from A1 cell , if A2 = CD return from A3 cell value Configuration: W...

1 reply Last reply on 24 Dec 2016 by
yg_be

### Creating different sheets in same workbook from master sheet

Hello, I have data in master sheet from Column A to Column L and about 17,000 rows. Column H contains the name of the sales persons. I have to cre...

1 reply Last reply on 22 Dec 2016 by
TrowaD

### How to spell in euro

Hello, Dear sir / Madam I apologise for my latest message. I need your help concerning the formula to spell in figures that is euro 7000. Which for...

3 replies Last reply on 22 Dec 2016 by
TrowaD

### Any faster version of the same code to handle 5000+ records

Hello, May i plz get a faster code for the same? currently for around 5000+ records this code takes around 10 minutes... i.e. Match all the cellva...

15 replies Last reply on 21 Dec 2016 by
Smallman1

### Moving information from one table to another

I need to move data from one table to another, then loop back through until all the information has been moved, I suck at vba code etc... can any...

3 replies Last reply on 20 Dec 2016 by
ac3mark

### Auto populating from one excel sheet to another

Hello, Hi I am trying to figure out how I can have my employees names and department auto populate in another excel sheet once updated in the master...

1 reply Last reply on 20 Dec 2016 by
TrowaD

### Cell format - countif then subtract from another cell

Solved

Hi, I have a spreadsheet with holidays on. I'm using =COUNTIF(D16:D380,"H") I want to then subtract this number from another cell - What do I need ...

5 replies Last reply on 20 Dec 2016 by
ac3mark

### Markup price

Hello, I am trying to find a formula for that will show the mark up price of a product. Configuration: Windows / Chrome 55.0.2883.87

1 reply Last reply on 19 Dec 2016 by
ac3mark

### Excel macro; automatically add text to number in column

Hello, I am a newbie in excel macro's and I was wondering if anyone could help me. I want to write a macro who once I write a number in a cell of co...

1 reply Last reply on 19 Dec 2016 by
TrowaD

### Need help autopopulating from master list

Hello, I am building a budget and inventory tracking system for a landscape company. I have data that I import from a field service tracking software...

1 reply Last reply on 19 Dec 2016 by
TrowaD

### Private sub worksheet_change(byval target as range)

Hello, please do the needfull.. I am trying to run the below macro,but it is not running,can anyone help me on this please, Private Sub Worksheet_...

1 reply Last reply on 19 Dec 2016 by
TrowaD

### Auto copy info/charts from a master sheet to a second sheet

Hello, I'd appreciate if somebody could please point me in the right direction on this... I'm a sales/supervisor for a rough interior construction ...

1 reply Last reply on 19 Dec 2016 by
TrowaD

### Date format in excel

Hello, i want to know that howcan I change the dateformat in excel 2007 worksheet if I want it like :- 25101990 please give formula & example

1 reply Last reply on 19 Dec 2016 by
SinghAkash

### Generate a serial number for events with dates

Helllo, I have a problem of generating a serial number from an event on the spreadsheet that has date of event and time, amount. how do i get the form...

2 replies Last reply on 18 Dec 2016 by
degree101

### Add a ammount on a certain date.

Hi, I`m trying to add my pension on a certain date each month to a spreadsheet cell. IF((DATE(2016,12, 22) ;then_value(528.08);otherwise_value(0)) ...

1 reply Last reply on 18 Dec 2016 by
yg_be

### Vlookup issue

Hello, Some time in excel i come across the issue that VLookup is not working between two excel sheets. Why it so happen? Pl. resolve the issue b'cz...

1 reply Last reply on 17 Dec 2016 by
yg_be

### If/then formula help

Solved

Hello, I could use some help on the formula below. I need cells in one column (Y) to show specific text ("SEND") if cells in another column (G) has ...

2 replies Last reply on 16 Dec 2016 by
MrJags

### Variable range in vba function formula

Hello, If i want to do this formula ((1/c1)^2+(1/c2)^2 .............................. + (1/c)^2 )^(-0.5) for variable range by ( vba fu...

2 replies Last reply on 15 Dec 2016 by
yg_be

### Date format

Solved

Hello, i am trying to create a report which will show me the first date and last date of the previous month. I need first date in one field and seco...

2 replies Last reply on 14 Dec 2016 by
deakin1980

### Multiple variable formula

Hello, I'm trying to add to the following formula. =IF(AND(G14="Poor",D14

1 reply Last reply on 14 Dec 2016 by
yg_be

### Unique identifier

Good day! I would appreciate if anyone could help me out! I'm a small reseller! I started out with a few items now i have almost one thousand! Is th...

3 replies Last reply on 14 Dec 2016 by
vcoolio

### Building a new spreadsheet using information from another

Solved

Hello everyone, I'm new to the forum and VBA and would like to thank you in advance for your assistance. I have received a spreadsheet that contains...

4 replies Last reply on 13 Dec 2016 by
wtmayoza

### Conditional formating on a drop down list

Hello, I would like to change the result of a option in a drop downlist based on a result from another cell. A1=Optional B1=Green (option in the dr...

3 replies Last reply on 8 Dec 2016 by
ac3mark

### Run macro automatically

Solved

Hello, I wrote a macro and I want to run it automatically if one special cell change but have problem, because contents cell change by formula in oth...

4 replies Last reply on 8 Dec 2016 by
Guest

### Auto tranfer data from one sheet to multiple other sheets.

Hello. Im a beginner in Excel, and I´m going to make day sheets for crew working on a production using Excel. The different crews will need differen...

1 reply Last reply on 8 Dec 2016 by
vcoolio

### Macro copy and paste in next blank cell

Solved

Hi guys, I need some helping in excel macro. I have two sheets in a workbook. Sheet1 is for summary and Sheet2 is for the raw data. I need to update/...

10 replies Last reply on 6 Dec 2016 by
pratheepM7

### Lenovo laptop - arrow keys

Hello, I can toggle between cells on my LENOVO laptop, I DO NOT have a scroll lock button wither. HELP Configuration: Windows / Chrome 55.0.2883.75

1 reply Last reply on 6 Dec 2016 by
TrowaD

### Macro for concatenating and moving data

Hi guys. I have been given a task at work and am after some assistance, or at least a point in the right direction if possible please.  I need to...

2 replies Last reply on 5 Dec 2016 by
psymson

### Transfering data from one sheet to another

Hi all, Nice to be here! I have to transfer data from one sheet to another whenever the status of the case is closed. I have created the dropdown li...

1 reply Last reply on 4 Dec 2016 by
vcoolio

### Automatically copy the values from the active row from sheet

Solved

Hello, Struggling already for a couple of days.... so a help would be more than welcomed Need to write a macro in Excel which would: automaticall...

6 replies Last reply on 4 Dec 2016 by
vcoolio

### Date formats

In Excel, why do I set date format to custom mm/dd/yy yet have to enter the date as yy/mm/dd for it to appear correctly on the worksheet. I used ...

1 reply Last reply on 3 Dec 2016 by
yg_be

### Automatically transfer information from sheet 1 to sheet 2

Hi, How can I automatically transfer data from a cell in Column A in Sheet 1 to Column A in Sheet 2? Once data is copied over into Column A in Sheet...

1 reply Last reply on 2 Dec 2016 by
yg_be

### Column differences

Hi. Thanks for welcoming me to this forum. I have a problem and I am hoping someone here can help me. The problem is as follows: I have 2 worksheet...

1 reply Last reply on 2 Dec 2016 by
yg_be

### Building a macro that allows to pull different year data

I am trying to do the following in excel: I have one master sheet where I have the following columns (name, score, weighting), and the following row...

1 reply Last reply on 1 Dec 2016 by
yg_be

### Macro to copy entire row to next workbook

Solved

Hello, Configuration: Windows 7 / Firefox 50.0 I have the following macro to copy entire row when the column has a capital X. I would like...

10 replies Last reply on 1 Dec 2016 by
ac3mark

### Transfering data from one sheet to another

Hello! I am running my own business. There are many ways my below query help me in my business. I buy raw material for my business like Nickel, Zin...

11 replies Last reply on 1 Dec 2016 by
TrowaD

### Adding a specific number of rows between data change in excel

Hello, please advise on the code for adding a certain number of rows in the excel data at a change in value. I want to add 12 blank rows between th...

1 reply Last reply on 30 Nov 2016 by
yg_be

### A and b column query to provide sum of column c

Solved

Hello and thank you for your help. Please use this scenario for reference: - A B C 1 abc x 1 2 abc y 2...

1 reply Last reply on 29 Nov 2016 by
yg_be

### Search, find & display

Solved

Hello, I have been manually filling out the week no's, in a budget sheet, but want to try and auto populate. I have a table with dates and Week No...

5 replies Last reply on 29 Nov 2016 by
learningenquirer

### Vba help - copying rows into a new sheet, based on 3 characters

Hello Friends, I am looking to build a VBA Macro that extracts the entire row of information based on the first three letters of Column C (Postal). ...

7 replies Last reply on 29 Nov 2016 by
yg_be

### Copy past using vba

I am in Excel trying to copy data from from one worksheet to another. The idea is new data would be added to the next row each time data is added. Eac...

6 replies Last reply on 29 Nov 2016 by
cody-peter

### I want to validate the data format

Hi I need to verify/validate the data in a column, it should be "AAAA-16-0001" format. If the data is not in the specified format, i need to have a...

3 replies Last reply on 29 Nov 2016 by
yg_be

### Excel formula query

Hello, If I enter 1 in column A1 I want column C1 to equal the content of column C2 Configuration: iPad / Safari 9.0

1 reply Last reply on 28 Nov 2016 by
Mazzaropi
Results 1251 - 1300 out of a total of 7,064