Excel Forum
-
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...
-
Comparing Data Between Two Spreadsheets Closed
I have two spreadsheets that includes account number, name, and a charge amount for one (positive number) and a waiver amount (negative number) on the...
-
How do I check for a blank cell in a range and replace them Closed
I am looking for a way to check to see if cells in a column are blank and replace the blanks with a character (in the case a ?) in an Excel 2010 works...
-
How to Cycle through 2 different workbooks and adding rows from Closed
Hello, i have 2 workbooks customer and Item customer has 1 sheet named custname which has a list of customer's name in column A (I. E. John, ...
-
color cells based on input Closed
I want to change color of my cells based on an input. eg: If I input 3 in a particular cell, 3 consecutive cells must be highlighted. Any thoughts?
-
Excel 2007 Using vlookup function in VBA Solved/Closed
I have a list of name and employee number in sheet 1 in column a and b.. Then what i want is to by simply typing the employee number in sheet 2 column...
-
Conditional formatting-color a cell based on the value of anothe Closed
Hello, I have 2 columns of cells: R1-R100 & S1-S100. The cells in column R are the sum of cells L2:Q2, etc are is labeled "Expected Time to Process ...
-
Comparing street address in two different worksheets Closed
Greetings collaborators! I would like some assistance with comparing street addresses in two different worksheets. The lists are quite long (thous...
-
I am trying to add 10 days to a "custom" date Closed
In the original cell I am using a custom date format of 00\/00\/0000 and in another cell I am adding 10 days to the date with the simple formula C1+10...
-
Strange problem with a macro Closed
Hi, I've been using an Excel macro for some time that opens another spreadsheet, selects all of the cells, copies them, comes back to the .xlsm wor...
-
automatically transfer data from Excel forms into worksheet Closed
Hello, I have a requirement to automatically extract data contained in Excel Forms, (there could be hundreds of forms) into a worksheet. Any assistan...
-
How to write vba macro in excel 2013 to delete cells in column Closed
I am analyzing data of two column A1-A310632 cell and B1-B310632 cells to check and delete the first 2 columns i.e A1-2,B1-B2 while keeping the nex...
-
hey may I ask you something please? Closed
i have two columns "County" and "County Code" i want to check country code not blank , and country code blank then return a value from a County to a n...
