The discussions
Inventory
SolvedHello, Can you pls help me with the following: I have Inventory Workbook, and Invoices. Every time I open new Invoice and entering Quantities of...
Vba how to create new worksheet and move value
SolvedHello there, I am zero in vba, can anyone please assist me what code to be used given following conditon Given,(I have data converted from csv t...
Excel macro; adding password
Solved/ClosedHello, Hope you anyone can help me with this... I need to create a macro that unlocks a password-protected sheet with password "password", do so...
Summing up data from groups & pasting it another column
SolvedHello there, I need to write a macro for the following example: A 2 A 3 A 3 B 4 B 1 B 4 C 7 D 3 D 8 Etc. Basicallly i ne...
Special sum of a column
SolvedHello, In have some columns with plenty of data. And I need to make a column which will have ... D2=C2 D3=C2+C3 D4=C2+C3+C4 ....................
Increased size of an excel file
Solvedhi guys, I have come across an interesting issue. I redid some tables in an excel file and when done with it I see that the size of the file is at...
Need help with percentage please
SolvedHello, I am new to excel and I am not very good at it so any help would be greatly appreciated. I know anyone out there is helping for no reason o...
High and lower case text in the "if" functions
SolvedHello, I am working on a basketball spreadsheet. I am keep track of the home teams straight up(SU) wins. Home teams are capitalized(higher case), ...
Populate data in excel according with n
SolvedHello all, My intention is populate an Excel sheet with a variable number of rows according with a number inserted on a fixed column. co...
Conditional formatting using dates in different cells
SolvedHello, I need help with a problem that is driving me insane. I have column A, B, and C A is date started B is date finished C is days it to...
Problem for creating ms word on tablet
SolvedHello, I find very difficult downloading MS word, Excel and VZO video chat.
Snding sms from excel sheet
SolvedHello, i need to send text message from excel sheet to mobile number. is there any method to send sms. please help me to give method. thanks ...
Dropdown lists in excel 2007
SolvedHello, I want to create dropdown lists in excel, it should work as follow:In cell2,1 must be a drop down list with 4 names (e.g.Mill,Comp,Loads,Blend...
What is the most appropropriate way to recover pst file
Solved/ClosedHello i m using MS Outlook my PST file was oversized which got corrupted after subsequent retrieval. Tell me what to use?? Inbox PST repair tool...
Converting date to year and month text
Solved/ClosedHello, I have a cell date entered as 8-Nov. Excel reads this date as 11/8/2010. The cell entry actually means Nov, 2008. I need to change that ...
Using vlookup to return insted of 00/01/1900
SolvedHello, I am using a Vlookup to return values within a sheet using cell A2 as my reference some of the data that I am returning via the lookup are ...
Formula for between to dates
SolvedHello, Hi, I am looking for a date formula that will tell me if a date in a cell is between to dates In column "A" I have a list of dates and in c...
Stop #n/a appearing after a vlookup
Solved/ClosedHello, I need to stop #N/A appearing after doing vlookup. I Understand that this happens because it refers to no value. Anyway I can make it ap...
One cell will turn green when the two other cells match
SolvedHello, I am keeping a register of staff in our department. What I want to happen is for the cell (where the name is) to turn green when the date ...
=month(d2)
SolvedHello, Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please Configuration: Windows XP / Chrome...
Macro to email picking up email address in one cell using lookup
SolvedHi can anyone help me I am using the VBA below to email a results sheet to various people,the code that I have will only allow me to email to one pers...
Returning value from column b in column c, in a cell ajacent to
SolvedHello, BHID MN Samp 47.86 Samp 50.24 Samp 41.63 Samp 49.34 Samp 48.19 Samp 53.11 Samp 50.98 Samp 49.07 Samp 48.05 Samp 52.96 Samp 41...
Recovery my work and restart microsoft excel
Solved/ClosedHello, everyone i have a problem with my excel while I start this program then open the file in MS Excel. Excel pops a message saying "MS Office ...
Compare data in seperate columns to find likely matches
SolvedHello, I want to compare data in columns which essentially is the same but worded different. For Example Name of Person County...
No tool bars or address bar on my browser
Solved/ClosedHello, I don't know what I did, but my address bar is only visable when I drag my mouse up to the top of my screen and my toolbars have disappea...
Code for macro that conditionally inserts rows
SolvedHello, I know this has been asked and answered often, in particular here: https://ccm.net/forum/affich-222200-insert-rows-on-change-of-value-in-excel-...
Excel for mac opens all files on desktop
Solved/ClosedHello, Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, t...
Can't open excel file
Solved/ClosedHello, I'm running a Mac (10.5.8) and am having trouble opening a recently created Excel file. I was able to open the file since the first time I ...
If statement errors and using multiple if statements.
SolvedHello, I am self teaching excel spreadsheets, and I would really appreciate some help to anyone that would graciously be willing to offer it. I ...
Merging more cells into one cell
SolvedHello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. w...
How can calculate days between twodates
SolvedHello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order date ...
Transferring data from one sheet to another
SolvedHello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data) to ...
Time calculations on a 24-hr clock
SolvedHello, I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything is b...
Auto notify or mail when excel sheet updated.
Solved/ClosedHello, We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or puts ...
I have a problem with microsoft office starter?
SolvedHello, I would respctfully ask anyone to help me with this problem which is: someday I have open the Microsoft Office starter and then I have been ...
Excel 2007 resetting cells to date format
Solved/ClosedHello, I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a vir...
Conditional formatting
SolvedHello, I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2 states B...
Simply cannot find an answer
SolvedHello, I have a spread sheet - column B lists dates for the last time a report for each product was completed. Each report is due every 28 days. ...
Vb issue with delete rows with specific values
SolvedHello, I am using 2007 excel and have the VB doing 2 things: 1) looking at specific Column for EXACT values and deleting row 2) looking at speci...
Macro help: copy data from a range of sheets to a master sheet
SolvedHi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs to: ...
Tagalog
SolvedHello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I cant ex...
How to convert number into text in excel
Solved/ClosedHello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"
Adding a new entry into a list - excel 2007
Solved/ClosedHi Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green). I ...
Vlookup range question
SolvedHello, =VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE) I'm using this formula in my spreadsheet and it is working EXCEPT when the new spreadsheet has inse...
Outlook - "unknown error" ox800ccc81
SolvedHello, re https://ccm.net/faq/5929-outlook-unknown-error-ox800ccc81 would you have a fix for this with Outlook Express? thanks Configuration:...
Adding the same action to every second line
Solvedhi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to ever...
If, then formula
SolvedHello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...
Convert date into month name
Solved/ClosedHello, suppose date has mention 1/1/09 and no month name then how to get the month name
Copy excel 07 sheet to other & keep formulas?
Solved/ClosedHello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep t...
Excel - active x combobox, selecting sheets
SolvedHi, Am a newbie in trying to automate Excel. I have a workbook with 50 worksheets and a menu sheet. On the menu sheet I created a Actixe X ...
