Office Software Forum
- Excel (9,746)
- Open Office (113)
- Outlook (639)
- PDF (334)
- PowerPoint (174)
- Word (2,185)
-
Problm in Macro for deleting row Closed
Hello, Hello, First of all let me thank you all for sharing your knowledge in this forum. You guys are doing a great job. Now moving to my ...
-
I want to retrieve value from multiple sheets of same workbook Solved/Closed
Hello Everybody,.. I have a situation where I request your support, My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3, sheet4...
-
Need a cell to show the Thursday before a specified date Closed
Hello, I have a spread sheet that specifies when a product must be made by. I now need this to show the Thursday before a specified date. ...
-
excel formula using 3 tabs Closed
Hello, Can someone please advise if there is a formula or a macro that I can use for an excel spreadsheet. The first sheet tab consist of the ...
-
VBA FontColor Changing Adjacent Cells Closed
Good morning all, I'm stuck on a particular vba script for a Risk Register if anyone would be able to offer any assistance. Essentially the scri...
-
Stuck with Active sheet selection in Macro Closed
Hello, I am at very infant stage of working with Macro. I tried to run a macro where in the macro file creates a new file with data from original ...
-
Copy range data in a column to new column. Solved/Closed
Need help here please !!! Data available : A range of data in a column. Some of the cells are blank. My requirement : Is there any formula where...
-
Counting between dates Closed
Hello, I want to count the response to applications made to different organisations between set dates. In column C i use a simple 1 or 0 to indic...
-
Word processing software Closed
My computers have always come with word processing software already installed. I purchased one recently and it looks like there is none installed. I...
-
Find number in cell and return text in adjacent cell. Closed
Hello, I'm trying to search a cell for a number, and if the cell contains a number I need to return a word in the next cell (the cell I am doing t...
-
What does this macro code mean? Closed
Hey, The below macro was posted by another user, aquarelle, and is very useful for inserting copies of rows in an excel sheet. I tried asking them ...
-
How to copy Data from one excel sheet to another by criteria vba Closed
I have data in Sheet1 and am trying to copy Range("A1:B8") from sheet1 to Sheet2 But while copying there are some condition Conditions are as foll...
-
Compare Fields Closed
Hello, My name is Swapnil Veer. I have two sheets in excel. I have to compare two different columns in sheets and add respective entry in front of...
-
VBA group by code Closed
Hi Everyone, I have data which looks like MANUFACTURER BRAND SEGMENT VALUE COLGATE Colgate BASE 500 COLGATE C...
-
Compare two columns Solved/Closed
Hello, In the excel, I need to compare Only portion of text in two different columns and return the value in third columns. say example One column...
-
Counting number of times a value appears if.. Solved/Closed
Hello, I conducted a survey in which some questions allowed more than one response. Using Excel - I'm trying to count the number of times a cert...
-
PDF converter Closed
Hi Greetings I need the PDF converter from any kind of file like word, Excel etc
-
Transfer an entire row from one sheet to another Solved/Closed
Good Evening, I seriously need major help. Please!! Please!! Please!! I have an inventory of over 600+ items (rows) each row has 12 columns with...
-
decrease in megapixels when converting? Closed
Hello, For some reason my pdf files lower their quality only when I use the pdf creator. I open the pdf file with multiple pages with the pdf a...
-
Auto fill a Macro Closed
Hello, I want to auto fill a macro button down column A, that copies the information from several cells to a different sheet in the work book. here ...
-
Funct for adding +1 to a cell if there's a value in other cells Closed
Hope someone can help me with this, idk if it's possible in excel 2007. So basically I have a series of cells where 1 needs to be added depending ...
-
Conditional formatting, graded color scale Closed
Hello, I use graded color scale from green to red to color cells based on value Example: Value (color) 1 (green) 10 (yellow) 20 (red) If m...
-
Barcode scan Closed
Hello everyone, I would really appreciate if someone could help me out.. I'm a small reseller but now I have over 600 items. I use the same barc...
-
Add to Excel Macros Solved/Closed
Hello, I'm looking to edit a macros code and I'm having some issues. Right now our workbook includes a growing amount of days on a project (day 1, d...
-
Formula for Fetch Data from another sheet Closed
Hello, First I would like to asked that how could I insert a excel file or create a link, to understand my query. because the query that I want t...
-
Formula to copy data based on the text in the cell Closed
Hello, I need to find out how to do this (and would be grateful if anyone could help me with this): I have a tab (1) in Excel with ten thousand...
-
Locking/unlocking a range of cell depending on other cell Closed
Hi, I need some help - in cell A2 there can be entered a value from 1-48. If A2 is 1, then only cell B2 in column B should be unlocked (one cel...
-
MS Office Activation Key Closed
Please I need an activation key for Micro Soft Office 2010 and 2013. Please help.
-
A macro to insert pictures into Powerpoint slide from Excel Closed
Hi guys, I need your help with my problem. I have two files, one excel file that include a schedule for the whole year with 6 coloum (A Week, B ...
-
droplist of tab names Closed
Hello, I have a dropdown list of all my tabnames in a workbook. I want to create formulas that will read the selection in the drop down list and ...
-
formula to check days of the month and display only weekdays Closed
Hello, Pls help me I want a formula in excel that checks the days of a given month in turn and display only weekdays (skip weekends Friday and...
-
Multiple sheet, find, copy specific cell and paste Closed
Hello, i have a challenge for you. Im working on a doccument to pull information from a different sheet, that was imported from a web based huma...
-
Protected worksheet Solved/Closed
Hello, I would appreciate advice as to whether it is possible to unprotect an excel worksheet if the password is forgotten? If it is possible plea...
-
Inserting image files from a directory specified by text string Closed
G’day CCM forum Quick hypothetical; I have a list of image file names in a column on an excel spreadsheet and a cell at the top of the page contain...
-
Copy row only if one cell's value is not 0 Solved/Closed
I would like to copy from a sheet to another only the rows in wich a cell ex.A1 has a value different from zero or blank. Thanks a lot!
-
Update value from table1 to table2 Closed
HI I have following two tables in excels. I want to copy values from table1 to 2nd one Criteria- we need to copy last five value. example shows in ...
-
F2+Enter key for Macro Closed
Hi I would like to request for a Macro that which execute a F2 and Enter keys. Please don't make a selection for a cells. I have a sheet where ...
-
Microsoft Office Adding Publisher Closed
I purchased the 365 days of Microsoft Office along with my new computer in December and it didn't include Publisher. How can I add that?
-
Help with simple 2 step macro? Closed
Hello, I ask help to write a macro that 1. searches for 1 name "(Nghiem, Emily)" 2. and then types "X" in the next cell to the right. (What I tr...
-
multiple IF to show different statuses Closed
Hello, I am trying to have different status in my reports depending on the dates in different cells H START I ACTUAL START J DUE K DATE COMPLETED...
-
Copy Cells Relevant to Unquie Col Match and Save to Local Drive Closed
Hello, I am new to VBA, and was going back and forth between the available codes trying to create VBA to execute the following, but was not able to...
-
Conditional Formatting based on Text in another Sheet Closed
Hello! I'm currently using Google Sheets, but I believe the formatting is the same. I am working on two separate sheets, one "Cashflow" and one "In...
-
How to get a macro to work in all worksheets Closed
I know I am missing something simple here. I made a macro to create a chart from a template based on two ranges in a worksheet (Brisbane April Sales ...
-
ibm lotus symphony Closed
Sir, I tried severel times to download ibm lotus symphony but failed. please help. With regards Mantu
-
double conditional formatting Closed
Hello, I would like to ask for your help with some conditional formatting, can’t really get my head around it. What I have: 1. Two columns in C an...
-
Put in today's date if other cell has color. Closed
Hi there everyone, I have a question about excel and I would love if someone could help me with it! I have an accountant sheet with invoices. When a...
-
A variation on the compare 2 columns in Excel Solved/Closed
Guys - Please advise and give me a few hints (or if you are generous write a macro for me [only joking ... a bit - please feel free to write it for me...
-
Automatic Data Transfer Closed
Hello, i am trying to extract data (certian colums )from one workbook to another workbook from a certian date, and everytime the orgininal workboo...
-
Call createJpg (reference sheet) Closed
Hey I have a doubt on this code ... > With OutMail > .SentOnBehalfOfName = "***@***" > .Display > ....
-
Search for a word in a worksheet and return row Closed
Hi, Hoping to get some help. I have a spreadsheet full of data in Sheet 1 from A1:AG159382. I would like to use a separate worksheet to search for...
