Forum
Office Software
-
Not able to send mail from the Gmail outlook [Solved/Closed]
Hello, I had configured Gmail in Outlook 2007. I am able to recieve all the mails. But the problem is not able to send mail from outlook. I had...
-
partial matches in lists of 6-digit numbers
Hello! I have a list of ~500 6-digit numbers. They were all hand entered, and we want to proof the list and see if any of them were duplicated by...
-
Formula to create generations based on birthday [Closed]
I need a formula in excel that will indicate generations based off of a birthdate. Generations: Traditionalists (Prior to 1943) Baby Boomers...
-
Copy and paste selected cells a given number of times
Hello, I had a quick course on macro and I would like to write my first one, but I would need some help with it. Id like a macro which...
-
Send mail if today is the birthday. [Solved/Closed]
Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 ...
-
Comparing Two Excel Sheets and copying like data to third sheet [Solved/Closed]
Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1...
-
Getting multiple largest values with specified limits
Hello, a1 is 110,a2 is 236,a3 is 175,a4 is 352,a5 is 257,a6 is 175.In b1 find value is greater than or equal to 400.i need all answers numbers...
-
Extract data from few XML file into Excel.
Hello, i hope someone will be able to assist me, and i hope it is possible to do what i need. I need to extract specific data from a few XML...
-
COMPARING 7 COLUMN
HI I WOULD LIKE TO KNOW HOW TO COMPARE 7 DIFFERENT COLUMNS AND FIND COMMON VALUE IN NEW COLUMN I'M ATTACHING ONE SAMPLE HERE PLEASE CHECK...
-
Trying to insert multiple rows between rows in excel with copied data.
Hello, I have used the two listed vba macros but i am having no luck combining the two. First one to add 13 rows between current data: data is...
-
Using a Named Field for Autofill [Solved]
I am performing an Autofill using a macro. Is there a way to enter the ranges using a "Named Field" in the macro without having to hardcode them...
-
Find and Replace using VB; from a txt file, find all commas ","
I need to find all occurances of a comma "," in a txt file and replace it with a blank space and output a csv file. Is there an easy way to do...
-
Excel Macro - Set and autofill a range? [Solved/Closed]
Hello, I am creating an excel macro to reformat a CSV file. In doing this, I need to select a column (F) and replace the values in that column...
-
Excel autofilter stops filtering [Solved/Closed]
Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file, which has about 19,000 rows,...
-
Formula for conditional format to color cells
hi, need a formula or conditional format: if cell a1 has text, then apply the color RED to cells underneath say a2-a15. then, once numbers...
-
Save excel file as specified titles in different workbook
Hello Trowa and team, I just saw you solved a task for another user, who wanted to recreate a file with specified names in the list. I have...
-
countif Formula
Count if Formula
-
Word 2007 blank page displaying square boxes [Solved/Closed]
Hello, Please can anyone help me. I was typing in english and then I wanted to change to chinese. I pressed shift and alt and immediately struck...
-
If a cell contains any text then add a value [Solved/Closed]
I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need...
-
How to copy a data from one sheet to another, when specific criteria is met
Hello, If, for instance, the criteria changes in column "C" - it gets higher number, how to transfer the row data to other sheet2, copying the...
-
Unable to open a file [Closed]
Hi everyone, I cannot open only just this one file. I keep getting a message that 'Visio cannot open the file or a component in the file...
-
Need to delete rows in multiple sheets simultaneously
Hi I have a worksheet that has 3 sheets. Sheet 2 and 3 have data linked from sheet 1. If I delete a row in sheet 1, I want to have the...
-
VBA Code to apply in each monthly worksheet
Hi, I have a monthly creditor file (create new tab for each month when required) and want to calculate the amount outstanding each month, which...
-
Formula in Excel to turn numbers into text [Solved/Closed]
Hello, I found formula but sir I want at last as per below. As per formula =words(1234) = one thousand two hundred thirty four But sir I...
-
Formula/Solution
Hi, Is there a way for me to link in one spread sheet the Leave Dates that will automatically apply to the specific date in a...
-
Mail.com POP (IMAP) settings outlook [Solved/Closed]
I got my mail.com email working using the following settings: Account type: Choose IMAP Incoming mail server: pop.mail.com Outgoing mail...
-
VBA Regex
i need a help to create regex to use in Excel vba. Actuality 3 regex 1. Only Numerics Valid: 12,12.000, 2343342.123221321398783, 0.9874, ...
-
Compare two excel file and provide unmatched excel data in separate file
Hello, I have two excel files with common identification column A in both files. I need macro which will provide unmatched data in separate...
-
use RegEx in vba sub in general sheet
How to use regex in general vba sheet. i am getting lot of red lines and not able to find the reason for that. I have enabled the...
-
Listboxes with Checkboxes to filter data
Hello, Greetings! I have a query regarding making dashboard. I have a data sheet where all data is managed. I want slicer with listbox...
-
read special character value
how to read the cell value in vba if A1 has special character like -------- I used Range("A1").Value , Its throwing an error plz help me
-
VBA code to count invalid Values
Hi, I have created a vba code to circle the invalid data based on the custom data validation rule being written. I want to count the all...
-
Where do you find the "25 character product key" they ask for?
Just downloaded power point 2010 for my old PC, but I get this message I don't know how to answer... Where do you find the "25 character product...
-
Automatically update a cell with last modified date and time [Solved]
I am maintaining a Test Environment Catalogue, with various users editing it. It is change controlled in SharePoint, however, I'd like to insert a...
-
Keeping track of ages
Hello, I operate a small daycare and need help figuring out a system to help keep track of my group ratios. I haven't been able to find a...
-
Microsoft Office 2010 product key [Solved/Closed]
Hi, How can I get the product key for Microsoft Office 2010 so I can complete downloading it?
-
Repeated copy/paste Macro
I have basic knowledge of Macros. I need to copy 1Lakh data in such a way that it takes 10k rows and paste in new sheet1 and again it takes...
-
Please help me connect my workbooks to a master excel worksheet.
Hello, I have been through every excel video and forum trying to figure out how to connect my Excel workbooks for a tracker I have been working...
-
VBA find column by name and sort [Solved/Closed]
Hello, I am trying to make a code that should: - Go to the first worksheet - Find the first column with header "sku" - Sort this column...
-
copy x rows from a worksheet and paste x rows into another worksheet n times [Solved]
Hi, I am struggling to create a macro that can copy an excel range of data (A1:B50) from sheet 1 and paste into sheet 2 for 4000 times....
-
Create new sheets based on Column A data. [Solved/Closed]
Hi, Is there a way to create a new tab based on column A? For example: I want to create a new tab for each vehicle, copy and paste all of...
-
Import text into corel
How do i import typed text in ms word to corel draw 9
-
Product key for Office 2010
Hello, I need product key for Office 2010. System Configuration: Windows / Chrome 71.0.3578.98
-
False error
Hello, How to remove false error while using this formula *if(c2="A",sumifs(sheet2!AA:AB,sheet2!B:B,sheet1!B:B, sheet2! Sheet1!...
-
Excels with different data
Hi All, sorry if this is already answered. I have two excel sheet having data of customers. the first report is 'old' one and the second is...
-
Finding duplicates between two columns with partial text
Hello, I am trying to compare a list of names in column A to a list of names in column B. I am trying to highlight the names in column A that...
-
How to put a password on my memory stick? [Solved/Closed]
Hello, I am looking for a way to protect my flash disk with a password. In case I lose my flash disk, and somebody else gets access to it,...
-
Arrow keys not working in Excel [Solved/Closed]
Hello, I am using Excel 2000. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. ...
-
Unable to send emails from Outlook [Solved/Closed]
Hello, I have a friend who is suddenly unable to send emails. Can receive, however. Error Message is "unknown error" Ox800CCC81. Help would be...
-
How to change date with the change in time
How to change date with the change in time and how to use if formula for date range
-
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