Excel Forum
-
Auto copy and paste cell range to a separate sheet Solved/Closed
Hello, I am new to VBA/Macro with excel, but I want my code to automatically copy a range of cells in the same row that a change is made in a particu...
-
Need to create multiple tabs based on data in table Solved/Closed
Good Afternoon, I'm trying to find a way to automate a few things to save some time: -Use the data in an input tab to create multiple tabs/documents...
-
Copy cell from a column into multiple worksheets Closed
Good Afternoon! I've got a column of data (Months) that I need to insert into a cell in multiple worksheets. I know if it was within one worksheet...
-
Return Value in Cell Address Closed
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...
-
Compare Data Closed
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 ...
-
How To Copy Data Between Several Sheets using another sheet Closed
Hi All, I have a requirement to copy the data from source to target using macro excel file name: Testbook1 Source sheets Target sheets Test_Src1...
-
how to delete misline rows one worksheet by using macro Closed
Hello, how to delete misline cloums by using macro plz give me code.i hoping you give me answer.
-
Copy a range of cell x number of times Closed
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 ...
-
transferring data from one sheet to another in Excel Closed
I followed the instructions for transferring data between Excel spreadsheets using the +Sheet(X)!((XY) formula. So glad I found your article! This w...
-
Excel changes field format from date to text when date entered. Closed
I have an Excel worksheet that has a variety of formula's and conditional formating in it. There are four different date formated columns in the spre...
-
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...
-
excel arrow keys are moving the entire spreadsheet Closed
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...
-
how to copy row to several sheets based on cell value Closed
Hi Ladies and Gents i really hope i can get some help here and your patience and support is highly apreciated. i have a daily tracker for all daily ...
-
Find what is the number, that will make 2 cells ABS equal Closed
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. ...
-
Comparing and scoring 2 workbooks for students quiz Closed
Hi all I am teaching students basic Excel skills and they have a quiz to do where they do certain basic tasks on a spreadsheet. I have a workbook wi...
-
function in excel 2013 Solved/Closed
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...
-
find what is the number, that will make 2 cells ABS equal Closed
Hey guys, I'm trading on CFD's and trying to build something that will help me calculate different scenarios. As you can see on the file attached, I...
-
sum if.. it think? Closed
Hi, I have a column of cells that may contain either a 1 or 2 or.5 I need to add the column together and get a 1 to equal 15min, 2 to equal 25min a...
-
Copy all data from 2 worksheets into summary, excluding headings Closed
Hello, I would like to automatically copy the entire rows of 2 different worksheets (excluding the top 3 header rows) into one complete summary work...
-
How to compare data between two worksheets, Closed
Hi I have "sheet A", and "sheet B". I need to match the information in sheet A with sheet B and select the information needed from sheet B and writ...
-
macro to create a new sheet by copying a template from a list Closed
i have two sheets one is "profile" and second is "template" . this second sheet has a defined layout. in the first sheet i.e profile sheet contains a...
-
creating different sheets in same workbook from master sheet Closed
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 Closed
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 Closed
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 Closed
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...
-
Automatic inserting a picture in a cell field Closed
Hello, I have maybe big unsolved problem. My question is how automatically insert picture to cell field, for example B1:H40, on condition that cell ...
-
Auto populating from one excel sheet to another Closed
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 Solved/Closed
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 ...
-
markup price Closed
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
-
Save Group of Reports as PDF Macro Closed
Hello, I created a sheet that pulls from other sheets in my workbook to create a report. When one cell value is changed, the entire report on my mai...
-
excel macro; automatically add text to number in column Closed
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 Closed
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) Closed
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 Closed
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 Closed
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 Closed
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. Closed
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 Closed
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 Solved/Closed
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 ...
-
variable range in vba function formula Closed
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 Solved/Closed
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...
-
Multiple Variable Formula Closed
Hello, I'm trying to add to the following formula. =IF(AND(G14="Poor",D14
-
Unique identifier Closed
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...
-
I want to fetch data from another work book with help VBA/Macro Closed
Hi, I have a master file with team members name in one column, and I create a sheet for Managers with only given name (same format) in one column and...
-
EXCEL 2013 :Searching for text and display a different value. Solved/Closed
I am fairly new at this, but I work in excel files that are extracted from out problem management system. I created a formula that will look for a key...
-
Building a new spreadsheet using information from another Solved/Closed
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...
-
Change Date Format Closed
Hello, I need to analyse some dates, only problem is that they are displayed as: Fri, 19 Aug 2011 19:28:17 -0000 Excel won't recognise them as dat...
-
Excel function Closed
Hello, Am looking for a formula which can be used to find the fund name from the subject line For eg. xyz capital market ltd-fund name Subject lin...
-
Conditional data copying Closed
Hello, I require assistance in allocating employee codes to a specific PC. Those Employee codes are available in Pivots and i have to change date a...
-
Need macro code to make a report with 5 files on daily things Closed
Hello, Please, can any one help me on this task, it would be great pleasure , I need a macro code to make a report with data in 5 different files o...
