The discussions

Hey may i ask you something please?

i have two columns "County" and "County Code" i want to check country code not blank , and country code blank then return a value from a County to a n...

1 reply Last reply on 13 Oct 2014 by
TrowaD

Macro for shifting contents of a particular cell

I am trying to create a small macro which helps me copy the contents of a particular sheet (In my case the total of a long list of calculations) as an...

3 replies Last reply on 13 Oct 2014 by
TrowaD

Format a cell with a comment based on a comment in another cell

 Solved

Hi, I need to format a cell with a comment based on a comment in another cell. So cell A1 might ask a question like is the window clean? B2 will...

2 replies Last reply on 12 Oct 2014 by
stevo

Macro to copy paste without having all the source books opened

 Solved

Hello Kioskea users. I hope you're all doing great. Today I have a concern that I'm not able to figure out. Any help will be really appreciated. I...

2 replies Last reply on 12 Oct 2014 by
fabianchpe

Pdf overwriting previous pdf

Hello fellow Kioskeans, When I generate an invoice from my invoice template, it is automatically saved to an "Invoice" folder as a pdf. However, I...

2 replies Last reply on 11 Oct 2014 by
vcoolio

Automatically moving cells with data

I have a column of times ie A1 = 00:25 A2 = 00:32 A3 = Nothing or it could be 0 or #N/A A4 = Nothing or it could be 0 or #N/A A5 = 00:27 an...

2 replies Last reply on 10 Oct 2014 by
SuttonRider

Excel

Hello, I have report which consist date 1-30 in that first 15 days different format. last 15 days different format. first 15 days i can change dat...

3 replies Last reply on 10 Oct 2014 by
venkat1926

Delete rows with no conditional formatting highlights

Hi everyone! I have a quick query regarding tidying-up some worksheets I generate regularly that I've been unable to find a solution for despite se...

3 replies Last reply on 9 Oct 2014 by
TrowaD

Adding cells in excel from diff. sheets

Hello, Is it possible to add cells from different sheets in a single workbook. If so what is the formula? Thanks

4 replies Last reply on 8 Oct 2014 by
An1

Vba code not working when modified

Hello! I have the following VBA Code on an Excel worksheet, which has been working fine up until today, when I modified it slightly (just changing ...

1 reply Last reply on 7 Oct 2014 by
TrowaD

How to convert date to word in excel

 Solved

how to convert Date to word in excel e.g. 05/01/1992 to change Five January, Ninteen Ninty two

1 reply Last reply on 6 Oct 2014 by
carminabigue

Macro:- deleting rows on condition for selected no of col.

Hi. I have an excel for which i require to delete rows if there is "n" found in the row. But i want this row to get deleted for only a particular n...

1 reply Last reply on 6 Oct 2014 by
TrowaD

Chg background color of any cell in range based on another cell

Hello, I am trying to maintain a spreadsheet of races and personal bests for runners. My runners are in rows. The races and Mile Split times are...

1 reply Last reply on 6 Oct 2014 by
TrowaD

Automatically transfer data from one sheet to another

 Solved/Closed

Hello, I have a workbook with 2 worksheets. Sheet 1 has about 400 line items. I would like to be able to select certain line items on Sheet 1 and ...

Last reply on 6 Oct 2014 by
TrowaD

Calculate total total hours per client

 Solved

Hi, I have a spreadsheet in which employyees time are entered on a daily basis along with the client they worked for. The spreadsheet calculates ...

5 replies Last reply on 3 Oct 2014 by
ad1959

How to change row color based on percentage??

Hello, Starting in cell "AB10" I have a value in percentage, if the percentage is below 20% I want the entire row to be yellow fill, if below 10% ...

1 reply Last reply on 3 Oct 2014 by
venkat1926

Building a reporting tool

Hi Guys, This is my first time on this forum but it won't be my last. I am pretty functional with excel but lack VBA/macro skills but I am in the p...

1 reply Last reply on 1 Oct 2014 by
ac3mark

Enter current date and time with shortest cut

Hi, I'm using a tracking sheet for incoming couriers everyday, and would like to log each item as they come with current date and time. I've been u...

1 reply Last reply on 30 Sep 2014 by
TrowaD

Convert values in 1 cell to rows

Hello, I have an excel in which there are multiple values in 1 cell separated with comma. i want all the values in cell to be converted in to d...

4 replies Last reply on 29 Sep 2014 by
TrowaD

How to count date cells for monday of this week

 Solved

Hello, I would like to count the number of cells with date = to MONDAY of this current week and also MONDAY of the following week within a defined...

4 replies Last reply on 29 Sep 2014 by
doublewitt

Xlsm vs xlsb

Hello everyone, I've been reading up on the two different file formats and discovered a large variance in opinions. XLSB, being binary, apparently ...

1 reply Last reply on 29 Sep 2014 by
venkat1926

Excel help: if function using or, how to make false disappear!

So I'm writing an excel formula based on Award placings in a race using the IF and OR function. I have the formula correct but I don't want anything t...

1 reply Last reply on 29 Sep 2014 by
venkat1926

Copy a row and paste it down 119 times

Hello, I am using Mac Excel 2011 and I am quite new to Excel Marco. For the purposes of organizing research data, I need help with creating VBA c...

3 replies Last reply on 29 Sep 2014 by
venkat1926

Auto generate the seller sales report

 Solved

Hi! I create a sales report and I set up total 6 worksheet Worksheet 1 I named it Price list ... is a Data for my sales report. and I set a co...

8 replies Last reply on 26 Sep 2014 by
Winndixie

Formula to increment date by seven days.

 Solved

Hello Everyone, In a work sheet, I have an invoice date (say column A) and a due date (say column H) with the due date being seven days after the ...

2 replies Last reply on 26 Sep 2014 by
vcoolio

Automatically transfering rows from one sheet to another

 Solved

Hi, I was wondering if anyone could help. I've created a spreadsheet to track all contracts complied within our department. I have a "Contract Sta...

4 replies Last reply on 26 Sep 2014 by
madi9749

If function with date addition

 Solved

Hello, I'm having trouble finding an answer as to how I can add 5 more days in my condition. I have 4 columns: one for an Order date (A2)...

4 replies Last reply on 25 Sep 2014 by
garycrant

Dealing with 'today()' formula in excel vba code

 Solved

Hi Everyone, I have this VBA code in a Excel sheet (specifically in the Module) which does the following: - finds the empty cell in range "B:B" -...

4 replies Last reply on 25 Sep 2014 by
masinyaka

Macro needed to delete rows with certain condition.

Hi, I have about 169,000 lines of items to go through and I'm trying to figure out a macro to delete every row that contains the word "Discontinue...

1 reply Last reply on 25 Sep 2014 by
venkat1926

Excel > macro for defined range dates

 Solved

Hello, I've a question that I have starting date in Column "E3" Sheet 1 and ending date in Column "F3" Sheet 1. I want a macro that insert dates i...

13 replies Last reply on 23 Sep 2014 by
Game Start Now

Macro or vb code help on moving data from one sheet to another

Hello, Would request you to please help on the following query I have. I have an Input sheet which has data entered in Column A to F like name, emp ...

1 reply Last reply on 23 Sep 2014 by
TrowaD

Find second empty cell/row and start pasting from it

I've already did a lot of research and couldn't find a solution. I'm trying to find the second empty cell/row (or other especified cell) in a column a...

1 reply Last reply on 23 Sep 2014 by
TrowaD

Excel place a vaue in a cell if a number is in a certain range

I need to setup ranges and place a number associated with-in that range. 150 300 450 600 750 900 This data is from column M. I need to b...

1 reply Last reply on 23 Sep 2014 by
TrowaD

Formula compare two different cells containing the scores of tes

Hello, I am trying to create a formula that will compare two different cells containing the scores of two tests. A student can only get PASS remark ...

1 reply Last reply on 23 Sep 2014 by
TrowaD

Static dates

Hello, I'm new to the abilities of excel and would appreciate any help. I'm trying to create a worksheet where when any data is entered in column A ...

1 reply Last reply on 23 Sep 2014 by
venkat1926

How to copy data based on criteria met

 Solved

Help! I am totally stuck and this is probably a very simple fix. I have two sheets "Priority Accounts" and "ACN Dashboard". I need to move data i...

12 replies Last reply on 22 Sep 2014 by
TrowaD

Excel 2010 vba date formula

 Solved/Closed

Hi, I am trying to get a formula setup so when you click on a cell in excel it automatically enters the date. I am using the formula below which wo...

Last reply on 17 Sep 2014 by
dave

Copy values in row to columns in spaces

 Solved

Hello, I am a beginner in VBA, and would mcuh appreciate some guidance on transposing data in a row to a column via VBA. My row data is as foll...

4 replies Last reply on 16 Sep 2014 by
LearnVBA

Copying data from one data sheet to another automatically excel

Dear Excel Gurus, What I want excel to do is, if a name put in a certain category on sheet one, then it automatically get copied into another sheet w...

3 replies Last reply on 13 Sep 2014 by
venkat1926

Conditional formatting

 Solved

Suppose I have date in Column A (from A1 to A100) and in Column B (from B1 to B100), Both data are numerical. If the data in Column A is greater than...

2 replies Last reply on 10 Sep 2014 by
Osama_bb11

Movind data from one cell to another via a macro

Hello all-- I am in need of someone's valued assistance. Here's the story: I have an excel spreadsheet that contains address data in Cell B6 & B...

3 replies Last reply on 10 Sep 2014 by
venkat1926

Removing " false " value in "if&quo

Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C13="",IF((K13>="06:00"+0)*(K13="...

1 reply Last reply on 9 Sep 2014 by
RayH

Excel 2010 code that clears content of a cell on open

Hi I am looking for code that clears content of a cell based on a value when the workbook opens. I have several sheets in the workbook with varied...

1 reply Last reply on 9 Sep 2014 by
TrowaD

Conditional formating of row based on other cells

Hello, I am trying to format cells A7-E7 based on the relationship between C6 and C5. Ideally they would be coloured on a scale between green and y...

1 reply Last reply on 9 Sep 2014 by
TrowaD

Specific data from one worbook to another (excel 2010).

 Solved

Hello there, I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice...

29 replies Last reply on 9 Sep 2014 by
vcoolio

If then formula using a date

Hi, I'm trying to create a formula where if the date falls on or after 08/01/2012 the value returned is .0464 and if its before 08/01/2012 the value r...

1 reply Last reply on 8 Sep 2014 by
Mazzaropi

Excel 2007 custom filter problem

 Solved/Closed

Hello, I have been using Excel 2003 to sort phone numbers easily, using the custom filter and 'begins with' for example on numbers starting with 123. ...

Last reply on 8 Sep 2014 by
mark

Multiple columns using countifs

I have a column such as a1 --- 'Vendor' ----> (Win/Loss) column N ...

1 reply Last reply on 7 Sep 2014 by
venkat1926

Comparing excel columns - help asap please!

Hello, I need help, please! I have two worksheets (C & Q). Each worksheet contains four columns, each column has different information(A=Date, B=Mis...

2 replies Last reply on 4 Sep 2014 by
Gary Myers

Run vba automatically when criteria is met

I want to be able to run a macro automatically when criteria is met.. If any cell in column A is change to "re-let" run "rowformat" macro can an...

1 reply Last reply on 4 Sep 2014 by
venkat1926
Results 2951 - 3000 out of a total of 7,066