Excel Forum
-
Multi percentage Calculation Closed
Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I attac...
-
If dates range Closed
Hello, I need help for a function. Lets say that we have the today date 4/12/2014. I need a formula to use in conditional formatting. If the da...
-
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 spa...
-
Date if statments Closed
Hello, I have a if statement that I need help writing. I have a today date cell and I have closed date. I am trying to make the new cell check i...
-
Check if input number is minimum and display a pop up dialogue Closed
Hi, I am novice VBA developer. I am trying to write a macro which does following. 1.When a user enter a particular value into cell 2.Check if ...
-
change date format Closed
Hello, Change date format dd.mm.yyyy to dd/mm/yyyy for excel 2007
-
for progress billing Closed
Hello, how can i automatically know the percentage area of a accomplished tiles by simply counting the tiles Configuration: Windows / Chrome 3...
-
compare two excel sheets and get unique value from both into new Closed
Hi, I have two excel sheets. Sheet 1 with 4 columns and sheet 2 with 2 columns. I need to compare column 1 of sheet1 with column 1 of sheet 2 if it m...
-
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 data ...
-
Finding data in different Excel sheets with month-sort by VBA? Closed
Hello, 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 tabl...
-
automatically moving rows from sheet 1 to sheet 2 Closed
My document has several sheets, but what I'd like to do is create a VBA to automatically move a row to sheet 1 from sheet 2 when I have selected 'Acti...
-
Repair Corrupt Excel File Closed
I have an excel 2003 workbook that will not open. The file is huge. I have tried the repair utility within Excel but it still will not open. Has an...
-
Data validation Closed
I want a sheet of income tax calculation, so i like a input a cell pan no. so allow in cell LENTH 10 DIGIT AND first five text and mid four number and...
-
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 automatically...
-
Lock Flag ignored:How is this possible? Closed
Hello, Cells C4 and D4 are empty cells, and both are locked in Format Cells->Protection-> Locked. I go to Tools-> Protection-> Protect Workshee...
-
Help me on this formula to shorten Closed
Hello, please help me out to shorten this formula.. =IF(B53="SP1",2,IF(B53="SP2",2,IF(B53="SP3",2,IF(B53="SP4",2,IF(B53="SP5",2,0)))))+IF(B54="...
-
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 wit...
-
Create a new sheet using data in one column copying data Closed
Does any one know how to create a macro which takes the following data: A B C D 1 Rabbit Carro...
-
Copy rows from activesheet and create and paste in new sheet. Closed
Hey guys I have a workbook with +-5000 rows of rooms in different buildings. I want use the column BUILDING_CODE and copy all the rooms that have ...
-
Copy template .xlsx file based upon unique cell values Closed
Dear All, Need you help for copying template .xlsx files based upon the unique cell values present in another excel file called file1.xlsx-->values i...
-
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 . 1....
-
customize multiple workbooks Closed
I am currently working on attempting to consolidate excel workbooks in that I am looking for a way to input in one workbook and have it transfer to 2 ...
-
How do i copy database information to excel? Closed
How do i copy information from a database to an excel sheet?
-
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 A1+A2...
-
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) which...
-
csv to xml in macro Closed
how to convert one csv file to xml using macro No description PLMN-PLMN/BSC-393337/BCF-1012...
-
help me to count different charecters on 2 cells 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 spa ...
-
Help - how to conditionally copy columns to multiple worksheets Closed
Hi, Newbie member searching for a solution to what is probably a straight forward problem. I am new to Vba so have little understanding but am famili...
-
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, but ...
-
Copy row from sheet 1 to sheet 2 if value is x Closed
Hello, I've 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...
-
Excel Help with Macro Closed
I have an excel workbook with 4 Sheets. Sheet 1 (summary) is a ledger. Sheet 2 = Bob Sheet 3 = Bill Sheet 4 = Bart Column D in the ledger ...
-
Macro program for sum Closed
Hello, I need to find out a formula for sum for the following conditions if (and(cell b1="text", cell b5="text",cell b10="text",cell b16="text")s...
-
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 ...