Excel Forum
-
How to convert existing date to another date format Closed
Hello, I want to convert existing date like- 18.5.2014 to another date format like- 18 May, 2014. Existing Scenario is- 18.05.2014 19.05.2...
-
change the date format Closed
Hello, i wanna change the date format where the date is 10/5/2014 bur when i tried to filter month wise excel is taking it as 5th Oct'14 Config...
-
a table that filter makes problems Closed
Hi everyone, i dont know why but every time i filter something the whole screen goes blank. Any ideas? Thanks in advance!
-
How to transfer current data from one sheet to another sheet Closed
I have two sheets. The first sheet contains several columns for various vehicles wherein the first column is intended for the dates. Everyday I have t...
-
How to transfer current data from one sheet to another sheet Closed
Please refer to the figure below: My problem is that I want to see in Sheet 2 under column C the updated Odometer reading that I entered in S...
-
Highlight only if drop down menu changes? Excel 2010 Closed
Hello, I am trying to format my sheet so that it will highlight the cell only if my drop down menu changes from one value to another. I know how t...
-
error in macro search Closed
I made a vba macro to retrieve data from a database in Excel. if the data is not found; I get an error message and I have to restart the macro again. ...
-
return textbox value by combobox Closed
hi i have a combobox and a textbox.i want a vba to perform counting filtered range based on a the combox selected value.thanx in advance.
-
how to insert/add zero before a format of number Closed
i have an excel sheet in which column A contains value like a)1344.0001, b)1344.001, c)344.001, d)1344 i want all my information to be in 000...
-
Conditional formatting Closed
This is my first post and I need some help please. How can I format excel so that if E3 ="STO" then I3 Formula =F2*100*G2-H2, IF NOT I3=F2*100*G2+H2....
-
Copy data from old excel file (97-2003) to the new file (2007) Closed
Hello, Pls, could someone advise me. I cannot Copy data from old version excel file (97-2003) to the new version excel 2007 sheet. The optio...
-
Quote- Conditional automatic copy from sheet 2-4 back to sheet 1 Closed
Hi, does anyone know how to do the following. I want to automatically copy a product description and number of items to a front quote page (sheet 1) ...
-
formula for my result card pleaz Closed
Hello, MAdam i want position farmula for my result card pleaz if u help me than i m thanked for this given data is Name Eng Urdu Math's En...
-
how change date format in excel Closed
Hello, how to change and edit in date format dd/mm/yyyy in excel
-
Sum a cell with both numbers and alpha text Closed
Is there a way to add multiple cells that contain numbers but also contain alpha text?
-
Data Selection Closed
Hello, I am looking for a macro or formula in excel to select some information according to the same criteria: eg. from this table A 3.32 10 12 ...
-
Copying from master 'list' to new workbook Closed
Hello, I have an patient excel workbook which contains client columns for last name, first name, etc, and a (text) column titled 1:1, which contai...
-
Conditional formatting Closed
Hello, Would anyone know how to make this work in conditional formatting: =COUNTIFS(G1:K8,5,A1:E8,">=30")
-
How to format cells based on the text in another cell Solved/Closed
Help me! I'm trying to conditionally format multiple cells based on different texts entered in another. For example: I have selected certain cells to...
-
Create new sheets with template using data tab Closed
Hi, I'm a little new to macros but I'm making some progress. Basically what I need to do is create new sheets for each line of data, but I want tha...
-
Match value in 2 separate columns and return a value from a 3rd Closed
Hello, Here is my issue. I have 2 worksheets within 1 workbook. I need to add a formula that will look at the value in sheet 1 column A and t...
-
Need Macro code for Search, Copy & Paste? Closed
Hello, I have Two Excel sheets , In Sheet2: Database file(Row wise Data has been updated i.e only in A column- refer below A1: Name A2 ...
-
Automatic updation of date Closed
Hello, I am looking for a solution for the following The file format is as follows A : Name B: Date C: Time When some one enter the name...
-
Automatic addition of date Closed
I want to add the date of modification of the cell in a file . the format is as follows A : Name B: Date C: Time When some one enter the nam...
-
formatting a column with repititive lines of texts with same col Closed
Hi i have just completed a time and motion excercise and i have enetered the details into excel. i have also cleaned up my data, checked for inc...
-
How to Copy my all data in excel sheet1 to sheet 2 Closed
HI.. all I have a Question. I have some data in my excel sheet1 . i want same data move or copy sheet1 to sheet2 by formula. i wait response. ...
-
Making Buttons to direct to a certain cel location. Closed
Hello, I'm just wondering if its possible to make a button that redirects you to a certain cel information in EXcel. Sample: I want the button...
-
Auto Copy Closed
I have a spreed sheet set up to log information on (sheet 1). On this sheet, it is a dynamic work sheet that we enter names on that we are currently w...
-
Insert/Remove photos depending up on ref. cell value changing Solved/Closed
Hello, I designed a Student Profile in excel using LOOKUP function. In this profile, near the Student Name title I created one drop down list of stu...
-
calculate difference in date Closed
Hello all I have date column in following format- 21/09/2014 06:26 AM I want to calculate difference between above date and today. I tried doing ...
-
How to Create Macro to Search, Copy, & Paste? Closed
I have Two Excel sheets Sheet2: Database file(Row wise Data has been updated i.e only in A column- refer below A1: Name A2 : person nameA3: ...
-
Move multiple entries from main sheet to multiple sheets Closed
My First sheet is titled "D-4 listing" and contains all of the data for other sheets. I have columns F thru P that I put an "x" in if the information ...
-
Excel VBA copy and paste loop with logic condition Solved/Closed
Hi, I am new to VBA and would appreciate some help with a problem I am trying to solve. I would like a macro that is able to copy information f...
-
Excel workbook with two sheets Solved/Closed
Hi, i have an Excel workbook with two sheets and when i enter data in sheet #1 it automatically goes to sheet # 2. How on earth can i stop this fro...
-
Need help with formula if multiple cells are empty then another Closed
I am using excel 2010, I need help with a formula that i can t seem to get i know i am close. example. A1,B1,C1,D1 - if B1 is blank and C1 is blank ...
-
Keep rules & formatting intact when data is copied to cells Closed
Hi, I have an excel sheet made with few rules and formatting for cells but many times I have the requirement to copy values to these cells from tex...
-
How to copy data from rows with value to a new sheet using macro Closed
I have a massive excel spread sheet that I am using to keep track of sales. I would like a formula or function that will take both the headers along...
-
%age of numbers Closed
I have ten different numbers in a column. I want to calculate the percentage value of each number in next box to each number with respect to 350
-
Substitute text into x in excel Closed
Hi there, I'm nowhere to run related to the above subject, hoping you can help me to sort out this issue. In column/row A1 text is equal to "clo...
-
Copying the same format data from n number of sheets in 1 sheet Closed
Hello, Scenario : I need to monitor a particular type of transactions. For each transaction done I get a automated mail with an attached excel. T...
-
Excel to send email when a cell changed Closed
Hi, I'm totally lost, I'm new to macro world and would like to send email from excel when a cell changed, the sheet is very simple: Name Pr...
-
Shared File want to get a pop up message when the file is opened Closed
I am trying to share a file between 3 people. I found the share option but I want to get a pop up message anytime the file is already open & someone ...
-
convert from one Column using if function Closed
hi i have the information in one Column "A". This "A"Column contains 100 address .(Each line of the address has been typed in separate row) but eac...
-
Auto Transfer of a filtered item to a different sheet. Solved/Closed
Hello everyone, I would like to ask for some help regarding some EXEL problems. Example: I want some data from sheet1 E columns to transfer to...
-
Moving data in specific columns to another sheet Closed
Hi there, I have a workbook with multiple tabs. I need to move the first 3 columns of data in a row on tab, "MV Data" to another sheet labeled, "Campa...
-
Simple report reminder - email notification Closed
Hi, I would like to create a spreadsheet that list the dates of reports that I need to complete. The spreadsheet would be relativly simple, just a...
-
last row does not show. 44 names bt i see 43 Closed
The function below , leaves there the last name (in column) in excel Private Function GetNameList() As String() Dim names() As String Dim...
-
Re: Need to copy excel every Row data to Excel template file Closed
Good Afternoon, I am new to excel macro. I have a excel file with Row data . I want to copy specific cells data from each row and copy to a speci...
-
Sorting contents from columns to Rows Closed
Hi, I have data sets in particular file format. Total no: of rows : 3623 (Column A) Total no: of rate cards: 26 (Column E) Rates for each code...
-
Any way to keep the formatting when using a formula in Excel2007 Closed
I would like to copy the contents and format of a column of cells and paste them in another column using a formula. All columns are formatted as ty...
