The discussions

Publisher

 Solved

I downloaded the free version of Publisher but do not see it featured anywhere on my computer?

4 replies Last reply on 24 Mar 2016 by
ac3mark

How to calculate no of days between dates

Hello, How to calculate no of days between one constant date not written in excel sheet i.e. 31-03-2016 and other dates which is written in excel ...

1 reply Last reply on 24 Mar 2016 by
Mazzaropi

Hiding rows when validation list is changed

 Solved

Hello, I have a excel sheet where have two sets of product line. I would need only details for one set of product line visible if i select it in ...

2 replies Last reply on 24 Mar 2016 by
tani

Userform to export data to another sheet

 Solved

Hello everybody, Please could anyone spare his/her scares time to help me, I'm new in this forum and I hope to be an expert in excel. Your contribu...

4 replies Last reply on 24 Mar 2016 by
redbaby

Counting and stop counting days in a cell

 Solved

Hello, I need to create a formula for a cell involving number of days between dates. First cell - counts the number of days before and after du...

4 replies Last reply on 23 Mar 2016 by
diestra123

Match columns and assign a value from 3rd column

I have a list of ticket buyers from a recent event, including their zip code. I have a separate spreadsheet with every California zip code and it's...

1 reply Last reply on 22 Mar 2016 by
Coley925

Excel userform question

Hello, I have spreadsheet with a button on it that opens a userform. This userform will populate data to the same sheet the button is on. How do I...

1 reply Last reply on 22 Mar 2016 by
TrowaD

Vlookup formula help please

 Solved

=IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22 Please everybody, how do I write this formula so as not to return...

6 replies Last reply on 22 Mar 2016 by
redbaby

Vba excel 2013 pleae help

Hello, My question is and if this can be done. Say I have a date entered 3/15/2016 and have information in my excel file. Then I have to enter a...

2 replies Last reply on 22 Mar 2016 by
Nado2oo2

How do i get the sales tax to pop up???

Hello, how do I make it so I cant type in a city and have it so the sales tax automatically inserts itself in? Thank you Configuration: Windows...

1 reply Last reply on 22 Mar 2016 by
Coley925

Conditional formatting one cell based on another excel 2016

Hello, I want to conditionally format one cell in a row based on another cell in the row. i.e. If cell F1 has a value greater than 2009 I want cel...

1 reply Last reply on 21 Mar 2016 by
TrowaD

Need a formula to sum a column with #value error

 Solved

I need a formula that will sum column i8 to i65536 in cell m7 ignoring #value error. Any help? Thanks.

2 replies Last reply on 21 Mar 2016 by
redbaby

Auto copy/paste data if criteria (same value in 2 cells) is met

 Solved

Hello from Barcelona, just signed up ... my first question ... excited :) I have 2 tabs. Tab 1 shows in column B the employee number and in col...

1 reply Last reply on 20 Mar 2016 by
JensBCN

Creating a macro that will create a new sheet and copy data from

Hello, I want my macro to 1) create a new sheet and 2) copy data from another sheet onto the new sheet. For some reason it (my macro) will create...

3 replies Last reply on 19 Mar 2016 by
vcoolio

Duplicating data from one line on sheet 1 to sheet 2

 Solved

Hello, I'm looking for help, I have data in one box on sheet1 one that when I update that data I would like for it to automatically change in a bo...

6 replies Last reply on 19 Mar 2016 by
vcoolio

Publisher

I downloaded Microsoft Publisher for free yesterday and do not like it. I want my old Microsoft 2007 word program back but Publisher has changed all m...

1 reply Last reply on 18 Mar 2016 by
ac3mark

Display a range of cells if a condition (text) is met

well, i am regular for excel. now i need a help, if a cell value, is a particular text, then i want to display a range of cells at a particular loc...

1 reply Last reply on 17 Mar 2016 by
TrowaD

Colour changing in rows determined by text in 2 different cells

 Solved

Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the...

1 reply Last reply on 17 Mar 2016 by
TrowaD

Converting numbers to text

hi I need to convert numbers / date of birth in excel pl suggest / advice thanks

1 reply Last reply on 17 Mar 2016 by
TrowaD

Date formate

Hello, please help me, i have software date format {15/03/2016 5:26 PM} and i need convert to this format {Mar/14/2016} Configuration...

1 reply Last reply on 17 Mar 2016 by
TrowaD

Town/city to lookup county

Hello, I have a spreadsheet that what i am trying to accomplish is that when an address is typed into a column it will look up and match the town a...

3 replies Last reply on 17 Mar 2016 by
TrowaD

Transfer data between sheets in excel

 Solved

Hello, This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab contai...

19 replies Last reply on 16 Mar 2016 by
Anonymouse

Related to outlook

Hi, I am not able to send and receive mails on my outlook 2007.Whenever I am sending mails to anyone i received the mail from system administrator ...

1 reply Last reply on 16 Mar 2016 by
Computertech

Compare values of two separate sheets and returning value

 Solved/Closed

Hello, Configuration: Windows 7 / Chrome 43.0.2357.81 I'm currently working a spreadsheet trying to match values from Sheet 1 Column B with...

Last reply on 15 Mar 2016 by
ac3mark

Using an if statement to compare dates

Hello, I'm trying to compare two dates by referencing two cells. I tried something like this IF(B2>C2, "past due", "on time"). I know to ...

1 reply Last reply on 15 Mar 2016 by
TrowaD

How to have my results in different sheets in one workbook?

Good day I trust you are well? I was hoping you can assist me with the following and will be most grateful for any help I can get: I have to cr...

1 reply Last reply on 15 Mar 2016 by
TrowaD

How to invoke vlookup function in excel vba.

Hello, Please, I need a visual basic code that can actually invoke or call a V Lookup function in Excel to query data in two separate worksheets an...

1 reply Last reply on 15 Mar 2016 by
TrowaD

Recording macro to duplicate page and rename to numeric value

 Solved

Good day I am trying to record a macro that duplicates a page and renaming it to another file name but need to follow in numeric order. I have a...

2 replies Last reply on 15 Mar 2016 by
Shaun@1

Need to find a data in a column and copy below cell data or add

 Solved

Hello , Please help me to solve this, it will be very grateful column A column B column c 1......................... .........2 2.................

2 replies Last reply on 14 Mar 2016 by
hirdesh_saxena

Compare 2 worksheets and update one of them

I am a beginner Excel user and I hope I can get some help here. I am about to purchase a retail business. I have a copy of the master inventory list. ...

1 reply Last reply on 14 Mar 2016 by
TrowaD

Help needed on saving then clearing content except selected rows

Hi I am writing a spreadsheet for my ward for TCI list which has admissions, discharges and transfers. I want to be able to save then clear the c...

7 replies Last reply on 13 Mar 2016 by
vcoolio

Autopopulating data from one main sheet to multiple sheets

Hello, I'm making a workbook for my coworkers to easily know what specific person they need to work with from month to month. I have created a "Mast...

1 reply Last reply on 12 Mar 2016 by
vcoolio

Transfer data from multiple sheets to one sheet.

Hi all, I'm kind of new to spreadsheets. I have 3 sheets each with the same columns. Column 1 has a type and column 2 has serial numbers, column 3 has...

1 reply Last reply on 12 Mar 2016 by
vcoolio

Sending problems

Hello, I am having a problem sending emails from my Outlook. I get it returned in my inbox with the error 554 5.7.1 and it says authentication failed ...

3 replies Last reply on 11 Mar 2016 by
Ambucias

Count days in excel

 Solved/Closed

Hello, How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days. with =NETWORKDAYS(A1,A2) not count the weekends. Thanks F...

Last reply on 11 Mar 2016 by
Banjo

Excel- how do i auto transfer rows of data to another worksheet

Hello all, I am after some help with excel. I am a PE teacher and need to find a way to cut down the processing time for our athletics carnival sco...

1 reply Last reply on 10 Mar 2016 by
TrowaD

Combine of column

 Solved

Hello, How can we show value of more than two column in a single column but in two rows. please reply at the urgent.

3 replies Last reply on 10 Mar 2016 by
TrowaD

Compare values in two columns and return the value from third

Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need t...

1 reply Last reply on 10 Mar 2016 by
venkat1926

Comparing two excel worksheets

 Solved

please, I need a macro code that can actually compare two worksheets and flag up the differences using same color to show the dissimilar rows. Be...

9 replies Last reply on 10 Mar 2016 by
vcoolio

Populate 2 tables at once but one table only if text match

 Closed

Hello, I have 2 tables in separate sheets, I am using a userform to populate table1 and I need a formula to populate table2 as new data it's entere...

Last reply on 10 Mar 2016 by
Computertech

Date function

Hello, I'm using a function =date(year(j2)+(m2),month(j2),day(j2)) BUT.. I want to be able to type in words like NIL, NO, and DEFER in to cell M2...

4 replies Last reply on 9 Mar 2016 by
arieta

Carry forward formula

 Closed

Hello, I'm trying to find if there is any formula to carry forward a figure to another spreadsheet on a daily basis. the cells were not at the sam...

Last reply on 8 Mar 2016 by
Computertech

Drop down list and auto copy data based on date in cell to anoth

Hello, I need help fast. I'm not the resident expert my boss think I am apparently. Excel 2010. I imported info from a Word Perfect document whi...

1 reply Last reply on 8 Mar 2016 by
ac3mark

Copy paste macro needs tweak

 Solved

Hello, I'm new to VBA, and would appreciate any help with this Macro. It copys the mouse input, but overwrites the last paste. I need it to (after I...

2 replies Last reply on 8 Mar 2016 by
frank7788

Vba tricky question

Hi All, I am working on excel and I need some help with VBA/macros. Basically, I have a variable called Y and I have a table of set values, call...

1 reply Last reply on 8 Mar 2016 by
TrowaD

If column a contains any text or if column b contains any text..

Hello, I'd like to achieve in Open Office Calc IF column A contains ANY text then ADD "XYZ" into cell G12 OR IF column B contains ANY text t...

1 reply Last reply on 8 Mar 2016 by
TrowaD

Snapshot for pdf editing

Need free or Microsoft Office PDF editor

1 reply Last reply on 8 Mar 2016 by
Computertech

Compare two csv files

 Closed

Hello, I have two csv files which has member details. I just have to compare both the files and confirm if its similar. Any way to do it through e...

Last reply on 7 Mar 2016 by
Computertech

Printing numerous copies

Hello, I have a seguential numbering macro that numbers a 2 part EWO - I want to be able to run more than 1 set at a time - how do I do that? C...

1 reply Last reply on 7 Mar 2016 by
ac3mark

Sending data from one spreadsheet to multiple speadsheets

Hello, I am fairly new to VBA and have been searching for a solution for my problem but as yet have not managed to find one. I wish to send da...

1 reply Last reply on 7 Mar 2016 by
TrowaD
Results 2251 - 2300 out of a total of 12,266