Excel Forum
- Solved
-
I need a macro please [Solved/Closed]
Hello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B...
-
Copy daily cost entries into the particular ledgers [Solved/Closed]
Hello, I want to copy the daily cost entires into the particular ledgers, which i put in different sheets. Ex: I have the following data: ...
-
date Entry [Solved/Closed]
Hello, i have an Excel sheet which my colleague should enter the date after he finished his job, for example:\today date is 2014/28/12 he...
-
How to Lock or password protected specific cell in excel 2010 [Solved/Closed]
Dear all: Hope you are fine. How can I Lock a specific cell of excel 2010 that any one can not change or input anything in that cell. ...
-
Excel macro to format report [Solved/Closed]
Hi everyone, I am new to this forum..........so new I've already typed my question, then clicked "ask your question" again instead of...
-
Need to write a macro to copy a row of information if true [Solved/Closed]
Hi, I have a workbook with several tabs and I want to first check if Column F on the first sheet contains 13 as the year (12/16/13 is the format)...
-
Using a Macro to copy & Paste from one sheet to another. [Solved/Closed]
Hello, Hi Guy's I hope you can help, I am using two sheets. one is spread across different rows so when I click create list it copies...
-
excel formula numbers to dates [Solved/Closed]
Hi, I need an excel formula for changing numbers to dates. It is part of the Julian Calendar but backwards and one extra number. Ex. 273143...
-
how to use releative refrences in conditional formating?? [Solved/Closed]
the first picture is the formatting rule of C7 cell the second picture is the formatting rule of E7 cell which i copy from C7. as...
-
Conditional formatting based on another cell [Solved/Closed]
Hello, this is what I want: EXAMPLE: B3= Arash if B6=1 then B3 goes red if B6=2 then B3 Goes yellow and if B6=3 then B3 goes green i...
-
Conditional formatting based on another cell [Solved/Closed]
i want to type a name in cell B3. and I want the cell's color change when I type 1,2 or 3 in B6 cell by using conditional formatting. is that...
-
help me to add particular cells [Solved/Closed]
Hello, i want to sum particular cells when a number consists in a cell eg:- =IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0) it...
-
Macro/command button help [Solved/Closed]
Hello, I am in need of some help here and would greatly appreciate it. Here is what I am trying to accomplish. I have a basic excel file with...
-
Copy info from one excel sheet to another sheet [Solved/Closed]
Hello, I am respectfully asking for assistance on an issue i am having trying to write a macro for a form that i am currently working on. I...
-
What Type does it want? (VBA question) [Solved/Closed]
Hello, So I have a pull-down list in Excel 2003 that is an expanded version of this: 011 012 01T 111 If I type in the cell (rather...
-
Conditional Formatting to hide 00:00 in column [Solved/Closed]
Hello, I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a...
-
help me on this formula to shorten [Solved/Closed]
Hello, i have 2 formulas tick mark automatically on worksheet.. please help me if further it can be shortened.. i want to know if J1 K1 L1 can...
-
Excel Picture Inserting Macro Help - Urgent [Solved/Closed]
Dear Rizvisa, please consider this little urgent and be kind to help me please I m trying to insert picture in excel column using macro...
-
How to count different charecters [Solved/Closed]
Hello, Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1...
-
How can I transfer data from one spread sheet to another? [Solved/Closed]
Hi, I'm working in excel and on one spreadsheet and I'm having to retype everything on to another spread sheet, I want to be able to have my...
-
2 macros in one sheet targeting same cells [Solved/Closed]
This is probably a really 'newbie' question but in all honesty, I'm new to macros and need some assistance. I have a macro written to...
-
How can we find data in different Excel sheets by VBA? [Solved/Closed]
Hi.I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a table...
-
Conditional formating to check text in another shell + numeric [Solved/Closed]
I have some text in A column ( say xxx, yyy) and numeric value in Column B . Now i want to highlight the shell in column B with 4 condition ...
-
help me to count 2 cells [Solved/Closed]
helo, please help me to count 2 celles A1 Is either 0 or 2, A2 is either 0 or 2 IF A1+A2=0 A3 should be 6, IF A1+A2=2 A3 Should be 3 if...
-
lock cells in Excel [Solved/Closed]
After setting up VB to lock cells in Excel I now need to lock additional cells. I currently have the following script (kindly given by rizvisa1)...
-
Needs some help with a formula [Solved/Closed]
Hello, Configuration: Windows XP / Firefox 33.0 Okay, here is a problem I've been dealing with for over an hour now. This should be easy,...
-
Numbers & Symbol ü (New Challenge) [Solved/Closed]
i need a formula to automatically check mark i.e(ü) mark a cell(eg:A1) if another cell (eg:H1)contains number:1 Condition is H1 may contain any...
-
Lock cell in Excel worksheet with VB [Solved/Closed]
I have an worksheet that I need to lock the cell based on the value of another cell. I have managed to create VB which will do this for one row...
-
Insert Multi Rows Between Existing Data [Solved/Closed]
Hello, I am trying to create a macro that will insert a set amount of blank rows into a existing spreadsheet after each entry. The amount of...
-
Copy and insert rows and number of times [Solved/Closed]
Hello, I have a sheet with over 800 rows. I need to copy each row and insert/repeat each entry 4 times below the preceding...
-
IF function formula based on three possible values from adjacent [Solved/Closed]
Good morning all, Excel 2007 - I need a formula based on the three possible values from an adjacent cell. 1st value: : if F5 is a date, a...
-
Conditional Formatting - highlight overdue dates [Solved/Closed]
I am a beginner with conditional formatting and researching the net for an answer has left me more confused than when I began! I am working...
-
Auto Filter depending on Cell Value [Solved/Closed]
Hello, I have data in a table, lets say the table is (A7:M200) and the Headings in this table is (A7:M7). Column 1 (A8:A200) is the accounts...
-
How to find out the data in six month record [Solved/Closed]
Hello, I have six month excel attendance sheet. which formula can i use to know in which month which of the employee has left and who has...
-
Nested if then [Solved/Closed]
Hello, I would like to have the contents of b1 displayed in m2 if t2=1, the contents of b2 displayed in m2 if t2=2, the contents of c1...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
format a cell with a comment based on a comment in another cell [Solved/Closed]
Hi, I need to format a cell with a comment based on a comment in another cell. So cell A1 might ask a question like is the window clean? B2...
-
Macro to copy paste without having all the source books opened [Solved/Closed]
Hello Kioskea users. I hope you're all doing great. Today I have a concern that I'm not able to figure out. Any help will be really appreciated....
-
how to convert Date to word in excel [Solved/Closed]
how to convert Date to word in excel e.g. 05/01/1992 to change Five January, Ninteen Ninty two
-
Automatically transfer data from one sheet to another [Solved/Closed]
Hello, I have a workbook with 2 worksheets. Sheet 1 has about 400 line items. I would like to be able to select certain line items on Sheet 1...
-
Calculate Total Total Hours Per Client [Solved/Closed]
Hi, I have a spreadsheet in which employyees time are entered on a daily basis along with the client they worked for. The spreadsheet...
-
How to count date cells for monday of this week [Solved/Closed]
Hello, I would like to count the number of cells with date = to MONDAY of this current week and also MONDAY of the following week within a...
-
Auto generate the seller sales report [Solved/Closed]
Hi! I create a sales report and I set up total 6 worksheet Worksheet 1 I named it Price list ... is a Data for my sales report. and I set...
-
Formula to increment date by seven days. [Solved/Closed]
Hello Everyone, In a work sheet, I have an invoice date (say column A) and a due date (say column H) with the due date being seven days after...
-
Automatically transfering rows from one sheet to another [Solved/Closed]
Hi, I was wondering if anyone could help. I've created a spreadsheet to track all contracts complied within our department. I have a "Contract...
-
Muslim Pro
-
Animal Crossing: Pocket Camp
-
Tacticool - 5v5 shooter
-
Resident Evil 3: Raccoon City Demo
-
Minecraft: Education Edition
-
Ukulele Tabs & Chords
-
Amigurumi
-
HEALTHLYNKED COVID-19 Tracker
-
COVID Symptom Tracker
-
Zoom
-
Houseparty