The discussions

Master sheet data

I have a master sheet on Excel with inventory of uniforms and who is assigned to each piece of uniform, ex: Gordon has #4 hat, #22 coat and #88 pant. ...

5 replies Last reply on 21 Oct 2015 by
rizvisa1

Want to add new colom if a text is found in a cell range

Hello Everybody, As shown in attached fig. I want to write in foundIn colom if a text in authors colom is present in Publications colom. If it is fo...

3 replies Last reply on 21 Oct 2015 by
rizvisa1

Inputting a text based on another column text.

Hi, Hope all is well. I was wondering if you can help. I cannot figure out the formula to automatically add text to one cell base on another c...

3 replies Last reply on 21 Oct 2015 by
bimmy80

Macro or help with populating data after inputting

I would like to be able to enter information into the sheet shown daily (therefore every day different and new data will be inputted into this main sh...

3 replies Last reply on 20 Oct 2015 by
ac3mark

Excel /vba - copy data from one work book to another

Hello All, Can you please help me to make VB program for an excel file. Basically I want to copy the data from an excel work book which is located...

9 replies Last reply on 20 Oct 2015 by
rizvisa1

Entering current time in specific cells

 Solved

Hi, I am using a workbook where I record the time that I give each of my students an exam. I am using a tablet and I would like to be able to touch (o...

3 replies Last reply on 20 Oct 2015 by
rizvisa1

Excel dynamic matching

hiya, i have three sheets: sheet 1 - detail is input manually someone's name and personal details sheet 2 - a sheet that takes some detail f...

1 reply Last reply on 20 Oct 2015 by
rizvisa1

Count the number of days from start date to end date

Hello, I want to count the number of days from start date to end date. ie. 1/2/15 - 1/4/15 is 3 days.

2 replies Last reply on 20 Oct 2015 by
rizvisa1

Need help with formula

I am needing some help with a formula...if possible. I have numbers from 1-85 listed in column F. These numbers can appear multiple times. I have a v...

1 reply Last reply on 20 Oct 2015 by
rizvisa1

Finding multiple doc cases that do not have a specific document

Thank you for letting me post here. My question: I have several thousand case files, a different one for each of several thousand clients. There...

3 replies Last reply on 20 Oct 2015 by
rizvisa1

Calculating the positions of my students

hi i need help in calculating the positions of my students after having calculated their total marks

1 reply Last reply on 20 Oct 2015 by
TrowaD

Show the duplicate values for each party name

I want to show the duplicate values for each party name. Kindly help

1 reply Last reply on 20 Oct 2015 by
TrowaD

On cell change event vba

Hello Folks, I m trying to get hold of on cell change event vba code, if the cell value is changed to blank or zero. otherwise i have code which tr...

1 reply Last reply on 19 Oct 2015 by
TrowaD

Comparing two columns with other two columns in excel 2003

 Solved/Closed

Dear Sir, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20 b 30 c 30 d 40 ...

5 replies Last reply on 19 Oct 2015 by
TrowaD

Excel - shortcut key for print view

 Solved

Hello, I am srinu what is d short cut key in ex-cel 2003 for print viewConfiguration: Windows XP / Safari 532.5

6 replies Last reply on 19 Oct 2015 by
shree

Please assist with an if formula referencing 2 cells

Good evening, I was hoping if someone could please assist with in creating an if statement to utilise in a training register. I have a dropdown men...

2 replies Last reply on 16 Oct 2015 by
ac3mark

Create worksheets with names from a list

 Solved

Hello, I would be most grateful if you would kindly help me out. I have a long list of projects and need to create an individual worksheet for ea...

4 replies Last reply on 16 Oct 2015 by
ac3mark

Finding terms in one word sheet & display on another word sheet

I have two work sheets: Projects sheet that lists clients and the services we provided: A B C D ...

1 reply Last reply on 16 Oct 2015 by
rizvisa1

Calculate percentage in excel

Hello, My question is how to calculate 495000 kg main item scrap only 8 kg how to calculate in % figure

1 reply Last reply on 16 Oct 2015 by
rizvisa1

R, moving every other value in a column to a second column

Hello, I have been tasked with manipulating the data ina a vector of 900 values in a form of a column. Every two values signifies a lenght and weig...

1 reply Last reply on 16 Oct 2015 by
rizvisa1

Integers in multiple rows to single row

Hello all, My data set is like as follows: (All integers) ROW 1: 1 2 3 4 5 6 7 8 9 10 11 12 13...to 26 (26 cells) ROW 2: 27 28 29 30...52 (26...

1 reply Last reply on 16 Oct 2015 by
rizvisa1

Copy a set of cells and paste it 430 times

Hello, In excel i need to copy set of cells and paste down 430 times. Any suggestions. Regards, Arunmaran

1 reply Last reply on 16 Oct 2015 by
rizvisa1

Keep track of hours

Hello, I have a list of people and how many hours they have missed from work. Is there a way to sync this every day with the new data which might ha...

1 reply Last reply on 16 Oct 2015 by
rizvisa1

Get mirrored column "structure" in 2 sheets

So this turned out to be a complete mind-breaker for me. Thanks to the help I previously received on this forum I can already manage (and enjoy!) q...

1 reply Last reply on 16 Oct 2015 by
rizvisa1

Help please if & vlookup returns

Hi, I'm trying to use the following formula which works however I can have more than one number which is the same e.g( B2 can be in the TOPWE tabl...

1 reply Last reply on 16 Oct 2015 by
rizvisa1

Transfer, populate and calculate data between excel sheets.

Hello, I want to be able to input data daily onto the first sheet of my excel file for six different things. I then want to have a separate sh...

1 reply Last reply on 16 Oct 2015 by
rizvisa1

Microsoft word corruption

Whenever I send and receive emails that have `word' documents attached, the documents often get corrupted in transmission. This shows itself as spaces...

6 replies Last reply on 15 Oct 2015 by
ac3mark

Incrementing the column at regular intervals

Hello, I need to increase the cell range at regular intervals using macros. My code is: Do While Cells(2, m).Value "" Range("cells(2,...

1 reply Last reply on 15 Oct 2015 by
TrowaD

Hide zero rows or zero columns in a worksheet

Hello, I would like to know if there is VB code out there that solves for Hiding rows and Columns that show either zeros across the rows or the ...

4 replies Last reply on 15 Oct 2015 by
TrowaD

Excel - merge several worksheets into a single one(thanks)

Hello, I use Excel to store information about several users and their cars information and have a different worksheet for each month. How to merge...

2 replies Last reply on 14 Oct 2015 by
Linds

How to filter out data to separate sheet?

Hello Guys, Can someone pls help me out with this problem I am having. I have 5 drivers on payroll for a car service company. I have all the a...

1 reply Last reply on 14 Oct 2015 by
Mazzaropi

File attachment

 Solved

Hello, is it possible to attach an excel file in this forum, for a better understanding of a particular posed question? Configuration: Windows ...

1 reply Last reply on 14 Oct 2015 by
Mazzaropi

Check info on two different cells...

 Solved

Hello, Ladies, Gentlemen, I am working with the formula below, and it WORKS GREAT =IF(Z17="PAID","",IF(F17"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD...

3 replies Last reply on 14 Oct 2015 by
Mazzaropi

Disable right click on sheet tabs in excel (mac) using vba code

Hello, I am looking for a VBA code to disable right click on worksheet tabs in MAC excel. Application.commandbars("Ply").enabled=false is not ...

4 replies Last reply on 14 Oct 2015 by
Maya

How to restrict user from deleting a sheet?

Hello, I want to restrict the user from deleting a sheet using vba code. I dont want to protect the sheet. Is there any option to protect the s...

2 replies Last reply on 14 Oct 2015 by
Maya

Allow rules wizard to work without exchange server?

 Solved/Closed

Hello, I no longer work for the company that had the Exchange server and I have my personal pop3 email coming into Outlook. When I try to use th...

2 replies Last reply on 13 Oct 2015 by
StefanFridriksson

Macro auto run on file creation.

Hello, I have an excel file created automatically every day, I want to be able to run a macro against the file when it's opened. I can automat...

1 reply Last reply on 13 Oct 2015 by
markcdl

Adobe reader unable to open pdf file

Hi sir, User unable to open pdf file and also not able to save the file it having only the import checklist file the remaining pdf is working fine in...

1 reply Last reply on 12 Oct 2015 by
ac3mark

Write data if a text is found in that colomn

I want to write some value if A text String in Cell A is present in another colom and if found then I want to write the value of that row in front of ...

1 reply Last reply on 12 Oct 2015 by
rizvisa1

Compare data from one excel sheet to other

Hello, i should compare data from one excel sheet to other, please help me to solve the issue. Configuration: Windows 7 / Chrome 45.0.2454.101

1 reply Last reply on 12 Oct 2015 by
rizvisa1

Random sorting without adds-in

Hello, Is there any way to random sort without using random sorter add-ins? I just want to random or shuffling the row just like the pic. ...

1 reply Last reply on 12 Oct 2015 by
rizvisa1

Conditional formatted cell with specific colours should copy in

Hello, i got live data from web. i had given some condition to each row if the values are higher or lower when comparing with specific cell. i had...

1 reply Last reply on 11 Oct 2015 by
rizvisa1

My enter keys and arrows stop working in excel. what can i do

Hello, My enter keys and arrows keys stop working in Excel, what can I do to fix this problem/ Thanks for any help. Configuration: Windows / Ch...

2 replies Last reply on 11 Oct 2015 by
rizvisa1

Auto transfer data as i marked

 Solved

Hello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...

1 reply Last reply on 11 Oct 2015 by
rizvisa1

Populating sheet based off date criteria in another

Hello, I have a database that I would like to auto populate all of the 2015 events into a 2015 sheet. I need the data in both sheets as the main i...

2 replies Last reply on 11 Oct 2015 by
rizvisa1

Recover delete data

dear friends i have a word file in 200 pages data but now i am open the file is empty in single page if recover the data?

1 reply Last reply on 10 Oct 2015 by
Ambucias

Pulling data from different workbooks and collating on another

Hello, I would like to be able to do the following; have a number of work books which are allocated to team members (x4) which they complete with ...

1 reply Last reply on 9 Oct 2015 by
rizvisa1

Counting action under condition of theyr value, and month when..

 Solved

Hello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...

4 replies Last reply on 9 Oct 2015 by
Mazzaropi

Editing a date+time field converts date to text

Hello, I have formatted a (Excel 2010 spreadsheet) column as "ddd\ dd-mmm-yy\ \ hh-mm\ \h\r\s" which shows the existing data as "Sun 04-Oct-15 ...

1 reply Last reply on 9 Oct 2015 by
koorway

Comparing spreadsheets

I have been given a task in Excel and i am not good at it. I have two different spreadsheets with first and last names in them. I need to compare sp...

1 reply Last reply on 8 Oct 2015 by
Mazzaropi
Results 2651 - 2700 out of a total of 12,258