Excel Forum
-
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...
-
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...
-
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....
-
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...
-
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...
-
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...
-
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...
-
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,...
-
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...
-
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...
-
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...
-
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 ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
[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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
-: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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Insert rows based on cell value (simple VBA, I assume...?) [Closed]
Hello, sorry about my newbie question, I think it's very simple to solve, but have spent a few hours on google now and haven't found the right...
-
Sum Data Validation [Closed]
Hello, Please someone help me to figure out this problem. example : A1 + B1 = C1 A2 + B2 = C2 . . . . A9 + B9 = C9 If A1...
-
sum data validation [Closed]
someone help me to figure out this problem. example : A1 + B1 = C1 A2 + B2 = C2 . . . . A9 + B9 = C9 If A1 ~ A9 data changed using...
-
Copying a row [Closed]
I need help please. I have a workbook with several sheets. Each sheet contains similar data with a 'total' row indicating the total number of...
-
Copy data from one worksheet to another worksheet [Closed]
Greetings All, Let me begin by saying that although I have frequently visited this site and have learned valuable information from the experts,...
-
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...
-
Copy, Find, replace from one excel to another excel [Closed]
Hi friends, Greetings ! could you please anybody can help me to make excel macro or VBscript which should do the following steps,...