The discussions

Failing to sign in to excel

hie can you be of assistance im failing to sign in to excel it keeps telling me that there is a problem with my account. i have tried resetting the pa...

3 replies Last reply on 30 Apr 2018 by
Ambucias

Excel "if" function w/ date in test cell

 Solved/Closed

Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho...

Last reply on 29 Apr 2018 by
salim

Updating a sheet name in excel without macros?

Hey everyone, I've been working on a project and in order to do it how I was planning, I need to update sheet names dynamically without using macro...

3 replies Last reply on 26 Apr 2018 by
ac3mark

The problem with acrobat reader

Earlier was the sixth version and one day( I do not know from what) has ceased to print files. Then I removed it, and tried alternately to install 7 a...

1 reply Last reply on 26 Apr 2018 by
xpcman

Calculate how many times member a visit the cafe

Hello, member A register at cafe on a date 12 april 2017. He visited the cafe every times started from the registed date when the cafe opened at ...

1 reply Last reply on 26 Apr 2018 by
TrowaD

Transferdata from 1 sheet to other sheets criteria

Greetings! I have been trying to look for vba codes and formulas but am still at a lost as to how to even start. Am a total newbie at this whole vb...

1 reply Last reply on 24 Apr 2018 by
ac3mark

Auto update a workbook with multiple sheets on one sheet of the same workbook.

Good pm. I need your help in order to enable me carry out update in ms excel. I have a workbook with multiple sheets (namely, creche , nursery1, ...

1 reply Last reply on 24 Apr 2018 by
ac3mark

Table values used to auto calculate and return val

Is there a way in a formula to have Excel continually look in a table, and insert a value in a cell , so that the value in another cell will never be ...

13 replies Last reply on 24 Apr 2018 by
ac3mark

Vlookup formula gives error

=VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)+G29 This is my formula. It is supposed to look f...

6 replies Last reply on 24 Apr 2018 by
TrowaD

Copy data from one sheet to another

How can I copy data from one sheet to another on the basis of value in cell G10, say if value is DELHI then set of column corresponding to delhi will ...

1 reply Last reply on 23 Apr 2018 by
ac3mark

Concatenate columns in excel

Hey actually i have a prob, i have 4 columns in my excel sheet, among them based on 2nd column i have to concatenate the contents of 4th column...

1 reply Last reply on 23 Apr 2018 by
ac3mark

Pulling in missing data between spreadsheets

I receive a spreadsheet every week that has a list of IP addresses of servers that need updates. Not all servers need updates every week so this sprea...

1 reply Last reply on 23 Apr 2018 by
TrowaD

Salary calculator in excel

I want to make a salary calculator( in excel ) in which I want to add 3% increment in "basic". My columns are :---- 1. "Month"=march 2017, April 2017 ...

1 reply Last reply on 23 Apr 2018 by
TrowaD

Auto populate specific data from sheet to another

Hello, I'm trying to auto populate data from one workbook to another, or sheets if that makes it easier. In the sample I've included I'm trying to...

1 reply Last reply on 23 Apr 2018 by
TrowaD

Adding fields to formula at one time

Hi guys, Not sure if there's a quick way for this: Do you know if possible to do this: Sheet 1 A1 field contains formula: sheet 2 A1 plus sheet 3 ...

1 reply Last reply on 23 Apr 2018 by
TrowaD

Excel date conditions

I have to go in every 2 weeks to update a spreadsheet, based on whether the date in the row is current or in the past. Is there a way to set it up s...

3 replies Last reply on 20 Apr 2018 by
ac3mark

Copying non blank cells from one sheet to another

Hi all I have some code here that works great but I am looking at adding in some additions. I am currently struggling and I hope that maybe someone on...

2 replies Last reply on 19 Apr 2018 by
JohnMcLaughlin

Extract missing word from text string

Hello, Hello, i have data in 2 columns, for ex: Column A: Bearing, Ball, 1/2 in, Cast Iron Column B: Bearing, Ball, Cast Iron by s...

3 replies Last reply on 19 Apr 2018 by
TrowaD

Change color for specific number of cells by value

 Solved

I have a excel sheet with data of planned and pending projects. In column "I" it states number of weeks required for completion of the project. Each r...

3 replies Last reply on 19 Apr 2018 by
TrowaD

Auto populate from master file to other

 Solved

Hi Good afternoon!! I have a master data file that comprises of data of overall activities of the project including sales,contract value, wo...

7 replies Last reply on 19 Apr 2018 by
TrowaD

Vba copy data based on count result

Hi, I am trying to build in the following code in order to count how many cells in a row have data. Based on the count I then need to Copy cells by t...

2 replies Last reply on 18 Apr 2018 by
JohnMcLaughlin

Microsoft office and home page

i cant find my microsoft office that i have downloaded

2 replies Last reply on 17 Apr 2018 by
Ambucias

Top 10 in descending order

Hi guys, I'm struggling to find a solution for this. There is a list that contains, time-frame as Q12016 up until Q42018, then cities as London, Pa...

2 replies Last reply on 17 Apr 2018 by
DG83

Autopopulating data from master excel to new excel

Hello All, I am stuck with a problem and would appreciate if someone can help me. Here my question. I have a master sheet where column A, B, C e...

1 reply Last reply on 16 Apr 2018 by
ac3mark

Copy data in one worksheet to another vba

Hi all, I am trying very hard with little success to automate this with VBA. I am trying to copy data from Sheet1 Row1 in Column A, B & C and t...

14 replies Last reply on 16 Apr 2018 by
ac3mark

Auto create info sheets from master spreadsheet

 Solved

UPDATE: I am able to automatically generate the excel sheets and then automatically convert those sheets into separate files using a macro. My remaini...

3 replies Last reply on 16 Apr 2018 by
ac3mark

Formula that will adjust dates based on a change

what formula can i use so that the days (mondays-sundays) will automalticaly adjust when im changing the date (March 12, 2018)? It's for the DTR (dail...

3 replies Last reply on 16 Apr 2018 by
ac3mark

How to convert numbers into words

Hello Sir, Is it possible to make the words within brackets? System Configuration: Windows / Chrome 65.0.3325.181

3 replies Last reply on 16 Apr 2018 by
Ambucias

Query on developing table and chart automatically

Hello, Please guide me how to develop a table & chart automatically based on the below input data. I am able to develop table and chart manually ...

1 reply Last reply on 13 Apr 2018 by
ac3mark

Excel cell value on a slide

Hii, I want to display on a slide the variable value calculated on an excel sheet. This sheet contains value used for a graph. Thanks in advan...

1 reply Last reply on 13 Apr 2018 by
ac3mark

Automatically move data from one sheet

How to automatically move/copy data from one sheet to another if certain criteria met. Hi. I have two sheets, sheet1 I have data where each cell has ...

1 reply Last reply on 12 Apr 2018 by
ac3mark

Microsft word icon is gone.

 Solved/Closed

Hello, I have a question. Until recently there has been a Micorosft icon on my desktop and it showed up under the "All Programs" list on my Start ...

Last reply on 9 Apr 2018 by
Schly

Conditional formatting

I have cell G8 in excel which is a time stamp. I want it to be highlighted when it is greater than cell A8 which is a scheduled time.

3 replies Last reply on 6 Apr 2018 by
ac3mark

Convert pdf to word without altering pdf images

 Solved/Closed

Can converting from PDF to word be done without alterations of the PDF images?

Last reply on 6 Apr 2018 by
Ceemaru

Copy data from one workbook to another

Hello, I have to save data from one Sheet 1 of Workbook 1 to Sheet 1 of workbook two. EX: Sheet 1, Workbook 1 Date Name Salary 1/1 ABC 100...

1 reply Last reply on 5 Apr 2018 by
ac3mark

Consolidate based on a value in excel

Hi All, I have 2 worksheets and i want to consolidate them into a third sheet based on the value of column P. If column P on either sheet (named...

5 replies Last reply on 5 Apr 2018 by
ac3mark

Excel - lookup query...

Hi, I'm trying to find something similar to this but I'm having trouble. Im no way an expert but I know my way around and basic functions.... ...

2 replies Last reply on 5 Apr 2018 by
TrowaD

What is product key for ms office 2010

Kindly tell the Product Key For MS OFFICE 2010

2 replies Last reply on 4 Apr 2018 by
Ambucias

Convert data with rows into columns

Hello, I wanted to convert huge amount of data with rows into columns , with few conditions please let me know if you can help. System...

2 replies Last reply on 3 Apr 2018 by
TrowaD

Find partial text match

Hi, Please help me with the function to highlight a partial text Matches in column with other column. For example Column A: SWDP9233 When a co...

1 reply Last reply on 3 Apr 2018 by
TrowaD

Copy single row from working file to master file

Hello Sir, I have one working file containing multiple rows, I have one other Master file with 2 tabs. I need to copy Single row from working file ...

3 replies Last reply on 3 Apr 2018 by
TrowaD

Use in scripting.dictionary- item join string 3col

 Solved

Hello, I'm looking for example to use scripting.dictionary. on topic user Smallman1 https://ccm.net/forum/affich-947210-any-faster-version-of-the-sa...

1 reply Last reply on 28 Mar 2018 by
mokie1

How to change date format from yyyymmdd to mm/dd/yy in excel?

 Solved/Closed

Hello, I have data with dates arranged in yyyymmdd format. Is there an easy way to change the format to mm/dd/yy in Excel 2010? Thanks!

Last reply on 28 Mar 2018 by
Sf

How can i automatically copy table to next sheet?

 Solved

Hello, I have an Excel file with 30 sheets containing the same table. In the table, the last column is a Yes/No (using data validation). Once a d...

13 replies Last reply on 28 Mar 2018 by
vcoolio

Small business tracking in excel

I have not found a small business software that meets my needs, and have created a tabbed spreadsheet. However, it has become a bit cumbersome, and ...

1 reply Last reply on 27 Mar 2018 by
TrowaD

Copy and paste spaces inbetween data into a range

Hello, I have file of student registrations that arent exporting to excel to properly. So I decided to copy all the cells and paste it into excel....

1 reply Last reply on 27 Mar 2018 by
TrowaD

Using vba code to search and minus cell value

Hello! I'm desperately trying to do a macro button that can lookup a table's column and row headers (from 2 lookup_values entered in 2 cells), then...

1 reply Last reply on 27 Mar 2018 by
TrowaD

Required value as per the scanned data

Hi Everyone, I use VLOOKUP on a very frequent basis for my day to day work. I have a sheet full of data of inventory while doing my stocks audi...

1 reply Last reply on 27 Mar 2018 by
TrowaD

Change date format dd.mm.yyyy to dd/mm/yyyy

 Solved/Closed

Hello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2003 Please solve my problem urgently Shatrughna System Configuratio...

Last reply on 26 Mar 2018 by
Ray

Excel partial match

 Solved

Hello, Hello, I have a small query related to Excel Search function. Suppose I need to search the below data in target cell which has some ...

6 replies Last reply on 25 Mar 2018 by
machoman4lyf
Results 751 - 800 out of a total of 12,267