The discussions

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

Nested if functions using time values

 Solved

Hello, can someone tell why this wont work. The time value functions work separately on their own, and I followed the excel help for nested if func...

5 replies Last reply on 21 Dec 2016 by
Harshada Chaudhari

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

Spell number in india rupee

Hello, I want spell number in India rupee.

1 reply Last reply on 20 Dec 2016 by
TrowaD

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

It not work and want the solution this problem please """"

 Closed

Hello, But the words is not changing Configuration: iPhone / Safari 4.0

1 reply Last reply on 18 Dec 2016 by
BrianGreen

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

Lost password

Hello, in lost my email password how can i recoveer it Configuration: Windows / Chrome 54.0.2840.99

1 reply Last reply on 8 Dec 2016 by
xpcman

Tally

hello... I have 2 Laptops one works under windows 7 & another s OS is windows 10. tally erp 9 was working fine in OS 7, but in windows 10 though tall...

1 reply Last reply on 8 Dec 2016 by
kieferschild

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

Microsoft office word office open xml file hmc 10 cannot be open

the office open xml file hmc 10 cannot be opened because there are problems with the contents how to fix this error. I tryed lots of solutions to fix ...

29 replies Last reply on 7 Dec 2016 by
Ambucias

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

Can't log in to my email using my phone

Hello, For almost a week now, I have not able to log in to my email account using my phone. they keep telling me that they failed to authenticate. ...

1 reply Last reply on 4 Dec 2016 by
Ambucias

How to fix 'cannot attach a file in outlook'

 Solved/Closed

Hi team I find your website very helpful so I am returning the help - After searching the web and trying to resolve the above problem for hours, I fo...

1 reply Last reply on 4 Dec 2016 by
Ambucias

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

How to insert video into powerpoint?

I want to spruce up my PowerPoint presentations with some local videoo, but I have no idea how to make that. Any suggestions?

1 reply Last reply on 29 Nov 2016 by
cody-peter

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

Help! cant open open office

I'm using Windows 7. Thanks. Larry

1 reply Last reply on 29 Nov 2016 by
Ambucias

Outlook .ost is in use

Hello, After I have installed Office Suite Service, i tried to start Outlook 2007. But when i attempted to start it a pop-up box stating: Outlook .o...

3 replies Last reply on 28 Nov 2016 by
cemerson22
Results 1601 - 1650 out of a total of 12,259