Forum
Office Software
-
excel on Mac
Im trying to setup my friends computer to invoice I have run time 1004 error occurring. Any help please Sub...
-
color cell
Hello, I have this formula to place a date in cell when negative number. =IF(D14
-
I want to change date format in Excel [Solved/Closed]
Hello, I want to change date format from SAP system i.e. 20.05.2010. When I apply thru format cell it doesn't work.
-
Need to extract specific XML data from a cell in excel [Closed]
Hi, I have the following data in cell A1 of an excel sheet: 39211000011200100100019 i would like to extract the value from this and print...
-
Automatically data to another sheet by adding new rows [Solved]
Hello, I have created a "request form" - the form is not designed in VBA - it is simply a spreadsheet using Column B, only, and each row has...
-
Lost product key
Hi ...... Still have disk but Lost Office 2010 product key, so although its working its missing some things like a proper spell check. I have...
-
Creating search and update command buttons in a userform [Solved/Closed]
I have created a userform for inputing new records in an Excel spreadsheet. I have written the code for the Save Record and Close Form command...
-
Update of Copied Excel sheet
Hello, I want to make copies of excel sheet such that if I delete rows/columns in main sheet they should be deleted in copy too. System...
-
Serial Numbers Based Upon Another Cell
I have a spreadsheet with owner and tenant information, along with their vehicle information. In the column that indicates if they are an owner, I...
-
Compare strings
Hello there, Case: I have lists of customers from 2 different sources, however example. List1 says ABC private limited on row A1, the other list2...
-
Importing Excel Table
How can I import a table from excel to acces and prevent creating duplicates in the access database if the record exists
-
Is there a way to export data fro table to a pdf form
I would like to send data from an access table to a pre designed pdf is there a way to
-
Help with filtering not working
Hello, I am having issues with my excel at work we have about 8 columns an they have filters an when I type in data an click the filter to go to...
-
Copy a range of Data in Column with a loop
Dear all, May I ask your help for a macro which allowed me to copy a range (column) 16350 times :-) On D5 to D369 I have a formula which do a...
-
Shows a #value! When using calculated fields on a pivot table
Hello everyone I would like to input a calculated field in the excel pivot table. I have input an formula as if(ERP (Variable)>0, "Yes",...
-
carrupt damage pdf file not open
plz solve my pdf recovery data file pdf not open
-
User form to search all result and edit selected
I'm newbie in VBA excel. I want to create usesform to add, search all result and edit selected. Any one have code like this? Thanks
-
compare 2 sheets with particular columns [Solved]
Hello, hear is the situation, sheet1 is having "item code (ex. 150007) in column A", and "Rack ID in column B (ex. AA001)" & other side in...
-
Add data to row that already contains data [Solved]
I want to enter data for the same product but it needs to be done on different days, with two different entry forms, so the row will already...
-
Automatically copy data from main sheet to child sheets. [Solved]
Hello, I know this question was asked in another thread (https://ccm.net/forum/affich-800808-need-to-automatically-copy-data-from-one-sheet-to...
-
how do i make my ranking
how do i make my ranking result be 1st, 2nd, 3rd instead of 1. 2. 3
-
Unable to change date format in Excel [Solved/Closed]
Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I...
-
Montlhy Service
I have an increasing excel sheet where i keep the service records for customers per customer, per branch and per date (per year, month and exact...
-
Need VBA Code or function
Hello, kindly need assistance in getting VBA code to copy rows to a new sheet based on the cell value with same name sheet. and auto save...
-
Microsoft Word icon changed to unknown program [Solved/Closed]
Hello, Recently my microsoft word (program) icon changed from the classic picture to the unknown programs icon. I wanted to know how to get...
-
Copying data from one Excel sheet to another. [Solved/Closed]
Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy...
-
IF function?
I am trying to figure out a function, that will give me a result of Yes or No, if the dates are matching or not. This is the function I am...
-
Inserting pictures
Hello, Please I need help, I want to insert pictures into a particular sheet remotely without opening the sheet. And the picture will be base...
-
i want to convert figure or digit to word but without rupees or dollar
Hello, i want to convert figure or digit to word but without rupees or dollar, i just need only at the end of words, please help System...
-
Populating multiple cells with information pasted on a main sheet
I am trying to paste data every week in the same cells (B2-B12) on my main page and have that data populate cells on 12 separate pages. All 12...
-
Help getting data from one worksheet to the next.
Hello, I am trying to set up a master job sheet for all of our field employees to have the information in the field. The links to the 2 sheets...
-
Adding date depending on the day of the week
Hello, I want to automatically calculate a date when an invoice is due depending on the day of the week. For example: the service is...
-
Transpose VBA Excel
Hi, I require a macro that performs a specific transpose action. Please see pre table example and desired post data set. I have searched...
-
AUTOCAD 2010
Hello, I tried to install autocad 2010 but it keeps saying insert disc 1after when i install DirectX. So I opened acad.msi but it says install...
-
help me to convert my file without spelling mistakes
Hello, I want to convert one PDF file to word file. My file was an tamil documenr. I tried many times but the spelling was not correct in...
-
Updating other Excel sheets automatically from Master sheet.
Hi, I have been trying to sort this for a while. I have entered data in my master sheet and I have 4 other sheets. When I put new data into the...
-
if function with time
Hello, cell A = Time in, Cell B = Time out I need to round the duration in between as below if sum(B1-A1)= 0:00:00 the answer should...
-
Copying formulas to multiple worksheets [Solved/Closed]
Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I...
-
Give a cell zero value depending on another cell's value
I have an interesting challenge I am a altra marathon runner busy creating a "log program" for my running Cell A1 = Distance Ran Cell B1 =...
-
Copy data and pasting multiple times using macro
Hello, So I am having trouble determining what code to use to past value. The situations is as follows: On Sheet1 I have a list of names...
-
Auto Xfer Specific Data to a New Wkst
Hello, I have a raw data file of sales opportunities and would like to automatically identify and copy the TOP 10 Optys onto a new Wkst....
-
Excel VBA- Copying data from newest worksheet to a new workbook
Hi all, Newbie here. I've been fumbling around with VBA and managed to get some parts working, but now I'm stumped. I have an Excel workbook...
-
Copy data onto sheet only if cell has text [Solved/Closed]
Hello, I need to copy formulas and data from a selection of cells in a worksheet (Figures) onto a seperate sheet (summary). I would like the...
-
Repeat a set of rows in Excel
Hello, I have some set of unique row in a1 to a10, and I want to repeat the whole set of row in same column eg."A" by some given no. Of time by...
-
Conditional format "match range" [Solved/Closed]
I am stumped and can't find an answer to this issue for Excel 2010 The best way I can describe this is that I am attempting to build an Excel...
-
How to repair a PDF corrupted doc [Solved/Closed]
Hi, I am having a problem trying to open a PDF file. Ever time I attempt to open, Adobe Reader loads, but displays error message: There was an...
-
Watermark to some pages not all [Solved/Closed]
Hello Office Software Geek, I am currently writing a lengthy document and want to add my name as a watermark to some pages and another name to...
-
Formatting a cell for multiple functions in Excel
Hello, I would like to have my dates be highlighted red when expired and yellow highlighting the dates when 30 days prior to being expired. I...
-
App Android
Hello, App android System Configuration: Tizen / SamsungBrowser 1.1
-
Split data into several rows of same data
Hello, I would like to split a row of data into several rows of same data in MS Excel. I will try to explain the situation. I need a macro...
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD