The discussions
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...
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...
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...
Nested if functions using time values
SolvedHello, 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...
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...
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...
Cell format - countif then subtract from another cell
SolvedHi, 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 ...
Spell number in india rupee
Hello, I want spell number in India rupee.
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
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...
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...
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_...
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 ...
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
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...
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)) ...
It not work and want the solution this problem please """"
ClosedHello, But the words is not changing Configuration: iPhone / Safari 4.0
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...
If/then formula help
SolvedHello, 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 ...
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...
Date format
SolvedHello, 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...
Multiple variable formula
Hello, I'm trying to add to the following formula. =IF(AND(G14="Poor",D14
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...
Building a new spreadsheet using information from another
SolvedHello 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...
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...
Lost password
Hello, in lost my email password how can i recoveer it Configuration: Windows / Chrome 54.0.2840.99
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...
Run macro automatically
SolvedHello, 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...
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...
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 ...
Macro copy and paste in next blank cell
SolvedHi 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/...
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
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...
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...
Automatically copy the values from the active row from sheet
SolvedHello, 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...
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. ...
How to fix 'cannot attach a file in outlook'
Solved/ClosedHi 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...
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 ...
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...
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...
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...
Macro to copy entire row to next workbook
SolvedHello, 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...
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...
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...
A and b column query to provide sum of column c
SolvedHello and thank you for your help. Please use this scenario for reference: - A B C 1 abc x 1 2 abc y 2...
Search, find & display
SolvedHello, 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...
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). ...
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?
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...
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...
