Populate Row Of Cells On One Sheet Depending On Value In One Cell On Other Sheet

Apr 27, 2014

with the attached spreadsheet?

I want to populate "selections" sheet with data from the previous sheet (it will be the date) depending on the value of a cell in column G. You will see I have already got the data from 27th April into my selections sheet but wondered if it can be done by a formula to save me copy and paste time?

View 2 Replies


ADVERTISEMENT

Populate Cells On Different Sheet With Cell Contents Of A Preselected Row

Mar 25, 2014

I have contacts list that I made and want to take it to the next level, but don't know how. See attached.

The goal:
1. Highlight an entire row of someone's contact info (i.e. row 9)
2. Click the "ORDER FORM" text box to activate a macro that populates specific cells on the 'order form' sheet with the customer's contact information from the highlighted row. The information I want copied over is in red on the order form sheet. THAT'S IT!! (Oh, and 'paste value' the current date from H5 so that the date is static on the order sheet

If possible, I would like to have an error check in case no row is selected prior to clicking on the text box that pops up the note "Please highlight a contact row before clicking the 'Order Form' button."

View 5 Replies View Related

Highlight Name On One Sheet Depending On Cell Value And Name On Another Sheet

Apr 18, 2014

I administer an excel spread sheet which over the years I have added bits of code to which now generates our weekly roster sheets and our daily duty sheets. Sheet 1 is the weekly roster and sheets 2 to 8 are the daily sheets. If an employee is on leave or sick for the coming week the value S or L is entered in to Column B on each daily sheet and when the roster is processed for printing it strikes through the names of the employees for each day that they are off. What I would like to do is then Highlight the name on sheet 1 the weekly roster sheet so at a glance we can see on the main week sheet any issues we may have for the next week. What it needs to do is if the cell in column B contains S or L on sheets 2 to 8 the name which is in column C on these sheets needs to be matched to the name in column D on sheet 1 and this cell highlighted.

View 2 Replies View Related

Redirecting Multiple Columns From One Sheet To Another Sheet Depending On A Condition?

Jan 23, 2014

In sheet 1 i have the data like this

Date Amount
---------------------------
13-Mar-13
---------------------------
20-Mar-13 2000
---------------------------
27-Mar-13
---------------------------

[code]...

now in sheet 2 i need the date and amount fields in which amount is present.

i need sheet 2 like this

Date Amount
-----------------------------
20-Mar-13 2000
-----------------------------
3-Apr-13 3000

2.jpg

View 2 Replies View Related

Displaying Some Cells Data Depending On Selected Text From Other Sheet

Dec 31, 2013

I have an excel sheet which looks similar to below and with some more columns.

HTML Code: 

AreaBranchEmpolyeesProductsShelfs
Area1Area1 Branch110Product 110
Area1Area1 Branch25Product 16
Area1Area1 Branch38Product 28

[Code] ......

I want to have data in other sheet With respect to Product details. Where It gives me the count of Product 1 and so on.

I am able to get the count using countif function and it displays like below.

HTML Code: 

Product Count
Product 16
Product 28
Product 34
Product 49
Product 510
Product 68
Product 78
Product 89
Product 97
Product 108

What I want is when I select "Product 1" It should display some selected columns data from sheet where complete data is available.

HTML Code: 

Branch Empolyees Other
Area1 Branch1 10 abc
Area1 Branch2 5 xyz
Area1 Branch5 7 pqr
Area2 Branch5 5 wxy

Which function we can use. I tried Vlookup but was not successfull.

View 14 Replies View Related

Macro To Lock Cells In Protected Sheet Depending On Criteria

Dec 13, 2007

I have a Workbook that I use to log invoices and credit notes and it is password protected so that the cells that contain formulas are locked and therefore not selectable.

What I wanted to know is. Is it possible to lock other cells depending on what values are in certain cells?

Let me explain. I have Columns G & H which contain the heading 'Credit Note Number' & 'Credit Note Amount'. Now in columns I & J I have the heading 'Invoice Number' & 'Invoice Amount' respectively.

What I have done is to make a condional formatting so that If I put a value in cells in column G it will change the colour of the adjacent cells in columns I & J, likewise If I fill in cells in column I the conditional formatting will change the colour of adjacent cells in coulumn G & H. This helps me to see whether a row contains a credit note or an invoice.

What I would ideally like is for a Macro that would automatically locks cells G & H in a particular row that I am currently working on if I enter data into the cell in column I. Likewise if I am entering data in column G in the row I am currently working on for a credit note, then lock columns I & J in the row I am currently in.

Any Ideas how this can be done? Also can locking and unlocking of cells be done in VBA while the sheet is protected or would the macro need to temporarily unprotect sheet, lock the cells then protect sheet again?

PS: I have uploaded a Jpeg of what my conditional formatting does to try and illustrate what it is I need.

View 14 Replies View Related

Automatically Copying Rows From One Sheet To Another Depending On A Cells Input

Jun 2, 2009

i have a certain column that tells me if a client has withdrawn from the company, and the column just says "y" or "n" i want excel to automatically copy the whole row to another sheet if that cell is a "y" for yes the client withdrew...

View 9 Replies View Related

How Can I Populate The Combobox From Cells In An Xl Sheet

Jun 10, 2008

I have successfully used the course booking form as a base for an input form in an accounting workbook that has several pages. (Thanks to Roy and others for the info; the course booking form on [url]is the best explained piece I have found on the net)

What I would like to do is use a range of cells to populate the combobox so that a user can make a choice from the account descriptions (from a sheet named Intro, b63:99) and have the form return the account number (Intro, a63:a99) to the relevant cell elsewhere in the workbook. The user would then have meaningful descriptions rather than numbers to choose from.

My coding for the form thus far is as follows.

View 10 Replies View Related

Way To Name A Sheet Depending On The Content Of A Cell

Jul 14, 2009

on sheet1 cell a1 is there a way to make sheet1,s name appear as the contents of cell a1

View 9 Replies View Related

Populate Cells Based On Data In Another Sheet

Feb 24, 2010

I run this macro that populates 7 cells based on data in another sheet. It seems that every sheet that have formulas that point to this sheet are being stuck in in the screen updating somehow?

Basically when I press F9 to calculate or change any cell that makes the sheet calculate it has like a screen burn in of all the sheets that are being calculated. I have been able to use this as a workaround:

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
Application.ScreenUpdating = True
End Sub

But I shouldn't have to do this and it slows it down as it runs through this specific code about 11 times for each sheet that is re-calculating. Something is getting stuck in memory or something that seems to be causing this issue. This is the code I am using and I am not selecting any cells or sheets, but it appears that when I walk through the code that an image of the sheet comes up on the screen? The code in red seems to be what is causing the issues, but I do not know why? I can pass the 2 workbooks along to someone so they can see the behavior if they would like? Just let me know.

Sub populateEmployeeData()
Dim srcWorkbook As Workbook
Dim foundEmployee As Range
Dim srcWorkbookName As String
srcWorkbookName = "XIP_Employee_Data_" & Left(ActiveSheet.Range("B9").Value, 31) & "_" & Format(ActiveSheet.Range("B10").Value, "MMMDDYYYY") & ".xlsx"
If IsWorkBookOpen(srcWorkbookName) Then..........................

View 9 Replies View Related

Linking Data (look At Sheet 1 And Populate The Date Columns With The Guest Name From Sheet 1)

Jan 7, 2009

Sheet 1 contains a column titled "name" and 6 columns to the right of name titled "sat", "sun", "mon"........ the col titled name is not the first col in the work sheet.

In each row I enter the guest name under the name col and I enter a room number (example: 1A, 1B, 2A, etc...) in the column to the right that coresponds with the day the guest will be staying.

Name Sat Sun Mon Tue Wed Thu Fri

Mr. Smith 1A 1A 1A 1A
Mr. Jones 3B 3B 3B
Ms. Tiller 4A 4A 4A 4A 4A 4A 4A

Sheet 2 is in the same workbook and looks something like this:

Room # Sat Sun Mon Tue Wed Thu Fri
1A
1B
2A
2B
3A
3B

I want it to look at sheet 1 and populate the date columns with the guest name from sheet 1

I tried this formula =IF('Sheet1'!G:G="1A",'Sheet1!$F:$F,"Available")
It seems to work on the first row but I have problems with any rows below that. Basically it acts like there is no data in the rows below.... I think the fact that the names on sheet 1 are not alphabetical is creating part of my problem? I tried a lookup formula but it seems like it has to be the first column in the worksheet and it has to be alphabetical to work like that.

View 4 Replies View Related

Sheet Population Depending On Cell Data

Jul 21, 2008

I currently written the following formula, but always have issues when adding additional depending on selection.

D8 is the selection ( Validation ) on PERF EXP FORM Tab, Once you enter the selection... you then go to the Accounts per hour Worksheet
=IF('Perf Exp Form'!$D$8="Test1 14-18 station",IF(('10220DBHE'!B9=A6),IF('10220DBHE'!C9 > 11000,11000,'10220DBHE'!C9),"N/A"),"N/A")

Perf Exp Form
Perf Exp Form *ABCDEFGHIJKLMNOPQ4 *1. GENERAL INFORMATION****************5Customer***Date / Name(s)*6ApplicationSheet Size1UP/2UPOrientationSOG/EOGFold TypeFold Plate# CH***78 1/2 x 142 UPPortraitSOGLetter/ZHeavy1***8Machine / model**Enduro 4-6 station9ConfigurationCHANNEL 1CHANNEL 2CHANNEL 310590-4720-4910 Dual DeckNONENONE11Date / Name(s)*** Excel tables to the web >> Excel Jeanie HTML 4 ......

View 9 Replies View Related

Auto-Populate Excel Sheet From Master Sheet Of Data

Mar 1, 2014

In this attached example, this is a portion of a actual work procedure. The yellow highlighted cells are the same work element within the master procedure but one is for one type of machine while the other is for same model but added options. This is a pattern throughout the entire worksheet. Basically 1 model with several different types of options. I don't want to have unnecessary elements in a work procedure.

So what I am trying to accomplish, I want to create a userform or dashboard which will allow selection of model #, model type #, then based off those selections have excel populate a worksheet with all correct procedures based off model type choice.

In this example there is 6 model variations, all share same basic procedure, but all have their own work procedure based on options, so my above approach will allow me to make changes to the master procedure only instead of changing 6 procedures.

View 6 Replies View Related

Excel 2010 :: Copy Range Of Cells From One Sheet To Another Depending On Option Being Selected From Dropdown Box

Aug 13, 2012

Using macro's on Excel 2010. What I'm trying to do is create a macro that will copy a range of cells from one sheet to another depending on a option being selected from a drop down box. I've tried to use formulas but without success.
sheet 1 contains a list of approx 20 people with rows containing sales figures per week.

Is it possible to have a macro that will copy the rows to sheet2 depending on the dropdown? The drop down has already been setup with people's names

E.g.
if sheet 1, cell a1 (with data validation setup) dropdown contains "mr smith", copy sheet2 row A1:A9 to sheet 1 cell a2
or
if sheet 1, cell a1 dropdown contains "mr cooper", copy sheet2 row B1:B9 to sheet1 cell a2
etc... for each name in the dropdown

The idea is so that i select a dropdown and it copies the sales figures that match the dropdown name, if i then select another dropdown, the corresponding figures are copied to the same place.

View 3 Replies View Related

Transfer Info From One Sheet To Another Depending On Cell Input

Jun 26, 2012

I am wanting to transfer data from one sheet to another depending on cell input

Example:

If I enter "2" in sheet1 cell B1, then I want a macro to take A1 to sheet2 but place it in A1 & A2.
Then say I enter "1" in sheet1 cell B2 goto sheet2 and put A2 into A3 and so on.

Depending on the number entered on sheet1 column B, the Macro duplicates the info from Column A in that row into column A on sheet2. ??

View 5 Replies View Related

Macro To Copy To Specific Sheet Depending On Cell Value

Jul 28, 2006

This is the code I have:

Sub Auto_Open()
Sheets("Data").Select
Range("A2:E32").Select
Selection.Copy
Sheets("May").Select
ActiveWindow.SmallScroll Down:=-9
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
Sheets("Data").Select
Range("A1").Select
ActiveSheet.Paste
Range("A1").Select
Sheets("Sheet1").Select
Range("A2:E32").Select
Selection.ClearContents
Range("A1").Select
End Sub

1) How do I set this up so that if the cell Z1 reads 1, it will paste the data to the "January" Sheet, if Z1 reads 2, it will paste to "February" Sheet, if Z1 is 3 it will paste to "March"......

View 9 Replies View Related

Formula To Populate From Monthly Sheet To Summary Sheet

Jul 7, 2014

refer to attached file.

I have monthly sheet Jan,Feb,Mar.....Dec.

I also have Summary Sheet, Cell A85:C96 is labeled as Jan,Feb.....Dec (Vertical) Cell B84:E84 refers to Store1,Store2,Store3 and Store4.

I need a formula to summarize the monthly value for each storein row 60.

View 2 Replies View Related

Create New Sheet For Each Row Of Another Sheet Auto Populate Data.

Mar 19, 2008

i have a sheet called 'sample database'. it consists of 56 columns, each with a specific title in row 1. i.e. name, surname, mobile_number, and so on.
from row 2 onwards the data has been populated for roughly 200 rows.

i have another 'Capture Sheet' which has the same titles as 'Sample database' except it's in a different format. its a printable form that is given to new employees when they start. once they have completed it it gets captured into the 'Sample Database' sheet.

my wifes boss now wants 1 new sheet for each row in the 'sample database' sheet based on the format/layout of the 'capture form'.
how can i get the 'capture form' to auto populate the data from the 'sample database' sheet and create a new sheet for each row?
i know this is possible i just dont know how to do it.

View 9 Replies View Related

Auto Populate From A Master Sheet To Another Sheet

Jun 7, 2014

I am trying to auto populate one spreadsheet from a master sheet

What I am trying to do: I have a master sheet where information on 25 countries is entered. Sheet has multiple columns for data entry I have 25 additional identical spreadsheets that correspond to one of the 25 countries so can drill down to country specifics

From the master - is it possible to select a country from a drop down menu so when I start entering data on the master it auto populates the corresponding sheet by the country selected.

View 8 Replies View Related

Populate Data To New Sheet From Master Sheet?

Jul 22, 2014

I have a master sheet that contains all data relating to a particular Agent like Agent Code(Primary Key), Name, Bank details etc so on and so forth. Every month I have to make a new sheet which contains only a few of the columns from the master sheet. I have to manually select and copy each column for the specific agents to whom I have to make the payments. Now, I wanted to know..if there is any way in which I can enter only the Agent Code in the new sheet and it will look the code up in the master and copy the values of the relevant fields from the master to the new sheet.

View 1 Replies View Related

Populate Checkboxes In One Sheet Based On Another Sheet

Oct 11, 2008

I have a spreadsheet (Sheet A) with various data and checkboxes that I want to populate based on data in another spreadsheet (Sheet B). Sheet B has various fields with yes/no answers in the cells. I need to take this data and check varius check boxes in Sheet A based on the answers. I think this is possible if I write a macro to sweep through Sheet A to populate everything, but I was wondering if there is an easier way?

I would think there would be a way to set the initial state of a checkbox based on the value of a cell, but I can't seem to find a way to do it.

View 3 Replies View Related

Have Userform Populate Only Active Sheet Not By Sheet Name

Dec 4, 2012

I have a userform in my workbook with a button to access it on twenty different sheets in the workbook. Currently the userform will only populate the sheet titled "Blank1". How can I change it so it will populate the active sheet without naming it? So no matter what sheet I'm on when I hit the submit button the userform will populate only the sheet I selected the button on? See macro below.

Code:
Private Sub OKButton_Click()
Dim NextRow As Long
Sheets("Blank1").Activate

' Unprotect Sheet
ActiveSheet.Unprotect

[Code] ..........

View 2 Replies View Related

Populate Cells/Table Depending On INDEX Result

Feb 7, 2007

I am trying to populate a table (a7:c27) in the attached sheet with data.

First, I must enter a number 1-16, which uses index function to return either "series" or "base"

If it is base, i want the number in the corresponding table filtered down - i.e. if 1 originally picked then h7 is (40) is entered into each month as base = constant.

If the result is series, then the data in i7:z7 is entered into the the 18 month table.

View 3 Replies View Related

Populate Cell From Another Sheet And Hold Result

Apr 3, 2014

If I populate a cell from a cell on another sheet but plan on deleting the data on the other sheet is there any way to hold the result on the new sheet even if I delete where it came from?

View 3 Replies View Related

Get And Display Pictures (in Folder On Hard Drive) Depending On Cell Value In Excel Sheet?

Sep 9, 2012

I am working to make an automatic result card in which excel automatically gets data of every student which is present in sheet within the workbook by simply writing roll number of the student in a cell. and i have done it easily by Vlookup and index functions but the only problem i am facing is, that i want to show the picture of each student by roll no. pictures are in one folder on my hard drive, now i want that as the roll number of the student is written the result excel should display the picture (from the folder, each picture named by roll)of the student. for example i write 1234 in roll no cell and want to get and show the picture no 1234 in another cell. (from the folder)

View 2 Replies View Related

Populate Summary Sheet With Same Cell From Multple Sheets

Jul 14, 2007

I'm attempting to pull the same cell ($a$1) from multiple sheets into one summary sheet, populating a column in a table.

I though I might accomplish this by putting an array formula in the desired column of my summary sheet that was similar to the following, to pull cell A1 from every sheet between the Frst Sheet and the Last Sheet.

For example:

=FirstSheet:LastSheet!:$a$1 (CTRL+SHIFT+ENTER)

This gives me #REF errors.

The values in $a$1 on each sheet are Text (addresses)

Anyway I can do this without Macros? The number of sheets between the First and Last will vary at any given time.

View 9 Replies View Related

Copying Cells From One Sheet To Multiple Sheet And Naming Sheet As Copy Text?

Dec 24, 2013

I want to do a loop where you can copy say A3 worksheet 1 then add another sheet naming the work sheet "A3" then copying A3 worksheet 1 to A1 "A3". After that looping to A4 to a new work sheet naming the work sheet "A4"copying the value to A1 "A4", etc...

Is there a simply way of doing this loop? I can probably fit my other coding into the structure.

View 4 Replies View Related

Drop-List: Populate Dates In Cell Range On Same Sheet

Oct 8, 2006

I'm need to add a droplist with periods 1,2,3,4 etc... that references a cell then populates that same reference in a cell raange. Example: cell E1 contains the droplist with periods 1-4 as choices to select from, when you select period 1 it populates the dates jan 15 in cells E4:E7, if you select period 2 it populates dates jan 31, etc. how to add the droplist, how to expand the list, show the formula and how to expand it as I will have more data than this short example.

View 3 Replies View Related

Pasting The Sum Of Two Cells From One Sheet To One Cell In A Different Sheet

Nov 10, 2006

I'm trying to write very simple code that copies totals from one worksheet and pastes to a different worksheet. Normally, it is a one cell to one cell copy/paste. For instance, I want to copy the total found in cell "C4" in Worksheet "BalanceSheet" and paste it into cell "C14" in Worksheet "SpreadFinancials." I'm able to do this fine, and the code below is what I've been using.

Occasionally though I'm needing to sum up 2 cells in Worksheet "BalanceSheet" and only copy/paste the summed total into one cell in Worksheet "SpreadFinancials". For instance, I want to sum the totals found in cell C8 and C9 in Worksheet "BalanceSheet" and then paste that summed total into cell "C8" in Worksheet "SpreadFinancials". I'm looking for simple code that does this. Here's an example of what I've been doing so far for one cell to one cell copy/pastes:

Sub PopulateFinancials()
Sheets("BalanceSheet").Range("C4").Copy Sheets("SpreadFinancials").Range("C14")
Sheets("BalanceSheet").Range("D4").Copy Sheets("SpreadFinancials").Range("E14")
Sheets("BalanceSheet").Range("E4").Copy Sheets("SpreadFinancials").Range("G14")
End Sub

View 4 Replies View Related

How To Populate Data From One Sheet Into Another Sheet

Mar 3, 2014

Any way to have a formula populate certain data from one sheet into another sheet...for all records in the data sheet.

I have thousands of individual locations that need to be separated by result into individual sheets.

So for instance:

In Sheet1 I have all the results as so:

location
date
chemical
result
error

A-1
1/1/2001
Aluminum
1.00
0.01

And in several other sheets I have a standard "form" set up for the way it is to appear in a report.

So, on the 'form' in Sheet2: the location of 'A-1' will have to populate in cell B6; Time of '1/1/2001' in E6; Chemical 'Aluminum' in A17; Result of '1.00' in B17; error of '0.01' in B24.

View 7 Replies View Related







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