Automatically Delete The Same Value In A Cell When Filled In Other Cell?

Mar 6, 2014

I'd like a code to automatically delete the value in column AK and its corespondent in AL, if the value in AK is filled in column C

View 7 Replies


VBA Code To Populate A Cell Automatically Whenever Another Cell Is Filled In Manually?

Mar 29, 2014

I have a spreadsheet with 6 hidden columns (B to G). Rows 1 to 14 are frozen and have data that comes from another work book and these rows will be protected. The user will enter data from H14 to U14 and then H15 to U15 for the next row and so on down the sheet. The number of rows of data over a week is variable, a minimum of 21 rows (3 per day) but no maximum.

When the user starts entering new data in the column range H to U I would like to automatically populate the 6 hidden cells on that row with information from particular cells in protected rows 1 to 14. For example B14 would populate with the value from I4, C14 would populate with the value from I5, D14 from I6, E14 from I7 and so on whenever someone enters a value anywhere from H14 through to U14.

I can understand that a worksheet change event would be useful to do this but I guess then it wouldn't want to run every time each cell is populated so I think if it had to activate on a single cell change then the cell in column L would be best. Also, as I understand it, there can be only one block of code per sheet that operates on a worksheet change event, have I got that right? If that is the case then I assume all the code to populate the hidden cells on each row will need to be in this block of code.

View 8 Replies View Related

Delete Cell Automatically If Another Cell Has A Value

Jan 26, 2014

I am trying to put together a spreadsheet that uses vlookup formula in column C to reference column A so that it tells me what the corresponding data is to the column A input. The hard part is that the corresponding info given in my vlookup, I would like to be able to over-ride in the next column (D) and make the column C cell right beside it's data delete only if something is entered into column D. Since column C already has a Vlookup formula in it, I am unsure how to proceed.

View 1 Replies View Related

Copy Cell Data To Other Worksheet Cell - Leave Blank If Not Currently Filled

Jul 8, 2014

I am wanting to have certain cells of data from one worksheet appear on another worksheet once the cells on the first sheet have data entered in them.

I find that I can do a simple formula to copy the cell but I want the cell to remain blank until data is added in the first sheet (it will be a mix of text and numerical entries).

View 4 Replies View Related

How To Automatically Add Row If Last Row Is Filled

Jun 2, 2014

I'm trying to build a invoice template for my business. Trying to make it as simple to use as possible for my staff to input the data. Currently they will manually type in everything but later on I would like to make the spreadsheet have available drop down boxes for the equipment and it will auto fill the hourly rate in.

Right now my main issue is I have the invoice template the way I would like it, but there are only 5 rows in each category. I would like for it to, once the last row in each category is filled, make a new blank row with the exact formatting of the one above it. Then continue to make blank rows if that subsequent row is filled in as well.

Basically, to better describe what I'm looking for, say I have 15 employees on the job and 10 pieces of equipment. I currently only have 5 rows in each category and would like them to expand out automatically without doing a copy rowinsert. It doesn't matter if the page expands to multiple printable pages as long as it doesn't get jarbled in the process.

I am very new to Excel and not even sure if this is possible. I would also need this to carry on with the .xlsm file so that my other employees can use this invoice template on their laptops.

I attached the invoice template I created so what I'm describing can be better understood.

View 3 Replies View Related

Show Number On Sheet1 From Cell On Sheet2 If Cell Next To Cell Containing Number Filled

Aug 13, 2013

SAMPLE FILE "error_finder.xlsx (36.5 KB)" attached...

The VP of our company needs me to create a spreadsheet.

For this s/s I need the following:

Imagine 2 sheets in Excel...


sheet2 has sequential numbers in column1 starting in row2 with the number 1 until wherever..., so cell A2 has number 1, cell A3 has number 2, etc...

Manually, a user has to fill in certain text next to a number.

This for example would look something like this:

_|A| B
1| | Error-description
2|1| Whatever the 1st error would be...|
3|2| Whatever the 2nd error would be...|
4|3| Whatever the 3rd error would be...|
and so on...

All this would be on sheet2

In a cell on sheet1 I now need the number from column A displayed, that has the latest entry in column B.

In the example above this would have to be the number 3 in cell A4, because right next to it (in cell B4) is the last entry "Whatever the third error would be..."

Addition: There are several sheets, each sheet stands for one error listed on sheet1 in column A

sheet1 for example would look like this:

2| error 1 |___|___|___|
3| error 2 |___|___|___|
4| error 3 |___|___| 3 |

In this example, because "whatever error" (cell B2 to B4 on sheet2) was found on press 934 was the 3rd error (cell A4), the number 3 (cell A4) would have to be populated on sheet1 in cell D4.

View 9 Replies View Related

Way To A Column Be Filled Automatically By What Is Written On Others

Jan 15, 2009

Is there any way to a column be filled automatically by what is written on others columns.

Example: If one of the cells A2 or B2 and C2 are Nonblank, fills automatically the cell H2 with "ABC2" And If some of the cells D2 and E2 are Nonblank fills the cell H2 with "DE2"

View 2 Replies View Related

Copy To Next Cell Down When Cell Is Filled

Jul 29, 2006

Ive tried to use many of the post on this topic but I suppose I just dont understand how to stitch this into my actual code. Im extremely noob at VBA and the only way I can make macros is with the record tool.

My exact problem is I have a row of data in one workbook which is generated by a calculator built into it.

I then need the data from the output result table to be copied to another workbook in a table. I would then like the user to be able to run a different calculation on the calculator and have the results copy to the next row down as not to disturb the results of their first calculation. (I would like to assign this to a button next to the original result table)

Heres the code I recorded that just overwrites to the same spot. I was hoping I could just edit the paste location to make it skip down to the next available cell starting below the first (C25:F25).

I dont know how you guys make your code look all nice and indented either, so I apologize if its confusing I copied what the recording outputed....

View 9 Replies View Related

Index And Match - Data To Be Filled Automatically

Apr 4, 2012

I want to fill some data to be filled automatically but i am not getting the formula. here is what i want...

When i write customaer name in sold field (b3) all the entry should automatically be filled (g3 h3 i3 j3)in his credit account from (a3 c3 d3 e3).

Somehow i managed to get it work(for one field only) but there is a problem in my formula

Here is my formula =INDEX(A3,MATCH($L$1,B3,0),0)

Note:- l is where i wrote customer name in leaves blank spaces when other customer name comes

View 9 Replies View Related

Having Cells Filled Automatically When Selecting Options In Lists

Apr 20, 2009

I've been breaking my head over this and i haven't managed to make this work. The attached excel file contains a list of students that participated in exchange programs on the past. What i want this to do is that when i choose the university the student went on exchange with, that the city and country cell fill in automatiocally with their respectuve info. I have a worksheet on excel that has the university name, on the next cell the city, and on the next cell the country.

View 3 Replies View Related

Finding The Last Filled Cell

Oct 18, 2009

I have data entered in rows 2:10. The amount of data is variable for each row. For example, in row 2, columns A:F are filled out, and the rest (G:P) are blank. In row 3, columns A:J are filled out and K:P are blank. The data is always entered from left to right, and to a maximum up to column P. Hope this makes sense.

In column Q, I want to write a formula that will tell me the last filled column of that row (A=1, B=2, C=3, etc.). So in Q2 would display 6. Row 3 would display 10. And so on.

View 3 Replies View Related

How To Shift A SUM Row Down When The Above Cell Is Filled

Aug 16, 2013

I've attached a simple spread which gets across the main problem. i need the totals row (currently row 7) to drop down a cell each time the data base above has an extra row added to it its pretty much a cosmetic issue but it can be useful on hugely long spreads.

View 13 Replies View Related

Getting Cell To Be Blank Until Another Is Filled

Aug 9, 2009

I am counting days until a part is filled, and would like the unused lines to stay blank until a date is entered. below is a pic of my sheet.

I would like the 40034 colum to be blank (colum k) to be blank until there is a date input into colum b (date req)

My formula for colum k is =IF(ISBLANK(A4),TODAY()-B4,A4-B4).

View 10 Replies View Related

Delete Last Filled Row (columns A To H)

Jan 30, 2009

I use a macro to copy some data from a .csv file. The data is copied to columns A to H (starting from row 31), the number of rows filled depends on the particular case and is not fixed. The first column gets filled with the serial numbers. the problem is that in the last row cells of columns B to H contain three dashes (---).

I have written a simple code that finds the last filled cells in column A. After having found this row, I would like to clear the cells or delete them. the below mentioned simple code does finds the last filled row but I am not able to find a command to delete or clear the cells of this row.

View 3 Replies View Related

Color A Cell If In The Filled Interval?

Dec 16, 2013

I want to create a room reservation sheet, based on the following:

Room 1
Room 2

08:00 am

09:00 am

10:00 am

Where the blank cells should be filled with a color (red, blue, anything), based on another sheet that tells me i.e that the room 1 is occupied from 09:00 to 10:00 and room 2 from 08:00 to 09:00 am.

View 7 Replies View Related

If Previous Filled Cell Is Equal To

Mar 2, 2009

How could i change this formula so

If the previous cell "filled with a number" in column D is equal to C17 Then C18 otherwise c17

This is the formula
This formula is in D38

This formula is in D65
I also need to apply the same to this formula

View 12 Replies View Related

Restricting Moving Onto Another Cell Until One Is Filled In

Apr 17, 2009

I'm an intermediate Excel user that can navigate around pretty well, but now my boss wants me manipulate Excel in such a way that I cannot figure out how to do.

He wants the worksheet to be "locked" so that I cannot select another or "the next" cell unless the active cell I'm in has something entered into it. The purpose of this is so that when a manager is buying off (proofing and approving) my work, he can't put his initials in a cell next to the purchased item unless the cell that decribes the purchaed item is filled in. I'm not exactly sure what terminology to use when describing this, so forgive me if I'm being vague.

Can I restrict a user from "moving on" to another cell unless the active cell is filled in? And if so, how do I do this?

View 9 Replies View Related

Detecting The Last Filled In Cell In A Column

May 4, 2009

Is there any formula or macro that can be used to detect the value of the last filled in cell in a column or row? For example, I fill in column B each day with a new numerical variable, so on day one B1 = 100, on day 2 B2 = 200, on day 3 B3 = 150 and so on. I would like the last variable entered in column B to appear in, for example, cell A1. Is there any way to do that?

View 9 Replies View Related

Finding The Last Filled Cell In A Column

Jul 15, 2006

I have written several pieces of VBA code which produce a sequence of tables on a single worksheet (with the rather original title "Tables"). The code often adds tables to the end of the current set of tables, and to do this, I need to know where the next available space is.

I have a solution which I have been using for ages now, which checks each cell in an appropriate column until a sequence of 3 blank cells has been found as I can guarentee that the tables are at most 2 cells apart. It then sets i=i-3 to give me the location of the first empty cell.

Blankcount = 0
i = 3
While Blankcount < 3
If Cells(i, 3) = "" Then
Blankcount = Blankcount + 1
Blankcount = 0
End If
i = i + 1
i = i - 3

View 2 Replies View Related

Display Last Filled Cell Column

Aug 22, 2006

My is updated very frequently and i just wonder if it is possible to display the last filled cell of a certain column in another cell.

Imagine column B (B5:B1253) is filled with average sales values by using formula "B$5:B5" and i want to display the most uptodate average value in cell B1.

View 3 Replies View Related

Get Data From Last Filled Cell In A Column

Mar 15, 2007

I need a formula or macro to fill a cell with the last entry in a given column.

Anyone have any advice?

View 9 Replies View Related

Display Text If Another Cell Filled

Apr 26, 2007

Is it possible to display text based on the contents of another cell?

I am creating a report that includes all our data for the year per month - this builds dynamically every time i create the next months report.

So far i have data for,

Column A-- Column B
Jan - have data
Feb - have data
March - have data
April - no data yet...

In this example i would want the following text to appear in another cell,

Statistics: January - March 2007

It would dynamically update to January - April 2007... once April cell had data.

It's probably very easy but after several attempts i can't get it working as such.

View 3 Replies View Related

Select Last Filled Cell In Column

Jun 20, 2008

I want a macro to be able to select & highlight (ready for copy/paste) all cells in the column range "A2" to the last populated cell in column A.

View 3 Replies View Related

Graph / Chart Represent Whether Or Not Cell Has Been Filled

May 14, 2014

I am making a spreadsheet that will be used to track employee time usage. I would like to be able to create a graph of the time throughout the day that shows only whether or not the employee has entered an activity during each particular time slot.

EX: The graph shows the time from 8-10am in 30 minute increments. The employee has entered activities for the time slots from 8-9 and 9:30-10. When the graph is created, I would like to see times 8-9 and 9:30-10 filled (or, charted, or, however I should phrase it) and time 9-9:30 left blank (to represent that no work was done).

View 3 Replies View Related

Copy And Paste A Row When A Cell Is Filled With The Color Red ..

Mar 31, 2009

I am trying to create an conditional statement using this code

View 14 Replies View Related

Copy And Paste A Row When A Cell Is Filled With The Color Red

Apr 7, 2009

I would like the users to have the option of filling in the cells with "RED" by any means.

Here are the conditions or pseudo
If (any cell in Column X is RED)
Then (copy the row to Copy Rows Filled With Red)

If ( the cell in Column X is not longer RED)
Then (remove the row from Copy Rows Filled With Red)

In plain English, if the cell is filled with RED, it is copied over to sheet Copy Rows Filled With Red. Or if the cell is no longer filled with RED, it is removed from Copy Rows Filled With Red.

Please see attachment for explanation.

View 14 Replies View Related

Date And Time That Entry Cell Is Filled

Jul 26, 2008

Is it possible to have a cell, say B1 - which will return the Time and Date Value of when something is entered into Cell A1?

Example, I type "Hello" in Cell A1.
Now B1 will show me the Time and Date which i typed in Hello into A1.

View 9 Replies View Related

Fill Color When Empty Cell Filled In

May 6, 2009

I have a spreadsheet that has a bunch of empty cells that I need to fill in. Someone else needs to know which ones I have filled in after I am done. Is there a way that I can have Excel automatically highlight the cell after I put something in?

I know I could highlight the cell manually after I put something in it but if Excel can do this automatically for me, that would be the best as this is a very large spreadsheet and there will be many blanks to fill in. I am using Excel 2003.

View 9 Replies View Related

Autogenerate A Date/time When Another Cell Is Filled

Jun 23, 2006

how to autogenerate a date/time when another cell is filled in Excel?

View 2 Replies View Related

Display Alert On Closing If Cell Not Filled In

Sep 20, 2007

I have a spreadsheet which has a sales report for 100 stores. When a store opens the spreadsheet they login using a username and password on a userform. This then filters the report and brings up there respective line. The stores have to fill in certain cells on there line. I want to display an alert if they forget to fill in a cell when they login.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved