Office Software Forum
- Excel (9,703)
- Open Office (111)
- Outlook (632)
- PDF (333)
- PowerPoint (172)
- Word (2,176)
-
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...
-
If Then Formula [Closed]
Hello, I am trying to build an If Then formula. I am trying to reference a cell with a specific text in one cell like A2=Light and only if Lights is ...
-
How to change word in cell using another word in another cell [Solved/Closed]
Hello, I have 2 qns 1) Everytime i enter "Sells" in a cell i want another cell to appear "to" and in the same cell if i key "Buys" i want the o...
-
copying macro [Closed]
I want to write a macro where it groups my data by group # and copy the data of each group # into different sheets. Afterward, rename each sheets t...
-
Outlook 2010 configuration for mail.com [Solved/Closed]
Hello, I am not able to configure outlook 2010 for mail.com. OS- window 7 64 bit Could you please provide me the server, port details.. Thank y...
-
How to extract&automate dailymaster excel sheet using macros/vba [Closed]
Well, On daily basis I get master data sheet and create a excel reports manually, I can add columns and use formulas to get required result, you can s...
-
trying to get an if statement working [Closed]
i am trying to make a formula that when these cells have text in them, a counter goes up. my code here =IF(ISTEXT(C3),1,"")+IF(ISTEXT(D3),1,"")+IF(...
-
Conditional formatting one cell value changes formatting [Closed]
Hello, I am trying to create a comprehensive to do list for my work. I have a "Completed"(A1) column and a "Task"(B1) column. When I enter a va...
-
Compare 2 lists of numbers [Closed]
Hello, I have 2 lists of serial numbers. One is a master list of all serial numbers and is 234 rows by 4 columns. There is a blank column next t...
-
IF Function Time [Solved/Closed]
Hello, I am trying to make a rota and I need help with a formula. A1 B1 C1 07:00:00 14:30:00 =b1-a1 The person st...
-
Check if there is a match to a cell in the rest of the workbook [Solved/Closed]
Hello, I've got a workbook that has divided a list between 10 different worksheets (based upon their categorization), unfortunately, the list that...
-
Making selections for unknown data in excel [Closed]
If i have an excel spreadsheet that has 1491 items in a specific column and i want to select every 149th item in that column so that i select 10 items...
-
if in 1 row one cell are equal to another cell in th 2 row i ... [Closed]
Hello, in excell i have 2 row and i have a cell from 1 row that equal to a different cell from the 2 row i want to copy the content from a different...
-
Copying an entire worksheet to another worksheet automatically [Closed]
Hello, How can I automatically copy all data from one worksheet to another to include charts etc. Basically a copy of another worksheet tab. than...
-
changing font colour in a range based on conditions in another [Closed]
Many thanks for the answer provided so far. But what I actually want have not been solved. For example if any cell value in the range D4:D40 is betwee...
-
How to make Macro Repeat [Closed]
Hello, I am trying to run a macro where I multiply a range (B3: B615) by a number (B2). The problem is I want to do this for every column in my wo...
-
Changing font colour in a range based on criteria in another [Closed]
Hello, I am trying to change the font colour in a range of cell based on conditions i set in another range of cell. How do i go about it, its giv...
-
MS Publisher software [Closed]
I downloaded the software for Publisher and lo and behold! IT IS IN FRENCH - I think! It definitely is not in English which is the only language I u...
-
Relating today to other dates [Closed]
Hello, =IF(M38>=A197;(M38);(O38)) M38 - date for the first payment A197 - =Today() O38 - date for the second payment What I wanted with th...
-
Macro needed [Closed]
Hi, I am a complete novice and have never written a macro before. I have an excel workbook with 1 worksheet called 'VOID MASTER' , I would like a macr...
-
problems with outgoing server sending email (gmail-outlook 2007) [Closed]
Hello, i have problems to send email (gmail)/outgoing server IMAP outgoing serv setting smtp.gmail.com SSL 465 req sign in user name password...
-
Run-time error '1004': [Closed]
Hello, First of all I am not a programmer so am very new to macros. I have used the TwoSheetsAndYourOut macro which works in general workbooks ...
-
cell data xfer between files [Closed]
Hello, I have two files in separate folders. I want to transfer data from one cell into a cell in a file in a separate folder. If I put = in the mas...
-
Excel: comparing two columns and their rows [Closed]
Help! Here's what I'm trying to do: take a value in the N column of TABLE A, match it to the AB Column of REFERENCE TABLE B; then once that match ...
-
Fill color of one cell based on contents of another cell [Closed]
Hello, I'm using office 2010.. how do i make one cell change color by adding an indicator in another cell... For example..when i put an x in a cell ...
-
If condition [Closed]
Dear Freinds I need your help for below requirement. I have 3 columns. Column contains text like Wk1, Wk2, Wk3. Column 2 and 3 contains numeric va...
-
Reminder [Solved/Closed]
Friends Hi can anyone please help me? I need to set up a reminder in excel. I have a workbook containing a sheet that contains all our permits and in...
-
automaticaly transfer a line of information to another sheet [Closed]
Hello, HI, I have a workbook that has 2 sheets, on sheet 1, I have 22 columns with different information, on sheet 2, I would like to automati...
-
Filter data in a sheet from values in another sheet [Closed]
Hello, I really hope someone could assist me as I am very new to Macro's/VBA and I have a requirement that needs coding. I have a sheet (Total)...
-
Changing values in a cell dependant on another [Closed]
Hi guys, first time on here, i've gone through a few previous posts and found some helpful stuff, but still having trouble with something. I've ...
-
Stupefying differential result! [Solved/Closed]
Hello, in the attached picture you can see that in cell E23 I inserted my budget and in cell E23 I inserted what I actually spent (the same amount) sh...
-
Open Excel files on my Mac [Closed]
Hello, When I open any attachment that is a excel worksheet it goes to all the files in my documents?? help? Configuration: Mac OS X (10...
-
Excel - Repeat certain rows 4 times consecutively [Closed]
Hello, I am a complete novice when it comes to excel so please bear with me. If I had a Data Base of lets say 1000 numbers (0001 to 1000) and...
-
Copy from multiple worksheets to a summary sheet [Closed]
Hello, My name is Nelson, I recently came across your website and i am hoping that my problem can be solved. I am new to VBA. I want to loop th...
-
checking for type of day [Closed]
I need excel to check =if a DATE = Monday, then, else EG; =if(a1=Friday,+a1+1,+a1) =if(a1=Sunday,+a1+1,+a1) I am trying to build a data base wor...
-
Not sure which formula to use? please help [Closed]
Hello, I need a formula to work out the following: 30 meters = 7 squares 60 meters = 14 squares 90 meters = 21 squares etc etc so when I t...
-
my account is block since 3days ago and have upload my I D [Closed]
Please help me out
-
Test for quarter of year [Closed]
How do I test for what quarter of the year a date is in?
-
Insert Lines & sequential numbers based on quantity [Closed]
I have an order form with multiple macros including a macro to "Total" each order to show only the items and the quantity of each item that is ordered...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video