Excel Forum
-
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 ...
-
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...
Subscribe To Our Newsletter!
