Excel Forum
-
Date Formating Closed
I have a huge file with date format in column "e" 3/8/45 and I want to change it to 8-Mar-1945. Also birth date is in col. e15 and the death date is...
-
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 numbe...
-
Copy Data On Condition From One Sheet To Another Closed
Hello, I have 15-16 sheets.. AND I ENTER data in sheet1 & sheet2 .. i want a code that can copy data from sheet1 / sheet2 to sheet3 or any other s...
-
Message Boxes Closed
Hello everyone, Does anyone know if it is possible to format a basic message box (just font and colour)? Or is it a case of "what you see is what y...
-
printing the same worksheet changing a cell with data populated Closed
How do you print the same worksheet repeatedly, changing a cell with data populated from a table?
-
Copy data from one sheet to other sheet. Closed
Hi guys! I have a problem coping data from one row within a specific range, example A2, B2, C2, D2, E2 and so on up to P2, and copy that data to diffr...
-
Excel Auto Create Sheet and Populate Closed
Hey Everyone, I'm looking to create the following; I have a list of employees who will be working on an event. The event is broken up into stages,...
-
Copy data from mutiple workbooks and paste below each other Closed
Hello, I need to copy data from multiple workbooks and paste in another workbook below each other. This is the first part. I need to copy data...
-
Total up boldly formatted cells Closed
Good evening much appreciated volunteers I am using an Excel 2007 spreadsheet to keep track of costs associated with a holiday. I have bolded al...
-
How to date tabs in sequential order using Macro Closed
Hello, Not too long ago I came across a helpful Marco that dated each Excel worksheet tab in sequential order with the Month and Date (i.e. Nov 1 ...
-
help on making student report card Closed
Hello, hello i was thinking about making student report card system in excel, no of student is around 40 in one class ...........please tell me ...
-
Comparing worksheets in excel Closed
Hello, I have 2 sets of data in Sheet1 and Sheet2 in excel. Both sheets have the same 7 columns and I want to compare the data in Sheet1 and Sheet...
-
Copy a row to another sheet if a value is x Closed
Hello, I'm searched around and can't really find anything that answers my question or I can understand. I'm quite able with excel but not great w...
-
Split a Range of data in Column A across subsequent columns Closed
Hi, I have more than 1000 (it will go beyond 4000 somtimes) order numbers in column A that I would like to split across the subsequent columns star...
-
Automatically transfer data from one worksheet to another Closed
Hello, I have an Excel workbook with two worksheets in it. The first worksheet is rows of data organized by Region, Client, Date, Product, Rep, etc...
-
Namning sheets after namnes in a column. Closed
Searched for hours trying to solve this problem.., I have a list of students in my workbook and want to automaticly change the following sheets in my ...
-
copy data from multi tabs of multiple files to one file with res Closed
Need help in copying data from multiple files. Below is the situation. 1. I have total 70 identical file with different data in that. 2. All 70 ...
-
Excel Loop Lookup Closed
I am trying to do a lookup on following sheet (4 columns Store, Part, K or R, New K or R): Store Part K or R New K or R 1 ABC R 2 ABC K 3 ABC ...
-
Compare Columns and return a value from third column Closed
Hello, I need to compare 2 columns and fill data from a third column. Here is the scenario. A B C D 1 1 X =X 2 3...
-
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 but n...
-
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 rows ...
-
how to change mm/dd/yyyy to dd/mm/yyyy format in excel Closed
Hello, Configuration: Windows XP / Chrome 38.0.2125.111 how to change mm/dd/yyyy to dd/mm/yyyy format in excel
-
Namning sheets after namnes in a column Closed
Searched for hours trying to solve this problem.., I have a list of students in my workbook and want to automaticly change the following sheets in my ...
-
Copy and Paste row 5- row 9 n number of times Closed
Hello, I am trying to save size of my Workbook from blowing of, which has lots of vlookup's and other formulas. So, i am trying to copy row 5-...
-
Excel Auto Create Sheet and Populate Closed
Hey Everyone, I'm looking to create the following; I have a list of employees who will be working on an event. The event is broken up into stages, ...
-
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 row. Example: Bef...
-
Pulling Informations from Excel Spreadsheet Closed
Hello - can anyone please help me? I have a spreadsheet that has the information from a Realtor office. It has all the information from each sale ...
-
copy the data in sheet 1 of excel A to sheet 1 of excel B Closed
Hello, I want to copy the data in sheet 1 of spreadsheet A to sheet 1 of spreadsheet B on clicking the update button in spreadsheet B Ex: Sh...
-
[Excel] - Copy Value and Save As Macro Closed
Hello, I'm trying to write a macro to copy a single value (ID number) from column C in a table on Sheet1 into cell A2 in Sheet2, and save a copy o...
-
Excel help\ Closed
I am trying to fill a column with values from other columns that have an A or B next to them. In column a I have an amount and the next column be the...
-
Total up bold cells Closed
Good afternoon I am using an Excel 2007 spreadsheet to keep track of costs associated with a holiday. I have bolded all the expenses which have...
-
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 simpl...
-
Transferring from Sheet 1 to multiple other sheets conditionally Closed
Hello, I would like to create a workbook for an English school I am starting in Tanzania. Once registered, all students info will be entered into ...
-
Recording macros Closed
Any one know how to record a macro From sheet to sheet? For example I want to copy and paste open task from sheet one to two and next week open t...
-
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 with Ex...
-
Addition formulae Closed
Hello, I need to add formula between two cells, when updating one cell with any value then add this to my resultant cell automatically like if ...
-
-:Watch_NASCAR Sprint Cup Final Ford EcoBoost 400 Live Streaming Closed
Hello, HD Link >> https://www.edigitalplace.com/ Watch NASCAR Sprint Cup Series Final Ford EcoBoost 400 Live Streaming The changes to th...
-
search and copy and paste Closed
Hello, I have already created macro tool and I need to include another macro which is a value in cell D16 is the name. We have a list of 30 named ...
-
Macro help (copy last row of item and paste into blank row) Closed
Hello! I need help with creating a macro. Currently I have a macro which creates a blank row everytime an item code in column A changes. Instead of ju...
-
search, copy and paste the calue Closed
Hello, I have a named in column A and telephone number in column B. I need only phone number. if i find the name I need to have only telephone nu...
-
Calling Cell for name on basis of changing number 0,1. Closed
Dear. I have attendance sheet name "Attendance" of 70 people. having table of their names in 1st Col and Absent in 2nd Col. Absent col changes everyda...
-
Clear contents then paste from subsheets macro Closed
Hi everybody, I have 13 subsheets that need to have their data put onto a master sheet. The header in A1:M1 is the same in every sheet, the data b...
-
TEACHER IN NEED!!!! Closed
Hello! Let me start by saying I only know BASICS about excel. I mean, I am proud of myself for finding the average of a few cells! That being said, I ...
-
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 numbe...
-
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 joined?...
-
Help making macro finds last used line + push down and delete ! Closed
Hello guys, im always here to find answer for my excel problems but couldnt find answer for this. Every single day i have to do a job that is co...
-
Date Format Closed
Hi All, I want use date 201201, how can this will be set in Execl Format. please help me. Thanks
-
How to Cycle through 2 different workbooks and adding row 2newWB Closed
Hi all I am totally new to this forum posting. So please overlook any mistakes. First let me apologize as my first post was not per forum guidelin...
-
Gather information from one spreadsheet and move it to another Closed
I have a spreadsheet that has the information from a Realtor office. It has all the information from each sale for all Realtors. I need to pull cert...
-
Auto-copy data from one sheet to another in excel Closed
Hello, I have a master excel sheet that houses all of my data used to create several reports. Looking to transfer/copy data from this master sheet...
