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
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 ( ""):
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) "")
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.
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:
It gives me a Compile Error: Invalid or unqualified reference.
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.
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.
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.
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.
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:
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" ??
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.....
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.
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.
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.