The discussions

Excel formula - add days to date based on drop down selection

 Solved

I want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...

3 replies Last reply on 17 Aug 2017 by
Mazzaropi

Comparing two excel sheets and copying like data to third sheet

Hi, In your below coding, I can copy paste the alike data from sheet 1 only, I need to copy paste both from sheet 1 and sheet 2 line by line matchi...

1 reply Last reply on 16 Aug 2017 by
ac3mark

I am facing problem after download the ms office 2010

hi ,, I am having a problem after download the ms office 2010.. it is not opening .. please tell me the solution .. ASAP

1 reply Last reply on 16 Aug 2017 by
ac3mark

Vba: cell range

Hello, I am a beginner with VBA and I have a question that might sounds stupid to some. I have created a function of IfElseIf and I want to run it...

3 replies Last reply on 16 Aug 2017 by
ac3mark

Search for text , cut and paste into new work sheet

Hi , can anyone help me with the below vba code : Logic Find text If next row starts with number Then - cut 1 row above text and 3 rows below ...

1 reply Last reply on 16 Aug 2017 by
JoeRooney

Transfer data from one sheet to another

Hello, i have started an inventory sheet on excel what I want to do is take the list of inventory and when it is sold, have it transfer to the second ...

2 replies Last reply on 15 Aug 2017 by
themorgan

How to compare two excel sheets and combine matching data

Hello, I'm looking for a macro that will match data in column A from sheet 1 to the data in column A from sheet 2 and copy the corresponding rows f...

1 reply Last reply on 15 Aug 2017 by
vcoolio

How to auto-populate values from certain cells into a new sheet

 Solved

Hello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...

18 replies Last reply on 12 Aug 2017 by
vcoolio

Copy and paste entire row if a specific cell agrees with if cond

Hello guys! I have been writing a vba code for a while and I cant find the mistake that I am making... I have a big table and I am comparing the va...

13 replies Last reply on 12 Aug 2017 by
PeriGr

Date entered wrongly

Hello, I entered dates as 'Apr 24' wherein I meant 24th of April..Excel has taken it to be '01 April 2024'..how do I correct all such entries, if ...

1 reply Last reply on 11 Aug 2017 by
ac3mark

How to highlight a row when i enter a date in column i

Hello, I am trying to highlight a row when I enter a date in column I. How is this achieved?

1 reply Last reply on 11 Aug 2017 by
ac3mark

Copy specific number of rows and insert n time after 3 rows

Hello, Please help I want to Select & copy 35 rows data and after 3 rows I want to insert the copied rows n number of times. I need the Row widt...

1 reply Last reply on 11 Aug 2017 by
ac3mark

Highlight only one column which has greater value

 Solved

Hello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...

3 replies Last reply on 11 Aug 2017 by
Mazzaropi

Office 2007 files will not open

 Solved

Hi.. I am Dipu Michael from India. I am using the software office2007 in windows7.For the checking purpose I installed 0ffice 2003 in my system. Afte...

1 reply Last reply on 10 Aug 2017 by
xpcman

Date conversion in excel

Hello, how to convert birth date in word in MIcrosoft excel

1 reply Last reply on 9 Aug 2017 by
xpcman

Consolidate data from multiple sheets to one sheet.

Hello, I have a workbook containing customer data (name, contact #s, addresses, etc.). The workbook is broken down into sheets according to which ...

3 replies Last reply on 9 Aug 2017 by
vcoolio

Microsoft publisher 2010 ask product key,

 Closed

I downloaded microsoft Publiser 2010 but now they ask product key, where can I find

Last reply on 9 Aug 2017 by
pan

Auto update hyperlink on the other sheet

Hello guys =) Please help... I have a sheet with names and IDs which are in hyperlink and the same data i have also in the other sheet. If the I...

3 replies Last reply on 8 Aug 2017 by
eunice3301

Replace 2007 office word

Hello, I have received an e-mail that my Office 2007 is being retired and I will need a new key. My computer is a Microsoft 10 system. Do you have a...

2 replies Last reply on 6 Aug 2017 by
xpcman

Excel if statement with multiple text values in a column

Hello, I am using excel 2017. I am trying to use this if statement to give me a value of 1 or 0. =IF((CQ2="Computer");1;0) The problem i...

1 reply Last reply on 5 Aug 2017 by
Mazzaropi

Excel 2016 filters do not work

Hello, My filter stopped working in 2016. It is completely inactive - doesn't show any other option only the one it froze on. In the menu the filt...

1 reply Last reply on 4 Aug 2017 by
ac3mark

Vba code to range of days

Hello, Please help guys... I have a code below: Sub Auto_Open() Dim r As Long For r = 2 To 53 If Range("I" & r).Value = Range("I...

4 replies Last reply on 3 Aug 2017 by
ac3mark

Enter current time in a cell by clicking it

 Solved/Closed

Hello, I'm trying to minimize the effort to input data in a sheet I've built for recording time for dispatched workers I need to find a way to fil...

Last reply on 2 Aug 2017 by
avega

Powerpoint stop working

i have downloaded Microsoft office 2010 but unfortunately, power point is not working please help me

1 reply Last reply on 2 Aug 2017 by
Ambucias

Conditional formatting

Hello, If I have a value on one cell "D3"of let's say "2" and in cell F3 a value of let's say "1" then I want cell G3 to say a text, let's say "Good"...

3 replies Last reply on 1 Aug 2017 by
Mazzaropi

Vba worksheet data transfer

hello, I haven't done anything with code for years and I am so lost in this, I have a table on sheet 1 which goes from A-J and 1-8221 and conta...

5 replies Last reply on 1 Aug 2017 by
Unhappydoughnut

Run all vba at once after opening excel file

Hello, Please help me. I want to run the macros at once after opening the excel file. I have different codes in each sheet. Please i need yo...

2 replies Last reply on 1 Aug 2017 by
eunice3301

Looking up 2 columns and displaying 3rd column on new sheet

I am trying to figure out how to display the color onto a second worksheet. If column a=1 AND column b=1, then I want the value of C2 displayed on...

1 reply Last reply on 31 Jul 2017 by
ac3mark

Office 2013

Hello, i need office 2013 System Configuration: Windows / Chrome 60.0.3112.78

1 reply Last reply on 31 Jul 2017 by
Ambucias

Run a macro only for specific cells

Hello, can you please help me with one problem I am currently having with Excel Macro? I want to be able to run a macro only for specific cells .....

2 replies Last reply on 31 Jul 2017 by
PeriGr

How to repair xlsx excel 2010 microsoft file?

 Closed

Hello, How to repair xlsx Excel 2010 Microsoft file? I see a file with non-zero size but cannot open it. System Configuration: Windows / Chrome...

Last reply on 31 Jul 2017 by
Priyanka

Installing office 2010

 Closed

Hello, Downloaded Office 2010 for home and student but having problems installing. Please advise how to resolve the downloading problem. Tha...

Last reply on 30 Jul 2017 by
xpcman

Enter data into a master sheet to update subsequent sheets.

I'd like to be able to enter data into a master spreadsheet which will update other spreadsheets to prevent me from having to enter the same data seve...

1 reply Last reply on 30 Jul 2017 by
vcoolio

How to recover my important file of ms word

Hello, i was created one MS word document file in document folder, my windows was corrupted then i format disc c & install new win 7 but now...

1 reply Last reply on 29 Jul 2017 by
Ambucias

Search and code

Hello, so I have this problem in excel where I need to compare the words that are in a certain cell and compare them to the separated word if it finds...

4 replies Last reply on 28 Jul 2017 by
stankirsolkar

Macro code help - copy row based on criteria paste on one sheet

Hello, I have a spreadsheet that is tracking sales number from multiple sales people. Each person has their own tab & all the columns are the same...

1 reply Last reply on 28 Jul 2017 by
ac3mark

Auto populating data

Hello, i have to daily update supplier name, part name , part number to my daily list . i want it to auto populate this to all my master-sheet , i ...

1 reply Last reply on 28 Jul 2017 by
ac3mark

Formulas

I know the basic but I am trying to formulate cells that will automatically that when you enter a figure in the cell it will multiply that said number...

3 replies Last reply on 28 Jul 2017 by
ac3mark

Automatically insert rows in associated spread sheets

Hello, I have created an accounting workbook of 15 sheets to produce accounts and associated information for a group of around 85 people. The names...

2 replies Last reply on 28 Jul 2017 by
ManxEd

Formatting a cell containing text

I have a task tracker where once the task is completed and the 'hasten' cell is 'yes' then I want the entire row to be formatted so the text within th...

1 reply Last reply on 28 Jul 2017 by
stankirsolkar

True or false value based on 3 difference cells' criteria

 Solved

Hello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...

1 reply Last reply on 26 Jul 2017 by
ac3mark

Copying rows with data from multiple sheets to one master sheet

Hi guys, I'm trying to figure out how to copy rows from multiple sheets with values in column Q to a master sheet. I have seen a set of codes a...

1 reply Last reply on 26 Jul 2017 by
vcoolio

Saving input into 2nd worksheet while keeping the 1st empty

Hi there, Spoiler alert: Excel dummy I hope you can help me with this. I need to have a worksheet that would be used on daily basis and can be ...

1 reply Last reply on 25 Jul 2017 by
TrowaD

Compare and separate data

Hi, I am obviously new to the forum here, but I came across a question kind of inline with my own on here and wanted to see if I could get some hel...

3 replies Last reply on 25 Jul 2017 by
TrowaD

Acrobat reader gets the error

Hello! The problem is that: I downloaded a PDF fixe document, when read with Acrobat Reader gets the error: "an error Occurred while opening this docu...

6 replies Last reply on 25 Jul 2017 by
withers

Inventory master list help

Hello, So I have a workbook with an inventory master list that i would like to pull inventory numbers from all of the other sheets in my workbook....

1 reply Last reply on 24 Jul 2017 by
ac3mark

Record scenario iteration results macro

Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations using a macro a...

1 reply Last reply on 24 Jul 2017 by
ac3mark

Converting data in one column spanning three to four rows

dear sir i have an address book over 500 addresses in column A. i am not able to index the book alphabetically i need to shift the data in a2 of ...

5 replies Last reply on 21 Jul 2017 by
BrianGreen

Product key

 Closed

hi, how can I get my product key for Microsoft office 10 free?

Last reply on 21 Jul 2017 by
xpcman

Macro for coloring cells according to the value of the cell

Hello, I have 10 experiments. Every experiment has some info (for example temperature, pressure etc) like it is on the picture. So each experiment...

1 reply Last reply on 20 Jul 2017 by
ac3mark
Results 1151 - 1200 out of a total of 12,267