Office Software Forum
- Excel (9,805)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
-
Macro for copying and pasting (related to answered question) Closed
Hello, You recently provided this answer to a question (see below). I'd like to do almost exactly what you recommend, except my spreadsheet has si...
-
VBA date Closed
Hello, please can anyone help me? With the below code i'm trying to format the cell color when an date in a cell reaches the system date or a set ...
-
PDF file alwasy opening in Word Solved/Closed
Hello, What to do to disable my attachment file in pdf to open in Word application?
-
how to calculate values using COUNTIF Closed
I have 2 sheets sheet1 is a Summary sheet and sheet2 is data sheet sheet 2 has columns from A TO R, in that column G is Severity (heading) wit...
-
Trying to create a multi-column formula. Solved/Closed
Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...
-
formula for multi answers Closed
Hello, I'm not yet a member, first time user, however interested to be registered as soon. Hi looking for the right formula for the following....
-
Paste Values copied in alternate rows in a single column Closed
Hello, I need to paste some data from 1 column to another column but in alternate rows. for Example:- Data to be copied is as below. Cell Valu...
-
Autopopulate from master sheet? Closed
Hello, I've been making, essentially, copies of my and my husbands pay stubs. Currently I'm just copy pasting an "empty pay stub form" and manuall...
-
copy and insert rows Closed
Hi, Everyone! I just need help I need a formula or a macro code that everytime I will manually type something on column a,b,c it will be also ge...
-
Changing current font color based on other cell's value? Closed
Hello! I would like to change the default font color when entering text in Column B based on the text in a different cell. BUT, I would like to ret...
-
Removing FALSE from return Closed
Hello, I have this formula that returns FALSE, can someone tell me how to remove this? Thanks, Ed =IF(Tama!E8,+(Tama!C8))
-
Date with condition Closed
Hello, What could be the answer and how If function play Three or more condition applying in date formula? Problem A=Employment Type, B=Join...
-
Update sheet - may be by using a macro Closed
Hello, I am trying to make a kind of template file which will be used by different users, most of them even more simple excel users than me :-) The ...
-
VBA/Copy Paste Closed
Hello, I have a dataset with 300 rows and 10 columns. the first 4 columns have the metadata and then 6 columns with different values. what I want t...
-
Sum product and countif Closed
Hi, I'm trying to calculate the number of each type item on the column B that has the condition X on the column A and wich numbers on the column C ...
-
Move cells based on their values Closed
Hi, I did this a few years ago once but I can't remember how I got it to work. I have 2 sheets named BOQ and V.O. The BOQ sheet has a list of items ...
-
Update sheet by macro Closed
Once a month I want to import data from an external workbook to my excel sheet (let's call it "Master") and change some of the content in Master, both...
-
Paste two columns under each other for multiple columns Closed
Hello, I am new to VBA coding and trying to get things sorted for an excel document (work purpose). Unfortunately I am stuck in a [articular step un...
-
Paste 2 columns under each other for multiple columns with the s Closed
Hello, I am looking for a code to paste series of 2 columns under each other. Ex: Sheet1 1 Col 1 Col 2 Col 3 Col 4 2 ABC DEF GHI JKL 3 MON PQR...
-
Help with Excel Closed
Hello, I have two excel files. one is a staging inventory and the second one is the a delivery file. The inventory files has all assets number, seri...
-
VBA Paste based on Date Criteria Closed
Hello, I would be very grateful for some assistance with this spreadsheet I am attempting to create. I've Googled what I am trying to do several tim...
-
Possible to copy/paste row based on dates? Closed
Greetings, I would like to automatically copy rows from one worksheet into another based on dates contained in each sheet. The rows containing the da...
-
Paint cell based on another cell value with Macro Closed
Hello, I want to paint one cell, based on value of another cell using Macro. And i want Macro to do that for entire column. Example: COLUMN A ...
-
VBA Paste below row with Dates Criteria Closed
Hopefully someone can help me. I've Googled this several times and couldn't quite get the answer I'm looking for. I have data that I load and sort e...
-
downloading for PC Closed
Hello, how can i download a free microsoft office 2007 from the web? its for PC System Configuration: Windows / Firefox 52.0
-
Two excel sheets copy new data input on one sheet to new row on Closed
Hello, I have an excel spreadsheet that I have to update periodically overwriting old data. I have another sheet where I need to update the same inf...
-
i am mahi solve it Closed
Hello, =IF(ISERROR(SEARCH("*keyword*",A1,1)),"","keyword") it is only for one cell it perfectly ok for multiple cell its not ok this formula how...
-
Need To extract data from a column to another worksheet. Closed
Hello, I need code to extract all data containing a name from a column on sheet1 and copy it to Sheet2 and remove all blanks. The name is pulled fo...
-
Excel problem Solved/Closed
Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...
-
Populate a work schedule based on a matrix on a separate sheet Closed
I am trying to populate a work schedule on one sheet of a workbook based on a date matrix on a separate sheet of the workbook. I have a list of nam...
-
How to solve Date Format dd/mm/yyyy Closed
Hello, How to solve Date Format dd/mm/yyyy
-
recover user id of irctc Solved/Closed
Hello, recover irctc user id , i forgot it , so help me Configuration: Windows / Chrome 53.0.2785.101
-
Help with Index Match or VLOOKUP Closed
Hello, I have a worksheet with about 2000 rows. In column C and Column J i have a common Key. In Column K I have data that i want to write to Colu...
-
EXCEL: If number in 2 sheets match, transfer row to third sheet Closed
Hello! I have a question. I'm going to try to be as clear as possible. I have sheet 1 that contains all customers who are NOT on paperless billing. ...
-
password detail Closed
how can i get the password of ms word installed in my system it keeps telling requesting for password dont know how to go about it can someone please ...
-
Need help with storing data Closed
Hello Guys I am new to ccm.net and excel. My question is, how can i save one excel data to another .. Let me explain in detail... I want to make a ...
-
inches and feet and degrees Closed
Hello :) I have a same invoice which I need everyday to be printed out for me but it need to be upgraded each time with different information and date...
-
VBA; Copy data between workbooks where sheet name is same Closed
I have raw data (.xls) and using a macro I can tidy this up (adding header, text to number etc.) I then rename the sheet for the corresponding month a...
-
Copy sheet, change sheet name, change cell number, etc Closed
Hello, I am completely new to macros, so please forgive me upfront. Through online tutorials I was able to add a macro button and copy the sheet. H...
-
Excel find word in series of cells and add Solved/Closed
Hello, My colleague wants to has a spreadsheet with many columns and rows. The spreadsheet setup is something like this: Cells under column A ha...
-
Highlight one value in a dropdown menu of three responses Solved/Closed
Hello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...
-
Create new excel files based on the data in a column Closed
Hello, I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding. I have a spreadshee...
-
Code to move rows into another sheet based on certain values Solved/Closed
I'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...
-
Count only cells containing 2 given words Closed
Dear friends, I simply get mad trying and trying again to find the right function that may help me to count out of an array only the cells that conta...
-
Copy Data from Sheet 1 to Sheet 2 Closed
I need to copy data from sheet 1 to sheet 2 based on a Keyword or search criteria. However, the data is available in hierarchical format. I need a pr...
-
my document was in pdf when i was trying to convert to word it b Closed
Hello, my document was in pdf when i was trying to convert to word it became unreadable what can i do ? in Windows 7 System Configuration: Windows ...
-
Cell to populate if other column has any text Closed
Hello, I'm struggling to find a formula to populate one column's cell based on another column's cell having at least one character of text. e.g. A1...
-
Change cell text based on another cell's color Closed
Hello, I need to prompt a cell to write text based on another's cell color in excel but not using VB. Can you help? System Configuration: Windows /...
-
Paste Values copied in alternate rows in a single column Closed
Hello, I need to paste some data from 1 column to another column but in alternate rows. for Example:- Data to be copied is as below. Cell Val...
-
vba code Closed
Hello, I need to compare 2 excel worksheets. sheet1 - col A, B, C sheet 2 - col A, B, C Compare Col A and B of sheet 1 and 2 --> if they match th...