The discussions

Date drop down on front sheet that will create new dated tabs

Hello, I am trying to create a workbook for recording daily pressure readings from different systems and I am trying to create a front page with a...

1 reply Last reply on 2 May 2017 by
ac3mark

Excel vba - find and expand matching cell entries

 Solved

Hello I have a list of 10 digit numbers in each row of a column range. Some of the numbers start with 3 zeros (000) which results in Excel ignoring...

1 reply Last reply on 2 May 2017 by
x

How to populate information on multiple sheets at once

 Solved

Hi all, I hope someone can help me figure this out. I have been imputing information on multiple sheets in an excel workbook for quite a while now ...

14 replies Last reply on 2 May 2017 by
TrowaD

Outlook 2007 is not sending mails

 Solved/Closed

Hello, Have a nice day. I migrate my data from one PC to another. The old one was having Windows XP operating system along with Outlook 2003 w...

32 replies Last reply on 2 May 2017 by
danigirl

Unable to download complex tables data on webpage using query

Hello, I am trying to figure out a way to download the data from this webpage, which has 4 collapsible sections but no luck whatsoever yet. htt...

3 replies Last reply on 1 May 2017 by
TrowaD

Cant get access on outlook

Hello, dear please i have yahoo account and i want to open on outlook but cant get access please guide me System Configuration: Windows / Firefox ...

2 replies Last reply on 1 May 2017 by
Mark_Wales

Creating 1 master sheet from data from multiple sheets

Hello, So I am at a complete loss on how to solve my problem. I'm brand new to excel and any help would be much appreciated. What I'm wanting t...

1 reply Last reply on 29 Apr 2017 by
vcoolio

Populating a summary report

I've been tasked with taking a large worksheet (>20K rows and 25 columns) and populating a summary report in a (pre-labeled) different worksheet. The...

4 replies Last reply on 27 Apr 2017 by
ExcelNewb17

Autopop info on sheet based on criteria from master sheet.

Hi All, I am creating a Master spreadsheet that has information across rows. I want this information to auto-populate on a different spreadsheet dep...

4 replies Last reply on 27 Apr 2017 by
vcoolio

Date format not valid

Hello, Sir i would like you to help me on the following problem, i am filling an application form and i have done everything but on the date side ...

1 reply Last reply on 26 Apr 2017 by
Zohaib R

Splitting data from worksheet to workbooks based on column

Hello, The code gives prompts me to enter the column on which the split needs to be done, but soon after that thrown an error:Run-time error '1--4...

1 reply Last reply on 26 Apr 2017 by
Zohaib R

If/and function

i need to update a spreadsheet on the progress of documents being approved. i want to create a function that states if the document is "approved" (...

4 replies Last reply on 26 Apr 2017 by
Zohaib R

Shortcut to edit a cell without using f2 key

 Solved

Hello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...

7 replies Last reply on 25 Apr 2017 by
BenFromSingapore

Restoring pst file from hard drive.

 Closed

Hello, Next problem, a hard disk to copy the file .PST mail that houses that work in one place. At home and at work worth outlook 2007. I tried to...

3 replies Last reply on 25 Apr 2017 by
sverrecarlson

Selecting a block of cells depending on the values of two others

Hi all I'm pretty new to macros and I have been unable to find the answer to this question anywhere. I'm trying to write a macro that will selec...

4 replies Last reply on 25 Apr 2017 by
TrowaD

Data in a hot key

 Solved

Hello, I want to put an email address in a hot key so I don't need to type it ever time I need to insert it. Thanks for your help in advance.

4 replies Last reply on 25 Apr 2017 by
TrowaD

Conditional formatting based on column of values

Hello, I would like to do conditional formatting column B if its part of text matches with values in any cell of column C. Could you please help m...

1 reply Last reply on 25 Apr 2017 by
TrowaD

Macro to create worksheets and copy data from a summary page

I have a workbook called Sales Commission and sheet 1 is my summary page. I want to write a macro that will look at the summary page and from column ...

1 reply Last reply on 25 Apr 2017 by
vcoolio

Conditional format if hyperlink

 Solved

Hello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...

12 replies Last reply on 24 Apr 2017 by
ac3mark

Convert a sentence in a cell with the american date

Hello, I am trying to convert a sentence in a cell with the American date last to the sentence with Canadian date last. ex. CASH OVER/SHORT 04/01...

1 reply Last reply on 24 Apr 2017 by
TrowaD

Copy and paste values automatically to empty cells below

Hi - for background, I created a "slot Machine" in excel that combines three random number generators and generates either a -$1 or +$10 if you don't ...

1 reply Last reply on 24 Apr 2017 by
TrowaD

Vba help needed

Hello, I have written code to prompt the user to state how many new sheets they want to add. But I need for the data on the "Main" sheet to always ...

5 replies Last reply on 24 Apr 2017 by
TrowaD

Compare the words in 2 columns in excel

 Solved

I gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new colu...

11 replies Last reply on 24 Apr 2017 by
TrowaD

Drop down menu, copy/transfer 2 new sheets only if cell has data

Hello, I am trying to create a sheet that references items if they are selected from another sheet from a drop down menu. IF they are selected then...

13 replies Last reply on 24 Apr 2017 by
TrowaD

Excel forum within a range

 Solved

Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...

2 replies Last reply on 24 Apr 2017 by
Gerberreinette

Convert wordpad document back to pdf

 Solved

Hello, i as sent a file and wheni went to open it it said open with word or internet i picked word and now its not what i wanted to have done beca...

10 replies Last reply on 21 Apr 2017 by
ac3mark

Need to delete columns based on column header

 Solved

Hello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the columns, Name...

7 replies Last reply on 21 Apr 2017 by
topazfae

Compare 2 columns on different sheets and move data when match

Hello, I need to match 2 columns of data from 2 different worksheets and when they match, I need to move data from another column from one workshe...

1 reply Last reply on 21 Apr 2017 by
ac3mark

Copying an entire list of formulas into another work sheet

Hello, I have a list of sumif statements that I would like to copy from one excelsheet to another. Can this be done all at once, without changing ...

1 reply Last reply on 21 Apr 2017 by
ac3mark

Auto generate dates

Hi All, I am currently working a excel formula to input a Revision_Date in column A then it will auto generate the number of days per month(only we...

1 reply Last reply on 20 Apr 2017 by
TrowaD

Summery sheets

Dear All, I am maintaining a File in Excel for Employee's Vacation and every year has a different file. In this file I am adding a new Sheet by the...

1 reply Last reply on 20 Apr 2017 by
TrowaD

Do i have open office available

Do I have open office available on my computer?

2 replies Last reply on 20 Apr 2017 by
TrowaD

Auto generation of code

 Solved/Closed

Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...

1 reply Last reply on 20 Apr 2017 by
TrowaD

What is the numbe shoud be instead of ??

what is the Numbe shoud be instead of ?? My Values fixed No Results 70064 ?? -11 1721118038 ?? ...

1 reply Last reply on 20 Apr 2017 by
TrowaD

Need macro to copy certain data from a form on one tab to a log

Hello, Trying to copy data from a form on one tab to a log/data list on another tab and advance to the next line on the log for the next user ...

1 reply Last reply on 19 Apr 2017 by
ac3mark

Vba coding to copy data from one worksheet to another worksheet

Hello, I would like to know how to use vba coding to automatically copy data from one worksheet to another worksheet based on a specific criteria an...

3 replies Last reply on 19 Apr 2017 by
ac3mark

Filter between 2 dates

Hello, please i want to filter data between 2 dates (start date and end date) with textbox and button command, i am new to programming in vba; plea...

1 reply Last reply on 19 Apr 2017 by
kadrleyn

Pdf document "converted" to word is not editable

 Closed

I downloaded your PDF to Word conversion software. I then did a conversion so that I could do some editing of my document that I had previously create...

1 reply Last reply on 18 Apr 2017 by
Ambucias

Excel - a macro to create new workbook and copy data

 Solved/Closed

In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...

29 replies Last reply on 18 Apr 2017 by
TrowaD

Converting software

What is the best software download that will convert both excel and word PDF files into usable excel and word documents for Windows 7?

1 reply Last reply on 16 Apr 2017 by
Ambucias

Word doc automatically changes to pdf

Hello, How do I save a Word Doc as a Word Doc? When I go to the doc a second time ,it automatically changes it to PDF with all kinds of changes. So ...

1 reply Last reply on 16 Apr 2017 by
72Tigers5

Excel - macro to create multiple sheets

 Solved

Hello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...

5 replies Last reply on 14 Apr 2017 by
vcoolio

Comparing columns and returning value

 Solved/Closed

Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...

35 replies Last reply on 14 Apr 2017 by
kittu

How do i calculate vat inclusive

Hello, how do i calculate VAT inclusiev? for example, TZS 849235 is vat inclusive, how do I take out the VAT? Taking VAT as 18% System Configur...

1 reply Last reply on 13 Apr 2017 by
Mazzaropi

How can i get my cvs out of my old office

Hello, how can I get my cvs out of my old office System Configuration: Windows / Edge 14.14393

1 reply Last reply on 12 Apr 2017 by
kieferschild

Change of date

Hello, I Want to change date format mm/dd/yyyy to dd-mm-yyyy in MS Excel 2003 Please solve my problem urgently System Configuration: Windows ...

1 reply Last reply on 12 Apr 2017 by
BunoCS

Import .pdf ...?

 Solved

Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...

2 replies Last reply on 12 Apr 2017 by
RickRoll

Highlight date range if cell containing date falls within that range

Good day! I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell....

5 replies Last reply on 10 Apr 2017 by
Zohaib R

Freezing column and row

Hello, how do you freeze first column and top row in excel?

1 reply Last reply on 10 Apr 2017 by
vcoolio

Lotus sympony to word

FILE FROM LOTUS SYMPONY COULD NOT BE OPENED IN MICROSOFT WORD WHAT TO DO

1 reply Last reply on 9 Apr 2017 by
ac3mark
Results 1351 - 1400 out of a total of 12,260