The discussions

Is this possible (if with dates)

Hello, I need some help with what to input into Excel for a function I'd like to see. What I'm looking at doing is: Lookup all dates on "s...

3 replies Last reply on 8 Jun 2016 by
ac3mark

If function using dates

Hello, I'm trying to write a function that will use an divisions data and turn it into manageable data. They record in their spreadsheet an en...

1 reply Last reply on 8 Jun 2016 by
ac3mark

Need to extract data from a cell in a macro enabled sheet

Hello, I created an invoice for my business with a macro to run so that every time I click on a certain cell it will save that sheet into a new work...

1 reply Last reply on 8 Jun 2016 by
ac3mark

Conditional formating question

 Solved

Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has ...

2 replies Last reply on 8 Jun 2016 by
sforde

If formula with dates

 Solved

Hi, I would like to set an IF formula which flags me if someone has been working with us as temp for more than 12 weeks... so I have start date and en...

2 replies Last reply on 8 Jun 2016 by
CeskyWater

Excel formula question.

I have these cells info. CBSA ; RCMP EC ; FO ; HCAN ; NATRES ; ND CRA ; PSC ; PWGSC ND ; PWGSC ACOA ; CFIA ; CRA ; CSC ; FO ; HRSDC ; PWGSC ...

5 replies Last reply on 8 Jun 2016 by
RayH

Copy row from one sheet to other based on 2 conditions

Hello, Any assistance would be very much appreciated I'm just getting into macros and coding. I'm trying to copy a list from sheet 4 and input the...

1 reply Last reply on 8 Jun 2016 by
kadrleyn

Search 4 worksheets, copy rows to 5th

Hello, I am using Excel 2010. I am new to the forum and have a very basic knowledge of VBA. I am trying write a macro that takes info provided...

1 reply Last reply on 7 Jun 2016 by
ac3mark

Moving data

Hello, this is driving me mad and im sure its simple. i have 2 sheets in 1 workbook. if column F on sheet 1 contains the word "YES" i need it to ...

3 replies Last reply on 7 Jun 2016 by
novice

How do you make a vba function in removing a specific value in a

How do you make a VBA function in removing a specific value in a cell. Example: remove "#, " and ", #" #, 1, 2, 3 1, 2, #, 3 1, 2, 3, # Res...

3 replies Last reply on 7 Jun 2016 by
RayH

Excel, if column terms match text in range b equal to or less th

Ive been racking my brain, the attached photo illustrates roughly what Im trying to do, top and bottom images illustrates a collection if 12k pictures...

3 replies Last reply on 6 Jun 2016 by
RayH

Copy answers from 1 sheet to another based on condition - vb

I want to copy description mentioned in particular cell only when the adjacent cell (i.e. adjacent column cell) says 'YES' . I want to copy this descr...

2 replies Last reply on 5 Jun 2016 by
Ritika.gup

Auto. transfer rows of data to a new sheet based on 1 variable

Hello, I'm currently working with some data that needs to be broken for better viewing purposes and presenting to non-data minded people. It's goi...

1 reply Last reply on 3 Jun 2016 by
vcoolio

Creating master spreadsheet for mailing information

 Solved

Hi there, So I am creating a workbook, for work, for our marketing, and I need help. We are completely revamping what has been done before and I wa...

12 replies Last reply on 3 Jun 2016 by
vcoolio

Macro only for alphabetic sheets

 Solved

Hello, I would like to request for a Macro which will run only for those sheets where Names started with Alphabets from A to Z Thanks & Regards...

2 replies Last reply on 3 Jun 2016 by
smuneeb

Compare and combine two sheets into one

Thank you in advance! I have one excel spreadsheet with rows of customer contact information and the account they are associated with. I have an...

1 reply Last reply on 2 Jun 2016 by
mattgdunn

Vba coding vlookup to single workbook from different tabs

Hello, I am trying to pull data through Vlookup to master sheet from different worksheet which is having a different tabs for different client. ...

1 reply Last reply on 2 Jun 2016 by
mattgdunn

Comparing data

I have two sheets with data, for example product name, quantities sold and price. All product names on sheet 1 may not be there on sheet 2. So what i ...

1 reply Last reply on 2 Jun 2016 by
mattgdunn

Two lists of names that are jumbled up

Hello, How are you all? I have two lists of names, one has all the names (A) e.g. Michael Luis Stevens, the other does not or the name is jumbl...

1 reply Last reply on 2 Jun 2016 by
mattgdunn

Excel vba to open a eula script when opening a spesific workbook

 Solved

Hi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected using vb...

3 replies Last reply on 2 Jun 2016 by
vcoolio

Vba macro copy and paste loop help

I need to create a macro that allows me to copy and paste a set of formulas/values down a certain number of times. For example, if I had the following...

3 replies Last reply on 2 Jun 2016 by
ac3mark

Conditional formatting

Hello, Can someone help in figuring out a formula. If in the spreadsheet I enter under the condition column "good" or "bad" I need the next column...

4 replies Last reply on 2 Jun 2016 by
Mazzaropi

I need your help with macro's please

Hi there, I have been doing some reading up & watching YouTube tutorials regarding Macro's that will copy data from one sheet to another if certain c...

5 replies Last reply on 2 Jun 2016 by
TrowaD

If value in column a exists between values in column b and c

Hello, Looking for assistance on the following: I want to know if value 302000000 (column A) exists between value range 382777400 (column B) and...

5 replies Last reply on 2 Jun 2016 by
vcoolio

Copy all rows with specific name to new sheet

 Solved

Dear Friend, Am having a Excel Timesheet with following columns SITE - EMP NAME - EMP ID - EMP JOB TITLE - DATE - TIME IN -TIME OUT - TOTAL - NOR...

15 replies Last reply on 1 Jun 2016 by
vcoolio

Vba to change cell colors and highlight rows

Here is what I have going on. I have a spread sheet, across the top are the dates of days that my crew works and the first column is everyone on the c...

2 replies Last reply on 1 Jun 2016 by
mikkelsheeto

Converter for pdf to word document

 Solved

Hello, I would like to know how to get the software for converting PDF documents to Word documents.

2 replies Last reply on 1 Jun 2016 by
ccmmember

Macro that will allow tab 1 's information to be copy to tab 2

 Solved

Hello, Please help. My Excel Workbook has two tabs. Tab 1 contains all project information such as project number, customer name, project name, co...

2 replies Last reply on 28 May 2016 by
HappyPerson

Transfer a row of data from one sheet to another same workbook

 Solved

Hello, I am trying to transfer a row of data from one sheet to another in the same workbook but my code is not working could anyone help me thanks...

25 replies Last reply on 28 May 2016 by
vcoolio

Booklet design software

Please, I am looking for a simple booklet design software that I can easily manipulate. thanks

1 reply Last reply on 27 May 2016 by
Ambucias

Compare two cells in excel and if matches need to print its adja

Hello, I want to compare two cells in excel and if matches need to print its adjacent value in next column. for example: I need to compare colu...

1 reply Last reply on 27 May 2016 by
ac3mark

Convert number to letters in excel

 Solved

Hello, I have to define the numbers to their associated letters and based on the combination of numbers the next cell should show the letters. ...

25 replies Last reply on 27 May 2016 by
hachiya

Convert date of birth into words

 Solved

Sir, Kindly help me in changing date of birth into words. Example:20.03.2001 as twenty march two thousand one

1 reply Last reply on 27 May 2016 by
vcoolio

Pdf to other format converter software.

Hello, I want pdf to other formats converter software which should be free and easy download and not trial version. Whole document should be conve...

1 reply Last reply on 27 May 2016 by
Ambucias

Macro copy paste from one to another based on cell value

Hello, I have two sheets. Phase I and Phase II. Phase I I have columns A-J. Im looking for a macro which would copy columns A-F and paste it to she...

1 reply Last reply on 27 May 2016 by
vcoolio

Automatically moving data

 Solved

Hello, I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I ...

22 replies Last reply on 27 May 2016 by
vcoolio

Moving data

Hello Peeps, I'm having some trouble with using a macro to copy some data from one sheet across multiple. I have a master sheet that contains train...

2 replies Last reply on 26 May 2016 by
vcoolio

Find word within cell & put "value from a list" in adjacent

Hello, If cell A contains a short statement (e.g: 'supply of computers', 'supply of furniture', 'construction of water taps' and 'construction ...

3 replies Last reply on 26 May 2016 by
Mazzaropi

Create macro to create worksheets based summary sheet

Hello, I have an extremely long list of inventory items by department number. What I want to do is create a individual worksheet for each departme...

4 replies Last reply on 25 May 2016 by
vcoolio

Autofill and open worksheet

Hello, I am wanting to be able to search and open worksheets by typing the beginning of a worksheet. I have worksheets X,Y,Z and if I begin typi...

5 replies Last reply on 25 May 2016 by
ac3mark

Search cell for multiple text strings, return each found value

Hello, I have a basic function to search a cell for a specific text string (in this case, the name of an application) and return a value to anoth...

1 reply Last reply on 25 May 2016 by
ac3mark

Need vba help

Im pretty sure i will need VBA for this issue and I have no clue. I setting up an online store and I would like to track all my stock and transaction...

1 reply Last reply on 25 May 2016 by
ac3mark

Due date alert from excel file when windows startup

Hi, I need clarification that we can create due date alert from an Excel file when windows start up. Is it possible. If yes, Please advice how to c...

3 replies Last reply on 25 May 2016 by
ac3mark

How to create an text based spreadsheet

I have access to Excel 2010 in an MS Office Suites. What I am try to do is to create a spreadsheet where I can enter a designated code (i.e. A1, A2...

3 replies Last reply on 24 May 2016 by
ac3mark

Location master file in excel

 Solved

I have location master file in excel. 1) I have another file in A2 column there is a address like 422, Ashok Vihar, New Delhi, 2) i want to brin...

1 reply Last reply on 24 May 2016 by
ac3mark

Create new excel file from existing excel file.

Hello, I want to create a command button in a existing excel file that will pop-open a new excel file. (it will be good if it ask me "Save as" for ...

1 reply Last reply on 24 May 2016 by
ac3mark

How to fix doc and docx file?

Hello, Hi! I have couple of ms word documents that I cannot open, they somehow got damaged and I get an error when trying to pen these files "...

4 replies Last reply on 24 May 2016 by
VlastimilJelinek

Software development

 Closed

i want a big software for our company and i also want a software engineer to operate our software and handle all the programs.

1 reply Last reply on 24 May 2016 by
BunoCS

If "yes" in a column copy other cells to the next tab.

Hi Guys, I have a sheet with participant names and a lot of other information about their attendance. What I am trying to do is to copy their name ...

1 reply Last reply on 24 May 2016 by
vcoolio

Sales invoice in sheet1 and create summary table in sheet2

hi im working on sales/inventory worksheet. i made the sales invoices in sheet1, now i want all the details of sales invoice in sheet 2 to create ...

1 reply Last reply on 23 May 2016 by
vcoolio
Results 2051 - 2100 out of a total of 12,249