Excel Forum
-
if formula showing date [Solved/Closed]
Hi all, I created a spreadsheet that has a date in and a date out columns, the dormula I use on the date column is: =if(d2,TODAY(),""). Formula is in ...
-
Excel - Calculation Based On Dynamic Criteria [Closed]
Good day, I have this question as followed:- I have a table as attached file where I already created a macro to repeat the lines based on the (rou...
-
Individual Scorecard Template [Closed]
Hello: Recently I have been tasked with creating individual scorecards for 300+ employees. The data is derived from 4 .oqy cubes that are presente...
-
Individual Scorecard Template in Excel 2007? [Closed]
Hello: I've been tasked to create customer service scorecards for approximately 300 employees from pivot tables that come from at least 4 differen...
-
EXCEL Formula for percentage of... [Closed]
Hi there, I'm having tough time with this one and I would really appreciate help. My 'F' column contains different values including 0 (zeroes). I ne...
-
How to split a cell based on #27 line break [Closed]
Hi All! First to all thanks a lot for your assistance! :) I'm trying to split a cell into two based on the # of linefeeds that it contains. I...
-
Auto email send to Recipients update in spreadsheet using Excel [Closed]
Hello, I'm new to this forum. Currently I have a shared workbook that link to multiple user for update. I have a column for having the person (exa...
-
Nested if problem [Closed]
What is the problem in my formula IF Salary is less than 5000 than house rent Salary*55% but not less than 2500 IF Salary is less than 5001-10800 th...
-
Excel VBA: Application.FileSearch Error [Solved/Closed]
Hello everyone, I encountered error "Object doesn't support this action." when the program the line "With Application.FileSearch". Here is my codes...
-
Comparing and copy cells VBA script [Closed]
Hallo, I need some VBA script to compare two cells like ex: A2 with B2, A3 with B3 and if B2 or B3 is empty should A2 or A3 be copied to Sheet2( or in...
-
List Dates in Column A1 [Closed]
In column A1 i need dates lets say 1-Nov-13 numbering for an entire year. The tricky part is i need Cell A1,2,3,4 to have the same date. 1-Nov13. t...
-
Conditional Formatting [Solved/Closed]
Hello, Does anyone know if you can set conditional formatting to highlight an entire row if the date in a specific cell is less than a week from t...
-
If data matches in one column, check 2nd column matches [Solved/Closed]
I've been trying to figure this out for days, I'm sure it's possible but can't get it to work. I have a set of data - in one column there are refer...
-
code this in VBA for Excel [Closed]
Can anyone code this in VBA for Excel? If active cell is not blank, then select range from current cell plus 2 cells to the right (ie A1:C1), copy ...
-
Delete Row [Closed]
morning im trying to get a macro that can delete a row in my table. i either need it to be a delete button on each row or a delete button...
-
Macros for create new excel sheet from active workbook [Closed]
Hi, could you please provide a logic for create new excel sheet from active workbook, please find the my code below. Private Sub cmdCFUploadFile_Cli...
-
Comparing two spreadsheets - deleting rows in one [Closed]
Hello: I have a requirement to do the following: - Spreadsheet #1 contains several columns of product data, including SKUs. It has several thou...
-
if function with dates [Closed]
I'm building a personal finance tracker, and I'm attempting to get a function to tell me which week of the month I purchased something in. Right now ...
-
Comparing text values in 2 Excel sheets [Closed]
Greetings all, I am looking to compare the text values in 2 Excel sheets and output them to a 3rd sheet. Trying this in Excel 2010, and am a littl...
-
Conditional formating issues [Closed]
I am using the NETWORDAYS function in column T comparing column H and I. So far so Good, I then apply conditional fromatting to the values to where ev...
-
vba for selecting names one by one from the drop down list [Closed]
I created a Report Card using excel for my students' to see his/her marks after each exam. The Excel file contains three sheets. First sheet contain...
-
Help to convert a date to julian date fromat yyyyddd in excel [Solved/Closed]
hi, i have thousands of dates in format dd-mm-yy that needs to be converted to julian date format yyyyddd. dates that needs to be converted are fro...
-
Nesting IF statements - comparing text [Closed]
Hello, i am trying to match 2 columns of names. the issue is that the one column is a full name and the other is only a partial name, usually fir...
-
excel:password protected sheets [Closed]
Hello, I hope someone can please help me in adding a password to excel as admin and user..when a username password is entered it will show sheet 1...
-
Macro for sending gmail [Closed]
Sir I need some help my problem is follows. I have a data sheet. I will be updating every day the data sheet. I use a macro to generate a sheet ...
-
Macro codes for a selecting range automatic selection [Closed]
Hi Experts, i am new to excel. Need a urgent help. I am preparing excel macros, where I have sheet with Column A as key field with 275 rows to work w...
-
How to return all values matching two criteria [Closed]
Given this table A B C Number Sector Name 1 21144 P John 2 21144 P Mark 3 21144 P Bob 4 ...
-
Is there a way to call out multiple values in single cell? [Solved/Closed]
Hello everyone, this is tricky and im not sure if i have missed something or if this is even possible, if it is it would be a huge help. I am limited ...
-
Excel [Closed]
Acc Code ..... Date.................. Amount....... Cleared C287974...... 31-Jan-13.......... 500............. Yes J320728....... 07-Ap...
-
Create different worksheets based on data in a column [Closed]
I have a huge worksheet, where I have a data by different countries, I want to split this master data into different worksheets based on the countrie...
-
How to capture the data with using of Macro [Closed]
Hi, Am crating a excel form in sheet#1 as following entry's. Row Column A B C D E 1 ...
-
Excel: matching lists with different formats [Closed]
I have two lists of names that I am trying to compare. One list is divided into two cells, one for first and one for last names. The other list has ...
-
numeric value covert to word in excel 2007 [Closed]
Dear friend, Pl.provide me a formulla which can translate currency number into words i.e. 12,34,56,78,910.91 into Twelve Arab,Thirty Four Cr...
-
Lock/unlock/color a Range based on the Value in another Range [Closed]
Hello, My questions relate to Excel for MAC 2011 (not PC), I am very new at VBA. I found the below code and need help to make it work. My Excel ...
-
vba - graph color same as cell color [Closed]
hi, i am creating a project of my own using ms excel 2007 and i need help on this. i want to put the cell color to the graph that i am making using ...
-
Insert desired rows on condition basis [Closed]
Sir. I am new to this website. I want to learn/know to how to insert desired number of rows when any condition met. For example: I have a Spr...
-
Create new sheets in Excel based on dates and creating charts [Closed]
Hello, I have excel file with aircraft engine data (date, time, EGT & CHT for 6 cylinders, fuel flow and manifold pressure), eg 16 columns and abo...
-
Conditional Formatting Based on Dates-3 Columns [Closed]
Dear brothers/sisters, I need your help to do this below facilities in excel. I explain it, then you please guide me well in detail. 1) In Cells A...
-
Parsing Rows of Data into separate tabs based on criteria [Closed]
I have a master list of launches in excel, each which includes a column for launch date. For all launches with a launch date in September, I would li...
-
Insert Muliple Embed Objects VBA Code [Closed]
Hello, I am looking for a script that will automatically insert muliple embed objects to cells in excel And this is my case: - I have a sheet wi...
-
excel vlookup-copy entire row [Closed]
Hello, I need to get the entire row by using vlookup or any other lookup/formula please help. is there any option to lookup left side of t...
-
Copy rows with specific data to another sheet automaticaly [Closed]
Hello, I am new to this forum and appreciate worth of all who want to help and share knowledge. I would like to extract or copy rows from one s...
-
How to transfer data between multiple sheets [Closed]
Hello, I am just wondering if anyone could help me find a solution to my problem. I am trying to automatically transfer data from one column t...
-
Auto notify or mail when excel sheet is updated. [Closed]
Hello, I found this code on the site, however I am trying to get it to launch Lotus Notes instead of Outlook. Any help would be appreciated. ...
-
Macro for Pivot table for all file name starts with markup [Closed]
Hi, Need a macro for creating pivot for all the files name starts with markup. 1. File names are variable (markup..........) 2. Sheet inside ...
-
Insert Muliple Embed Objects VBA Code [Closed]
1. I have a sheet with a list name of pics in column B4. And i want to insert embed object picture automatically in column C4. I store images in D:\i...
-
Sharing data between worksheets [Closed]
I would like to share data between worksheets. I have data on one sheet that is labeled as 1 - 100 with descriptions and other information. I would li...
-
Formula [Closed]
Can someone please help me? I have a column with the letter H and I would like to add a value to the H so that I can sum the colum in the last row. i....
-
Macro Button to export Data to another workbook [Closed]
Hi All I've been having difficulties trying to apply a macro to a button that submits data and exports into another sheet. One issue I've come accr...
-
Excel formula to count cell colour and display sum in another [Closed]
I have had a look through the other questions and responses, but they don't really help. Using Office 2010, I would like to apply a formula to a range...
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account