Excel Forum
-
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...
-
Need macro code to make a report with 5 files on daily basis [Closed]
Hello, Need macro code to make a report with 5 files on daily basis such as open tickets report and resolved tickets....into a master file to track ...
-
Conditional Formating on a drop down list [Closed]
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 [Solved/Closed]
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...
-
Auto tranfer data from one sheet to multiple other sheets. [Closed]
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...
-
how to change cell name through to color [Closed]
hi i am unable to change cell name according to another cell color is negative for exp: if cell a1 is red color so cell b1 showing "c" if cell a1 ...
-
Sum if [Closed]
Hello, I am trying to create a formula to calculate my time cards at work I have afternoon shift, night shift, Saturday, Sunday etc etc. On a Frid...
-
(Heading)If cell contains text, format cell+5 cells to the right [Closed]
Hello, I have a worksheet which has several different sub-headings, occurring at different rows and columns in the sheet. I want to format the row o...
-
Create different excel files with different collums information [Closed]
Hello, 1st Excel spreadsheet with 10 rows and 10 column of data. 2nd Excel spreadsheet with a layout with merged boxes, colors, names etc. Can I cr...
-
i cannot run Private Sub Worksheet_Change(ByVal Target As Range) [Closed]
Hello, i am trying to run the below code, Private Sub Worksheet_Change(ByVal Target As Range) Dim selectedValue As String Dim templateValues As S...
-
Excel not changing time format to 24 hr format [Closed]
Hello, I have exported ddata from ServiceNow into an Excel spreadsheet. The Created field shows as mm\dd\yyyy hh:mm:ss. I need to separate the fie...
-
Excel VBA [Closed]
Hey all, Firstly - apologies, I haven't even got a base code - because frankly I am hopeless..... What I want to achieve - I will be running a weekl...
-
Macro to write doi(Digital Objec information on the excel sheet [Closed]
Dear All, I have a list of DOIs on a excel sheet and I want to write details (Journal name, vol no, issue no, page numbers) on the same sheet - just ...
-
Macro copy and paste in next blank cell [Solved/Closed]
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/...
-
Lenovo Laptop - Arrow keys [Closed]
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 [Closed]
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...
-
macro to extract specifc data [Closed]
So ive been tasked with creating a customer database. Our intranet has our customers listed by there name and then a email and phone number. Sad part ...
-
Transfering data from one sheet to another [Closed]
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 [Solved/Closed]
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...
-
Date Formats [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Solved/Closed]
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...
-
Macros / VBA - Sending Rows to New Sheet [Closed]
Hi All-- New to programming, trying to make an efficient Excel program to use to sort and send certain data to certain sections of a separate sheet. ...
-
Column differences [Closed]
Hi. I have 2 worksheets. There are around 36000 rows of products on each sheet, although the sheets are not an exact match ie there are some product...
-
Transfering data from one sheet to another [Closed]
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...
-
Auto Populate Master datasheet [Closed]
Hello, I am trying to build a master data worksheet that initially contains about 5000 records that updates from the data entered into 7 separated w...
-
Email Notifications from the Work Book [Closed]
Dear Any one help me on the below I had a workbook with 3 to 4 sheets in it. if some is changing or updating in anyone of the sheet. i need to get t...
-
Compare Value Randomly [Closed]
Hello, Hello, I have 4 columns: vendor_url reprice_sku Item ID URL for Item ID URL1 2...
-
Adding a specific number of rows between data change in excel [Closed]
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...
-
embarrassing [Closed]
Data is automatically (or unintentionally) are copied from one worksheet to another taking up time and memory. How can I prevent Excel do this? Is the...
-
A and B column query to provide Sum of column C [Solved/Closed]
Hello 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 [Solved/Closed]
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...
-
VBA Help - Copying Rows into a new sheet, based on 3 Characters [Closed]
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). ...
