The discussions
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...
Popup reminder excel 2010
ClosedI 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...
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...
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. ...
Function in excel 2013
SolvedHello 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...
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...
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 ...
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)) ...
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...
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...
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...
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). ...
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...
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
Transferring data between sheets
Hello, Thanks in advance for reading my question. I am have two excel sheets. The first sheet contains the columns: first name, last name and i...
Coloring line indicated the name, by the table where there is th
Hello, I have four tables with four different colors, are 4 different categories of staff. First with font color blue Second with font color red...
Autofill based on filename in same/different folder.
Hello, I'm looking for a way to pretty much automate part of my job, which is creating manhole sheets. In folder there are 10 files, each is calle...
