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...
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....
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 information from a database to an excel sheet?
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...
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...
how to convert one csv file to xml using macro No description PLMN-PLMN/BSC-393337/BCF-1012...
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 ...
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...
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 ...
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...
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 ...
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...
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...
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...
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...
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...
How do you print the same worksheet repeatedly, changing a cell with data populated from a table?
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...
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,...
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...
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...
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 ...
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 ...
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...
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...
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...
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...
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 ...
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 ...
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 ...
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...
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...
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 ...
Hello, Configuration: Windows XP / Chrome 38.0.2125.111 how to change mm/dd/yyyy to dd/mm/yyyy format in excel
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 ...
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-...
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, ...
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...
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 ...
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...
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...
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...
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...
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...
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 ...
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...
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...
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 ...
Hello, HD Link >> https://www.edigitalplace.com/ Watch NASCAR Sprint Cup Series Final Ford EcoBoost 400 Live Streaming The changes to th...