Placing The Date (1-JAN-2008) In The Right Column For DAY

Nov 8, 2008

Placing the date (1-JAN-2008) in the right column for DAY

Now I have a Matrix in which I have the Days as Colum Headings and the Week Numbers as the Rows.

I will be mentioning the Date let's say 1-JAN-2008 in the Cell A1 and I want this date to appear in the approriate Column for the DAY
For Ex:-

The day for the date 1-Jan-08 was a Tuesday, therefore the date should appear in the Column having a Heading Tuesday and in the Column Monday it should show as 31-Dec-07 and the Columns for Wednesday,Thursday,Friday,Saturday and Sunday the Following dates after 1-Jan-08 (i.e. 2-Jan-08, 3-Jan-08, 4-Jan-08, 5-Jan-08, 6-Jan-08).

The appearance of the Date should change as per the day-date combination and as such for the preceding as well as following dates..

Ex:- Lets say for 1-Jan-09 which comes on a Thursday it should display (1-Jan-09) under column Thu and Mon,Tue,Wed should display ( 29-Dec-08,30-Dec-08,31-Dec-08) and Friday,Saturday and Sunday the Following dates after 1-Jan-08 (i.e. 2-Jan-09, 3-Jan-09, 4-Jan-09).

View 3 Replies


ADVERTISEMENT

Excel 2008 :: How To Add Data Labels For Scatter Plot Coming From 3rd Column

Jul 29, 2014

I'm using Excel 2008 for Mac & cannot figure out how to add a data label to an XY scatter plot that comes from a 3rd, separate column.

I have 3 columns of data: (A,B,C)
Labels, X values, Y values

When I select the Data Source for the Chart, there is a greyed out box for Category X axis labels, which is where I remember such information going in PC versions of Excel I used to use.

From the formatting palette, the only options to select for labels add the values of column B, but I need the reference from column A.

I'm not familiar with macros or visual basic. How to add these labels? This is Mac, Excel 2008.

View 3 Replies View Related

Excel 2013 :: Placing Date Value To 3 Different Groups

Jul 11, 2014

I am rather new to excel and currently using excel 2013.

I have a worksheet with column A ( data group) Column B ( Sent date with MM/DD/YY) , Column C Aged Group {using this formula =IF(B2="","",(TODAY()-B2))} , Column D status ( if the record is open or close).

I would like to create a table that can segregate the data group and how many days it has already aged. And then group them with different aged group. Refer to the attached screenshot.

From:-

Data GroupSent Date AgedStatus
Quotation 06/06/1435Open
Invoice 07/11/140Open
invoice 05/01/1471Open
PO 07/01/1410Open
PO 07/05/146Open
SO 06/30/1411Open
Quotation 05/18/1454Open
SO 05/05/1467Open
Cash Note 07/03/148Close

To:-

Data Group0-15 15-3030 above
Quotation
Invoice
PO
SO
Cash Note

testtest.xlsx‎

View 6 Replies View Related

Sorting A Column, But Placing Results In A Different Worksheet

Jan 2, 2008

I have a simple one-column section (column A) of values in Sheet1:

Column-A
Hal
Sonny
Betty
Adam
James

I would like to sort this, but have the sorted results displayed in Column-A of Sheet2.

How can I do this?

Note: I need to be able build flexibility into this such that I can add names to the bottom of the list in Sheet1, knowing that the results in Sheet2 will be able to accomodate the additions.

View 9 Replies View Related

Extracting A Column From Form 1 And Placing It In Form 2

Jul 23, 2009

I have 2 different forms that I need info from one, added to the other.

The reason for this is to update pricing from a new file, into an older file with the same product code for each product.

on form 1(the one I want to keep), column x is price(that I want to update from form 2 column L), and column B is the product code(sku)

Now on form 2 Column L is the The customer price(this is the data I need moved over to column X on form 1. and column I is the UPC 10(sku) that needs to match the same sku(product code) on form 1.

Gee this sounds confusing aFTER i TYPED IT.. i HOPE THIS MAKES SENSE. i WILL ALSO ADD THE 2 FILES, SO YOU CAN SEE WEHAT I am talking about.

Please help as I have about 30,000 items total, and would take way too long to update prices manually every 2 - 3 months.

View 9 Replies View Related

Excel 2008 :: Opening Asp Files?

Nov 7, 2013

I have Mac 2008 Excel. For my work, I download .asp files and open them in Excel. No problem. The problem is... I'm wanting to use another computer at work that has Mac 2011. When I open the exact same .asp files, they show coding (html?). I can fix this by changing the name of the file extension from ".asp" to ".xls." But I convert these files a lot during the day and this is an extra step I don't want to take. And it works fine in version 2008. So what can I do in version 2011 to make it open the files without all the coding?

View 2 Replies View Related

2004 VBA To 2008 Apple Script

Oct 17, 2008

I would like to convert them to AppleScript so I can use them in Excel 2008.

From what I understand I should be able to do this with AppleScript, but I have never used it before and have absolutely no idea what I am doing.

Not only do I need to know how to convert the VBA to AppleScript, I need to know what to do to make it run in Script Editor, etc.

There are two VBA Macros, each is to highlight a specified cell range, then turn on cell protection.

It is my understanding that although I couldn't record this into my VBA Macro, AppleScript will also let me unprotect the worksheet at the beginning of the script, and then re-protect it at the end of the script.

View 8 Replies View Related

XL 2008 Pivot Table Refresh

Jan 17, 2010

I am running XL 2008 on a Mac and have created a pivot table that works well. However, without VBA (and I don't know how to write in Applescript), is there a way to put a REFRESH button on my spreadsheet?

View 9 Replies View Related

Excel 2008 :: Pulling Data From On Sheet To Another

Apr 3, 2013

Expand the explanation for the previous thread? [URL]....

I am trying to do basically the same thing, I have a long list of clients and need to separate them by date they contacted us. I am using Excel 2008 on a mac, which does not allow micros. the previous thread does exactly what i need to do, but i cant get it to work.

View 2 Replies View Related

Display A Table Created In 2008, In A VBA Form

Jan 19, 2009

I created a table in excel, using it's Table feature, the first column has A - J, the second column has 1 - 10,

I then created a VBA form in VBA6,

How do i display that table and its 2 columns in a VBA form?

View 13 Replies View Related

Excel 2008 :: Creating Formula To Convert Information?

May 7, 2014

I am trying to get a grip on my gas n electric bills. My problem is in creating a formula to convert the info I have into the final bill.

The info I have is -: days of use, amount of G n E used, standing charge, price/unit and discounts applicable. For simplicity I have converted them all into a rate per day and £GB. I tried the following formula

:-(standing charge per day * days used)+(cost per KWH * No.of KWH used) - (discounts * days used) / (100) * (94)

This last one is to account for a direct debit 6% discount. I used cell address for things like No of days usage and KWHs used in the period. The values in these cells have themselves been calculated via a formula from other info. The results I get seem to be a constant variable which indicates that I am doing it wrong.

View 3 Replies View Related

IF Function Inform If Person Worked Over 6 Months In 2008

Feb 1, 2009

I have attached a worksheet that shows the last and first name of an employee along with their hire date and term date, if termed. What I am looking for is a function that will tell me if a person was active as of 12/31/08 which will read true on the side of their name under active; I also need a function that will tell me if a person worked over 6 months in 2008.

The first person John Doe was hired in 2005 and has a true on the side of his name which meant that he was active as of 12/31/08 but as you can see Jane Doe has true on the side of her hire date and false on the side of her term date and I don't want it to read the first true but the last true of someones name, but Jane Doe qualifies for working over 6 months even though she started in 2007.

View 7 Replies View Related

Turn On View Vba Code In Apple MAC Office 2008

Aug 19, 2009

how i can turn on view vba code in Apple MAC office 2008.

View 3 Replies View Related

Make One Cell Count Twice In AVG If Certain Text Conditions Apply- 2008

Mar 9, 2009

I am using Excel to tabulate votes for a contest. Judges have given a number to each entry, and but certain judges' opinions need to count twice as much as other judges' opinions based on their qualifications.

I've attached the file to help illustrate what I'm trying to do. Morris's votes need to count twice for all Photography or Web Design entries, and Clark's votes need to count twice for all Graphic Design or Web Design entries.

I know I can do this manually by simply copying the number into a blank cell in another column (like the blank column between Morris and Clark's names), but is there any way to make Excel do this for me?

View 7 Replies View Related

Multiple Criteria And SUMPRODUCT (count The Number Of Rows That Have Values Greater Than 10/01/2008 In Either Of Two Fields)

Jan 23, 2009

I am trying to count the number of rows that have values greater than 10/01/2008 in either of two fields. I tried following formula but instead of giving total number of rows, it returns a random date.

View 2 Replies View Related

Placing Button In Certain Row (VBA)

Oct 22, 2013

What is the easiest way to have a button added into a certain cell? Basically I have my workbook enter columns into a certain sheet. When a column is added into that sheet, I want to also add a button, that gives the option to delete the column that it is sitting in. I tried to record macros to figure it out, but I didnt have any luck figuring out logic behind the button placement.

View 7 Replies View Related

Placing Value On Bottom 3 Scores

Mar 3, 2014

I am trying to do the following:

901 > 0 pts
851 - 900 gets 1 pts
LOWEST 3 scores gets 2 pts

Example of what i have for the top three
=IF(D8="-",0,IF(RANK(D8,D$8:D$34)<=3,2,IF(D8<79%,0,1)))

I have tried to change it but cant get it to work for the bottom 3 scores.

View 1 Replies View Related

Placing A Calculated Value Into A Cell

Jan 7, 2010

if its possible to place a value (the product of a formula) into a cell ie:

Cell A1 = "a"
Cell A2 = "b"

I would like to be able to say: If A1="a" and A2="b", then place "Yes" into D1.

I realize that =if(and(a1="a",a2="b"),"Yes",0)

placed in D1 would give the same result, but I do not want to have a formula in D1, I simply want the characters "Yes" placed in there.

View 3 Replies View Related

Identify Every Weekend By Placing 'X'

Jan 8, 2010

If I have 1 Jan thru 31 Dec in A1 - A365, is there a way I can identify every weekend by placing 'X' in Col B alongside every occurrence of Saturday and Sunday?

View 2 Replies View Related

Placing Textbox Above Y Axis

Jul 23, 2014

Is there any way that I can place a text as fixed position over the highest value on the Y axes in a chart with VBA?

View 6 Replies View Related

Button Placing In Cell

Feb 1, 2014

Is it possible to place a control button on a cell?

View 1 Replies View Related

Placing A Chart On A Userform

Oct 18, 2007

I was wondering if someone could give me some sample code on how I can get a chart to appear on a userform. What I have is a userform that allows the users to change the inputs that are used in preparing the chart. Then I want a second userform to display the new chart.

I searched the posts and saw reference to saving it as a picture but I am not sure how to go about this. Can I save it as a picture within the excel file? Or does it have to be external. If so, how is this done. And can I do it without interupting what the user is doing on the forms.

View 7 Replies View Related

Macro - Placing Data In Next Row

Mar 14, 2012

I have an excel file which I run every week. I am capturing the data from my last run onto a separate worksheet. I have a total of 5 columns.

Here's an example:

Date RunNumberValidNot ValidPending 3/2/20122723133/9/201224 0024

I want to leave the data already there static and move my formula to the next row when I run my macro. How can I do this?

View 1 Replies View Related

Placing User Form

Apr 6, 2007

I have created a user form (thanks Datsmart), and now need to place the data that will be inserted in that userfom onto my spreadsheet.

The spreadsheet will have 50 rows, each containing a different project. There will be a button on each row to activate the user form for that specific row. They click the button on the spreadsheet, and the user form opens. They enter the data on the user form, and once they click the "add comment" button on the user form, the data should be entered in the last cell of the row on which the button is located.

Now the complicated part:

The users will use that for to update the project from week to week, but each week's comment needs to go in the same cell, but above the previous comment.

IE:

Week 1

Jan 1: Project lauched

Week 2

Jan 6: Project budget submitted
Jan 1: Project lauched

Week 3

Jan 22: Budget approved
Jan 6: Project budget submitted
Jan 1: Project lauched

The date being the date from the user form, and the comment being the comment from the user form. If the latest date can be bolded that would be a bonus.

They each have to go in the same cell cause all relate to the same project. This same thing will be repeated 50 times for each different project.

View 9 Replies View Related

Assigning Points For Placing

Sep 1, 2007

i have a spred sheet that i am trying to give them scores from highest 10 down to 6 then anyone under will get 5

However if there is a tie for first they will each get 10 then the next will only get 8

ex)

a1 b2( this would be there score

3.45 10
3.45 10
3.40 8
3.20 7
2 6
1.99 5
1.89 5
1.5 5
1 5

View 9 Replies View Related

Automatic Shape Placing

Jun 13, 2008

I am trying to have 8 various shapes placed on running pages alphabetically, ie 8 modules to a page being 2wide by 4 high. There would be say 200 entries of various combinations and names equating to 80 pages If these can be sorted alphabeitically by name then placed on subsequent pages. Is this possible in excel or in "VB"

View 9 Replies View Related

Placing Into The Correct Name And Category

Jul 16, 2009

i've been having for quite some time now. I need to input quantity of items into the existing database that holds all the items names which is sorted by category. Below is a sample of the problem:

Table 1 - Items with quantity that is waiting for input:

Quantity
Product
5
Button A White
7
Ribbon B Blue
8
Thread A Black
10
Cloth A White
3
Button B Blue
4Button C White
9Ribbon A Pink15Button A White
Above is just a part of it, the list goes on to over 200 rows long.

Table 2 - Existing database of all products:

Products
Quantity

View 9 Replies View Related

Placing A User Form

Apr 11, 2007

I have created a user form to enter data into a spreadsheet. The spreadsheet has 6 columns:

Project number - Team Lead - Client, Budget - Comletion date - latest activity. Example:

#2343 - John - Xerox - $230,000 - Aug. 26, 2008 - Jan 1, 2007: Budget has been approved

#2445 - Michel -ABC Inc - $26,000 - July 7, 2007 - Jan 22, 2006: Budget has yet to be completed, awating input from Engineering

etc

The first 5 collumns are stagnant, and will never change throughout the project. The only one that will be updated on a weekly basis will be the "latest activity" collumn.

So in week 2 the above 2 projects would look like this:

#2343 - John - Xerox - $230,000 - Aug. 26, 2008 -
Jan 23, 2007: Materials under study
Jan 1, 2007: Budget has been approved

#2445 - Michel -ABC Inc - $26,000 - July 7, 2007 -
Jan 23, 2007: Budget approved
Jan 22, 2006: Budget has yet to be completed, awating input from Engineering

(however the activity would be on the same row as the rest of the info)

The latest activity (in the example they are dated Jan 23) are what I am looking to control by using the userform. On the user form there are 2 textboxes, 1 for date and the other for the "latest activity:" text. Once the user completes the 2 textboxes on the userform, they click a button, and the new information should be entered in the same cell as the previous activity, but on a different line and above the last activity.

It simply to maintain some sense of order in the activity area of the report. As various users fill in this section, they all do it differently....(each use a different date format, some hit alt-enter to get to the next line within the same cell, some just att to the end, some put in the mnext cell etc) and by the time it gets back to me it is a mess, and I have to spend a day tidiying it up.

View 3 Replies View Related

Finding A Cell And Placing It On Another Sheet

Jan 15, 2010

I have on sheet 2 in column D names of cities the vary like Sydney Brisbane could be twice but each week the cells could have difference city in them. In column F it will have a number in them a difference number each week . I need the total of the number that matches the city added up on sheet 1 that matches the city in sheet 1 which on sheet one the city never moves.

View 4 Replies View Related

Placing Button Programmatically On Worksheet

Feb 14, 2014

I have an expanding worksheet and would like to move a button so that it is always near the bottom of the worksheet data. When the button is pressed it reworks the worksheet and adds in some additional rows (up to 10 max). I'd like it so that the procedure also moves the button down keeping it in line with approximately the last row of data but not sure how to do this with vba...

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved