Make Now () = 06/29/2009 (make To Cells With Dates Equal Each Other)

Jun 29, 2009

I need to figure a way to make to cells with dates equal each other if the
day,month and year are the same but are placed into a cell at different times during the day. "Making Date Now () = (06/29/09) In another cell". Therefore, A1= Now() and E11 = 06/29/09

View 2 Replies


ADVERTISEMENT

How To Make Row Of Cells Equal A Column Of Cells

Feb 14, 2013

Say I have data in one tab that is cells

A9, B9, C9, D9, etc.

On the next tab, I want the cell in D5 to equal A9, D6 to equal B9, D7 to C9, etc.

I can't seem to lock the cell correctly to do this. If I use =A$9 in cell D5 and then copy down in cell D6 I'll get A$9 also, but if I use $A9, in D6 I'll get $A10.

View 10 Replies View Related

VBA / How To Make Array Equal To One Value

Mar 23, 2012

I am not sure if I am using the correct terminology when I see "array". What I want to do in VBA is what I know how to do in non-vba excel functions (cntrl + shift + enter). For example, I have a range of cells that need to meet one condition ( ""):

Code:

If Sheet8.Range("C" & rw) "" Or Sheet8.Range("D" & rw) "" Or Sheet8.Range("E" & rw) ""...etc Then

How do I bundle this in one package. What you see below is obviously incorrect, but I am trying to accomplish this with proper syntax.

Code:
If Or(Sheet8.Range("C" & rw & ":Z" & rw) "")

View 9 Replies View Related

How To Make Profit And Savings Equal

Dec 18, 2012

How do I come up with a price that will make my profit and my customers savings equal.

Example:
Retail price $178.99
My cost $113.46

If I charge $142.23 then my profit is $28.76

Customer pays $142.23 plus $8.00 shipping ($150.23)
$178.99 Retail minus $150.23 = $28.76 savings

View 9 Replies View Related

Automatically Decrease Value To Make Total Equal 100

Mar 30, 2013

I receive a large file every month with 30K+ rows of data that need to be manipulated manually before I can send it off. Within the data are "chunks" of data that are anywhere from 1 to 90 rows each. Each chunk needs to total 100 or less, and while they do for the most part, some end up over 100 due to rounding (usually 100.02 or so). The rows above and below each chunk are blank, and I currently have a calc to add each chunk, and flag it if it's over 100. Then, I have to go through each of the flagged chunks and manually decrease one of the lines to make the total 100.

Is there any way to automate any or all of this procedure?

I have attached a sample file with two chunks of data. The actual files contains 14 more columns to the left that aren't shown.

Sample.xlsx

View 5 Replies View Related

Make Textbox In Userform Equal Cell Value?

Jan 27, 2014

I am trying to make my textbox on the userform equal a cell value in a column. I need the userform to look at the last cell that has a value in a column and display that value into the textbox on the userform.

Ex. I am starting my data from Cell "O8" and the last possible row would be "O51" Starting with O8 I need my textbox in the userform to read this cell value. After each entry the next row in Column O will have a value, so I would need my userform textbox to read cell "O9" value the next time the user form opens. Here is what I got thus far:

[Code].....

It gives me a Compile Error: Invalid or unqualified reference.

View 3 Replies View Related

Make Variable Equal To Active Range In Sheet

Apr 2, 2014

I would like to run a calculation based on selected active range in sheet. I tried several methods and cannot make it work.

View 2 Replies View Related

Make Userform Show Data From Spreadsheet And Add Delete Or Make New Entry

Jan 24, 2014

I have a spreadsheet on sheet 1 with a list of customers and their information. So on column A I have the customer number (i.e. k968, e37, p528,...), on column B i have the customer's name, on column C the street's name, on Column D the house number, on column E the zip code and finally the city on column F.

Right now there are around 600 customers in this list.

I have made a userform with a combobox in which I want to select an existing customer (pulled from the spreadsheet). On the same userform I have textboxes (customer number, name, street, number, zip, city). When I select a customer in the combobox, I want this customer's info to show up in the textboxes. I want to be able to change the info and hit Next to store the changes in the spreadsheet. When I do not select a customer from the combobox, I want to add new info in the textboxes and hit Next to store this info as a new customer. The userform also has a delete button. Then I select a customer in the combobox, this customer (and it's info) should be deleted from the spreadsheet when i hit Delete. So the spreadsheet is variable in length.

View 5 Replies View Related

Difficulties With Dates (convert The Column Of Dates To Say Mar 14 2009 Type Date)

May 3, 2009

look at the attached file - it was a CSV file. i want to convert the column of dates to say Mar 14 2009 type date. but it only converts some of them.
note some are on the left and some on the right.

View 5 Replies View Related

Conditional Formatting To Make Dues Dates

May 9, 2014

I look everywhere to find a formula for a conditional formatting to make dues dates.

I would like to know if it's possible to do conditional formatting to make due dates turn green and yellow 90 and 180 days before their dues dates? The reason I am asking this question, it's because the column that where dates are, they are coming from a VLOOKUP formula and it's coming from another workbook.

View 3 Replies View Related

Macro To Make Bottom Cell In A Column Equal Top Cell

Feb 5, 2014

I am trying to write a macro that will make the bottom cell in a column equal to the top cell. The top cell will not always be in the same row and there won't always be the same number of cells.

View 1 Replies View Related

Possible To Make Sum Formula Based Off Dates Entered In Different Cell?

Jul 28, 2014

How would you write a formula where the sum depends on what dates you enter in A1 and B1?

Date cells C1 to C365

A1 start date
B1 end date

Example:
A1 = 1/1/14
B1 = 1/31/14

So cells C1 to C31 will be added.

"=sum(c1:offset(c1,(b1-a1),0))

This formula works, except if you enter a different starting dates, it just counts from c1.

View 1 Replies View Related

How To Make Arrange Colour Equal Cell Colour

May 23, 2014

A column of cells can be 1o different shades of green according to their value (achieved by using conditional formatting.) I want to arrange that at a certain time all the cells of a part of the row of a formatted cell are the same colour.

View 4 Replies View Related

Make Copies Of A Spreadsheet Within A Book - Dates Change Automatically?

Nov 27, 2012

If you look at the file I attached you will see the tabs at the bottom are months of the year. I know how copy a sheet but every time I make a new month tab I have to retype the month in the top left corner of the table, in the tab, and other places. This gets really repetitive when I have to do this for literally around 20 other spreadsheets like this.

What I'd like is a way to create new month tabs that automatically rename the month and year in chronological order on the sheet and tab if possible. 2 months it's because I'm constantly having to tweak spreadsheets for my boss. It'd be pointless to go ahead and make a template because then I'd have to go back and change the code for every month. So I just create tabs and edit code month by month.

View 4 Replies View Related

How To Make Cell Value Equal Negative Of Cell Value On Different Tab

Sep 30, 2013

I have a monthly forecast document that is updated by an operator monthly. At the end of the month, the operator presses a "Copy Accrual" macro that copies accruals for the month and stores them on a seperate tab. After sending the document back to the Finance team (necessary step due to software complications), Finance will send the operator back an updated file at beginning of next month. The operator than presses a "Paste Reversal" macro that is supposed to input the negative of the accrual stored in the seperate tab. The problem is that it is posting as the same value (not negative of value). I tried recording a Macro to fix this, but it did not work. An example of the code that came up with is:

Worksheets("Weekly Forecast").Select
Range("B9").FormulaR1C1 = "=-Accruals!RC[-4]"
Range("H9").Select
Selection.Copy
Range("H10:H33").Select
ActiveSheet.Paste

Thoughts on what to do? I think the two things that are throwing me off is the negative, and moving between the different sheets.

View 2 Replies View Related

Excel 2013 :: How To Make Automatically Fill In Dates For Weekdays Only And Skip Thursday

Feb 9, 2014

I have class monday, tuesday, wednesday & friday but no class thursday. How can I make automatically fill in dates for weekdays only and skip thursday using excel 2013's "Fill" function then "series" ??

View 6 Replies View Related

Make Cell Equal To Another Cell

Jul 5, 2009

I am looking for a way for a cell to equal another cell but the cell that it looks at is controlled via another cell.

So, for example, cell A1 I type in E5 and this tells cell B1 to display the contents in cell E5.

View 3 Replies View Related

Make Certain Cells

May 1, 2006

I am creating a form and certain fields are required. Can I force the user
to input some value before they can save?

View 12 Replies View Related

How To Make Cells

May 14, 2009

anyone know how to make cells number going down the row in "4's. I wish to have cells, A1,B1, C1, D1 to have a "1"in it, and the next four down (E1,F1,G1,H1)to have a "2", and the next four to have a "3",and so on.....

View 9 Replies View Related

Make Cells Appear Blank When Not In Use?

May 16, 2014

I have column g as a dollar amount, and a running total in column h, where g4+h3=h4. I want the cells in h to appear blank until there is a dollar amount entered into the corresponding g cell.

View 10 Replies View Related

Make Only One Of Two Cells Selectable

Sep 7, 2008

If I put data into one of two cells I want it so that the other cell cannot be selected. I can't say I've struggled with this for days as I really don't know where to start

View 9 Replies View Related

Make Cells Flash

Dec 6, 2007

I would like the VBA code and use instruction, which will make any cell flash in a predetermined range of cells when certain conditions are met i.e. if cell value greater than 10 or less than 100 - usual condition formatting rules.

View 8 Replies View Related

How To Make Macro To Lock Certain Cells Connected To Another Cells Value Then Copy Daily

Mar 29, 2014

am making Excel for private use, i need the following makro to be active, here is the idea because i didnt yet work with makros at all:

If A1 = False
then Range B1:D1 will be locked cells

If A1 = True
then Range B1:D1 will be unlocked cells

Those rules apply to 1 day in the year.

the range A1:D1 will be copied about 400 so the makro should be active to each day separatly.

Check the picture attached for example of one day

View 1 Replies View Related

Make Cells Invisible Until They Are Populated?

Jun 5, 2014

I'm trying to create an accounting document, but stuck in couple fields

1) Make balance appear in column E5 only if column C5 OR D5 is polulated, so goes for the rest of the cell in that colu

2) I like to have 2 digits after the decimal but (same as above) i want it to appear ONLY if there are any decimals to that number, all those 0 become confusing.

3) I need to make it so the last calculated cell on sheet Jan of column E gets transfered auto to sheet Feb D3 of F3 so the calculations could proceed to the next month

View 11 Replies View Related

Make Multiple Cells Display Same Value?

Jul 31, 2014

I've recently discovered that I enjoy making Excel spreadsheets as a tool to solve recreational puzzles. Mostly variations on crosswords and such. Honestly it probably takes much longer to organize everything into a sheet than it would to just solve on paper, but I seem to enjoy it this way more.

The Actual Question (for TL;DR Types):

Anyway, I am trying to find a way so that a group of cells can all copy the value of the other cells in the group, regardless of which cell the value is entered into. So I don't want there to be one "master cell" that all the cells are linked to. I want them all linked to each other.

Specifically, right now I am making a spreadsheet for a non-traditional style crossword puzzle. My intention was to make fields for the answers to each clue, with individual cells for each letter, as well as the crossword grid itself. Then I would link the cell in the clue answer to the cell in the grid, so that when the answer was filled it, it would be inserted in the proper place. But since this is a crossword, there is more than one clue with a letter that links to each cell. I could make it so that the cell in the crossword grid is the "master" and make the other two equal to it, but I would much rather be able to enter the letter into any of the three cells and have all three fill automatically.

I realize I am making this way more difficult than it really needs to be, but that is kind of what I enjoy about it. Finding creative ways to make the puzzles fit into a spreadsheet and making them more streamlined.

View 6 Replies View Related

Make All Blank Cells Blue?

Mar 20, 2009

I want to make all the cells that are outputted as blank by my formula a certain color to distinguish them from non blank cells. my current formula: [B1=IF(A1=0,"",A1)]. my guess would be to use an [AND] function but I do not know how to command a cell to change color without using the toolbar.

View 4 Replies View Related

How To Make A Macro To Format All Cells

Jun 5, 2014

I would like to make a macro to format all my cells.

I need it to format my last digit to superscrift IF there is 4 digit after decimal point.

How to do this?

View 14 Replies View Related

How To Make A Button To Clear Certain Cells

May 8, 2013

How do You Make a Button to Clear Certain Cells?I don't know how to make a button that clears a1-a5 and b1-b5. How do you do this?

View 5 Replies View Related

Make All Cells That Have Note In Them Yellow?

Jun 3, 2013

I need to make all cells that have a 'Note' in them 'yellow'.

this will be for the entire workbook.

View 9 Replies View Related

Formula To Make Sure No Cells Are Duplicates

Feb 14, 2008

A1 = 3
A2 = 3
A3 = 3

formula: =A1A2 gives us FALSE....

Why does =A1A2A3 give us TRUE

What is the best formula to use to make sure no cells are duplicates?

View 9 Replies View Related







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