The discussions

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 copies t...

1 reply Last reply on 19 Jun 2019 by
ac3mark

Send mail if today is the birthday.

 Solved

Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 15...

11 replies Last reply on 19 Jun 2019 by
bkdroid13

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 column...

Last reply on 18 Jun 2019 by
TrowaD

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 not re...

1 reply Last reply on 18 Jun 2019 by
TrowaD

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 files...

24 replies Last reply on 14 Jun 2019 by
ac3mark

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 AND...

1 reply Last reply on 13 Jun 2019 by
TrowaD

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 on ...

1 reply Last reply on 13 Jun 2019 by
TrowaD

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 in t...

2 replies Last reply on 12 Jun 2019 by
excel987

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 this in...

1 reply Last reply on 12 Jun 2019 by
ac3mark

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 with a...

Last reply on 11 Jun 2019 by
excel987

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, I di...

Last reply on 11 Jun 2019 by
thankful

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 are i...

14 replies Last reply on 11 Jun 2019 by
TrowaD

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 a s...

3 replies Last reply on 11 Jun 2019 by
TrowaD

Countif formula

Count if Formula

1 reply Last reply on 11 Jun 2019 by
ac3mark

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 g to...

Last reply on 6 Jun 2019 by
Mirela

If a cell contains any text then add a value

 Solved

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 to s...

20 replies Last reply on 5 Jun 2019 by
Pharmanumbers

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 row d...

13 replies Last reply on 4 Jun 2019 by
TrowaD

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 because...

Last reply on 4 Jun 2019 by
OliviaCamp

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 correspondi...

1 reply Last reply on 3 Jun 2019 by
TrowaD

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 is ...

13 replies Last reply on 31 May 2019 by
ac3mark

Formula in excel to turn numbers into text

 Solved

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 wan...

4 replies Last reply on 31 May 2019 by
venkatesan

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 second/third/forth sp...

1 reply Last reply on 29 May 2019 by
ac3mark

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 server ...

Last reply on 28 May 2019 by
hernezto

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 Regularexpression...

4 replies Last reply on 25 May 2019 by
ac3mark

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 having ...

13 replies Last reply on 23 May 2019 by
TrowaD

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

1 reply Last reply on 22 May 2019 by
ac3mark

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 those i...

7 replies Last reply on 21 May 2019 by
ac3mark

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 key" ...

1 reply Last reply on 20 May 2019 by
HelpiOS

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 cel...

2 replies Last reply on 16 May 2019 by
NazCarr

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 next 1...

4 replies Last reply on 9 May 2019 by
ac3mark

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 software...

1 reply Last reply on 8 May 2019 by
ac3mark

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 on. I...

2 replies Last reply on 7 May 2019 by
ac3mark

Vba find column by name and sort

 Solved

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 ascen...

4 replies Last reply on 30 Apr 2019 by
bOFILL

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. Currently, sh...

20 replies Last reply on 29 Apr 2019 by
TrowaD

Create new sheets based on column a data.

 Solved

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 vehicle ...

4 replies Last reply on 26 Apr 2019 by
Jay

Import text into corel

How do i import typed text in ms word to corel draw 9

1 reply Last reply on 23 Apr 2019 by
ac3mark

Product key for office 2010

Hello, I need product key for Office 2010.

2 replies Last reply on 22 Apr 2019 by
b,s

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! A:A))*

1 reply Last reply on 22 Apr 2019 by
ac3mark

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, should n...

Last reply on 16 Apr 2019 by
d7tdiugougi6r

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. I wa...

Last reply on 15 Apr 2019 by
Nelson

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 most...

Last reply on 11 Apr 2019 by
MohammedFarooque

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

1 reply Last reply on 9 Apr 2019 by
NazCarr

Excel on mac

Im trying to setup my friends computer to invoice I have run time 1004 error occurring. Any help please Sub NextInvoice() Range("I13").V...

1 reply Last reply on 6 Apr 2019 by
ac3mark

Color cell

Hello, I have this formula to place a date in cell when negative number. =IF(D14

1 reply Last reply on 5 Apr 2019 by
ac3mark

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.

Last reply on 2 Apr 2019 by
mohammed

Need to extract specific xml data from a cell in excel

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 it o...

2 replies Last reply on 1 Apr 2019 by
SM

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 either ...

9 replies Last reply on 26 Mar 2019 by
TrowaD

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 the p...

1 reply Last reply on 25 Mar 2019 by
Ambucias

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 button...

Last reply on 24 Mar 2019 by
ShezzyWiggle

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.

2 replies Last reply on 21 Mar 2019 by
ac3mark
Results 451 - 500 out of a total of 12,267