Hide Specific Rows In Sheet1 And Hide 5 More In Sheet2?

May 26, 2014

I have a macro in which i can enter the rows i want to hide.

If i want to hide "position 32" i have to enter the number 8 of the row. This works fine. But now if i want to hide the "position 32" from Sheet1 it also should hide the rows 4-8 from Sheet2 [Data with 32].

Or if i hide "position 34" in Sheet1 [row 10] it also should hide the rows 14-18 in Sheet2.

View 14 Replies


ADVERTISEMENT

Find Values From Sheet2 On Sheet1 And Hide Those Rows

May 17, 2013

I have two sheets in a file called MyFile.Sheet1 has a full table of data in named range "myNamedRange" - an array that spans Sheet 1 from A2:K322.Sheet2 has a list of data in Column A (Range A2:A85) that I need to find in Sheet1 - either directly by the column the data is most likely to be found in [in this case, Column C ( specifically Range C2:C22)] -OR- via the named range array.

GOAL: Use the list of values in Sheet2 to hide all rows on Sheet1 that match.

View 2 Replies View Related

Hide Columns On Sheet2 Based On Cell On Sheet1?

Jan 25, 2010

This is what I would like to do if possible: If E9 on Sheet1 is 1, then hide columns F-L on Sheet2.

View 4 Replies View Related

Excel 2010 :: How To Populate Sheet2 From Sheet1 After Finding Matching Word On Sheet2 From List In Sheet1

Oct 4, 2013

I have 2 Worksheets in an Excel 2010 Workbook -

Sheet1
Column1: contains the word "dog"
Column2: contains the word "bark"

Sheet2
Column1: contains the sentence "I like dogs a lot."
Column2: is blank

What I need to do is search Sheet2/Column1 for the presence of "dog" and if it's present, populate the word "bark" in Sheet2/Column2 from Sheet1/Column2.

How can I do this?

View 4 Replies View Related

Copy Specific Cells From Sheet2 To Sheet1

May 11, 2009

copy specific cells from Sheet2 to Sheet1. How would I change this macro if I wanted to copy all of Column B from Sheet2 to Sheet1

View 2 Replies View Related

Hide Specific Rows

Jan 9, 2008

I have an Excel File Ulip21.xls with several sheets in it. In the “INPUT” sheet, I have two cell “O9” and “O10”, where I input two values.

In Cell O9, I input the “Enter Term Of a policy”, which ranges between 1 and 50.

In Cell O10, I input the “ Fixed premium per year (Yes / No ) “ , where the answer is either Yes or No.

If the input in O10 is Yes, then rows 31 to rows 82 should be hidden as those are the rows, where I input irregular premiums.

Now I want the following …..

If the value of O10 is Yes, then rows 31 to 82 should be hidden ...

View 9 Replies View Related

VBA - Button Command To Auto-Hide Rows With Value HIDE

Jun 9, 2013

Sub Button294_Click()

If Sheet1.Range("A34:A94") = "HIDE" Then
For Each cell In Range("A27:A94")
If UCase(cell.Value) = "HIDE" Then
cell.EntireRow.Hidden = True
End If
End Sub

View 4 Replies View Related

Hide Rows Which Dont Have Specific Values

Sep 13, 2006

I’ve got a spreadsheet with approximately 30,000 rows and I would like to create a macro which hides every row which has not the value 12, 14 or 19 in column I. What is the best way to do it? With an if statement?

View 4 Replies View Related

Hide Rows Based On Value In Specific Cell

Apr 8, 2008

Cell A1 can be left blank or have any value 1 to 99999 inserted by the user. Default value is null. My data starts on row 5 and currently goes to row 62, but will include more rows over time. I want to automatically hide rows 5 to 62 (and higher later on) where the value in Column C (C5, C6, C7, etc) is less than or equal to the value in A1 as long as A1 isn't null. If A1 is null, then no row hiding would be done. Ideally would be great to have msg also that says "No rows hidden" or "10 rows hidden", but not critical - just nice to have if you can provide such easily and quickly otherwise I'll just try to learn it later on.

View 7 Replies View Related

Compare And Copy New Rows From Sheet2 To Sheet1 If Conditions Met

Feb 21, 2014

I have a sheet of data (Sheet1 below) running into almost 1000 rows. Each month, I get an updated sheet (Sheet2) which has overlapping data with sheet1 (rows starting with N, O, P, Q), new data (rows starting with R, S) and data present in Sheet1 but not in Sheet2 (row starting with M in Sheet1). The columns "Item" and "Quantity" in sheet1 are populated by me and are blank in sheet2. The table below explains the structure.

Sheet1
Name
ID
Date
Item
Quantity

M
231
14/03/2001
egg
5

[Code] .......

It gets tedious to update Sheet2 every month. Is it possible to merge the 2 sheets into a Sheet3 (like below) if Name, ID, Date in each row is an exact match?

Sheet3
Name
ID
Date
Item
Quantity

M
231
14/03/2001
egg
5

[Code] ........

Further, it will make my job much easier, if it was possible to identify rows only present in Sheet1 and add a tag "absent in new" in a new columnidentify rows only present in Sheet2 and add a tag "new" in the new columnidentify rows with matching data in Name, ID, Date in Sheet1 and Sheet2 and add a tag "current" in the new column.

Something like the table below:

Sheet3 (Desirable)
Name
ID
Date
Item
Quantity
Comments

M
231
14/03/2001
egg
5
Absent in New

[Code] ...

View 2 Replies View Related

Macro To Auto Hide Rows In Specific Range

Jun 10, 2014

I have the following macro to autohide some rows with no data, however its remove rows starting from column A.

[Code] .....

How do i fix this to only hide the rows in the range (H4:V50)?

View 5 Replies View Related

How To Hide Specific Rows Based On Values In A Different Worksheet

Mar 7, 2014

Say I have two worksheets, "Sheet1" and "Sheet2". Let's also say A1 in Sheet1 could have one of four values: cat, dog, rabbit, mouse. Now, based on which value cell A1 on Sheet1 is, I need different rows hidden in Sheet 2. For argument sake let's say if cat is chosen rows 1-5 are hidden, if dog, 6-10 and so on.

View 5 Replies View Related

Hide Specific Rows When Certain Value Chosen From Cell Drop-Down

Feb 22, 2009

Basicly I used conditional formatting and lots of "IF".My solution lacks in style and it's time consuming ..

Long story short: I need to modify the way some cells are displayed based on the selection in a specific dropdown list.

I need that whenI select Task3 from the dropdown list next to "step1: please select" , everything from row 15 to row21 (both 15 & 21 rows included) and from row 23 on, to disappear.

View 9 Replies View Related

Copy/past Rows From Sheet1 To Sheet2 But Only If - Automate Process?

Jun 24, 2009

I have two sheets: Sheet1 - linked from external file, new data coming daily.
Sheet2 - I need to copy/past Rows from Sheet1 to Sheet2 but only if B-cells are not empty. How can I automate the process?

View 2 Replies View Related

Enhance Existing Code To Hide Rows Between Specific Text

Mar 24, 2014

I have a workbook which contains 8 worksheets. I want to able to run a macro that looks for specific words in column A of each worksheet and hides any rows in between the specified words. The following code works except if a worksheet does not contain the specified words. Is there a better way to accomplish this?

Attached is an example of the spreadsheet. The code below works just fine on the tabs highlighted in green, but halts on the tab highlighted in red. The tab highlighted in yellow is showing you the rows I need to hide.

Example.xlsx‎

View 5 Replies View Related

Compare Sheet1 With Sheet2 And Copy Unique Values In Sheet1

Aug 13, 2014

I am using the below code and it is not performing the operations of comparing and deleting the duplicate values from sheet1 and pasting unique values in sheet 1, p.s. Do not need values from sheet 2, just want to compare the sheet 1 with 2 and delete dups in sheet1.

[Code] .....

View 2 Replies View Related

Match Value In Sheet1 For Sheet2 And Copy To Sheet2?

Mar 4, 2014

I have a large file + 400 000 rows that has zip code but not city name in sheet2, in sheet1 I have a list of zip code and city name. I need to get the correct city name for the zip code in sheet2 by using the info from sheet1. I attached a file as an example how it looks. I do have lots of other data in the original files that I have removed. This is not doable manually by using filter, to many rows so I need a script to run it.

View 2 Replies View Related

Formula To Separate Specific Data From Data List In Sheet1 Into Sheet2 / Sheet3

Jun 30, 2014

I have attached a sheet that has part of a data list, sheet called (Full Data) what i am trying to do is seperate the data into event locations into individual sheets.

The data ref will be column F which is the different event locations.

I thought the best way to try and do this was to create an if/ match formula using the sheet tab names as the if match, with the event locations in column F.

I have added two sheet tabs so you can see that i require the data for (Ain) to be put into the Ain sheet.

The data list in Full Data sheet will be continuously updated so i will need the range to be around 10,000 entries.

View 5 Replies View Related

Replacing Sheet1 Data With Sheet2 Data For Specific Columns Using Macro

Mar 8, 2014

I have data in sheet 1 like below

Custid loc city
123 us newyork
124 uk wales
876 in mumbai
Sheet 2
custid newcustomerid
123 756
124 394

Outputsheet:
Custid loc city
756 us newyork
394 uk wales
876 in mumbai

So it will check sheet1 custid with sheet2 custid. If both matches it will replace custid with newcustid.if cust id not exists it will load sheet1 recprds as usual.

View 1 Replies View Related

Query Hide State Of Column Ranger And Hide If False

Jun 18, 2009

I want to create a macro that checks whether a specified range of columns is hidden, and

a) hide them if they are not hidden, or
b) unhide them if they are hidden,

i.e. toggle the Hide state.

What method can I use to query the hidden state of a selected range of columns and return a boolean value?

View 2 Replies View Related

VBA To Find Value From Sheet1 In Sheet2?

Jul 14, 2014

I want to find a value from Sheet1 in Sheet2. The code below has worked in the past, but this time Sheet2 has the value as a result of a function and it doesn't seem to recognize it. What do I need to change to make it work?

Sheet1 - the value is a number that has been typed in
Sheet2 - the number is the result of a function

[Code] .....

View 2 Replies View Related

Sheet1 & Sheet2 Transfer

Apr 7, 2009

Sheet1 and Sheet2 data transfer between Sheet1,
Sheet2 should be like. macro solution

View 2 Replies View Related

How To Transfer Certain Cells From Sheet1 To Sheet2

Dec 15, 2013

I am trying to do some kind of sorting?

if the first character of the cell is number or * then copy that cell(row i ) and the cell above(row i -1) to sheet2. I am not sure how to check the first character is *.

The idea is this:

[Code]] .....

View 7 Replies View Related

Dde Data Copied From Sheet1 To Sheet2

Aug 28, 2009

I am enlcosing a file that I partially acquired (the macro portion) and I am trying to add to that.

The workbook has a dde link in sheet 1, the macro will write the data to sheet2 at set times. I am creating a report of the data in sheet 2 in sheet3. at this point it is very rudimentary. I need some assistance to clean up the macro and the post of the dat in sheet2. I have created a detailed (probably over detailed) explanantion in sheet 1 in a text box.

View 11 Replies View Related

Find A Value On Sheet1 And Input It On Sheet2

Nov 27, 2007

If I have 2 sheets names 'User Info' and 'Labels' what i'm looking to do is on the 'Labels' sheet under cell J2 to be able to enter a number, 505 in this case which searches for this number under column B of sheet 'User Info' finds it, looks to the entry in column D (the name Ken) and in turn puts the name into cell J2 in sheet 'Labels'.

The real life use for this is to search a phone extension number in User Info sheet, and use the user name at that extension number and place it in a label on the Label sheet for a reception phone. The Reception phone can have multiple extensions on it made up of any 3 digit number on any where from 3 keys to 12+. So the ability to search for 100-999 is needed.

View 9 Replies View Related

If Row Deleted In Sheet1 Delete Row In Sheet2

Dec 3, 2002

I have 2 sheets Sheet1 & Sheet2

Sheet1 - contains rows of data
Sheet2 - summarizes those rows

I want it so that WHENEVER a row in Sheet1 is removed that same row is removed in Sheet2 and VICA VERSA whenever a row in Sheet2 is removed that identical row is removed in Sheet1.

- this is so that data integrity doesn't get lost if someone removes a row of data in the future.

View 7 Replies View Related

VBA To Populate Cells From Sheet1 To Sheet2

Nov 1, 2012

With a UserForm ComboBox I can select one of the names on Sheet1 ColumnA

I need the values of the selected row

(Columns B:S) to populate the cells of Sheet2 (D6:D14) and
(Columns T:AK) to the cells of Sheet2 (D16:24)

(I'll use a CommandButton to run the procedure.)

View 1 Replies View Related

Copy Array From Sheet1 To Sheet2?

Aug 16, 2013

I have a file. In sheet1, Array from row 2 to row 16 named "Vung1". array 2: row 20 -> 27 with name "Vung2".

I need: In sheet2, if I select "Vung1", Below with echo "Vung1" from sheet 1 (Keep format) and if I select "Vung2", it will echo "Vung2" from sheet1 (Keep format too).

I can't attack file. So I put a Gdocs link.

[URL]

View 1 Replies View Related

Copy Data From Sheet2.xls To Sheet1.xls?

Dec 3, 2007

I have:
- sheet1.xls, this is the source sheet.
column A = model numbers
- sheet2.xls, have the data that I need to copy to sheet1.xls
column C = product description text and in column D = product price
column G = product description text and in column H = product price

What I need to do is to write a Macro that:

open each row in column A in sheet1.xls and search in sheet2.xls in column C if it finds this text (model number) then it should copy row D (product price) and paste it to column E in the right row in sheet1.xls.
Also search in sheet2.xls in column G if it finds this text (model number) then it should copy row H (product price) and paste it to column E in the right row in sheet1.xls.

I hope please that you understand me.
And will be happy if someone could help me please to do that

View 9 Replies View Related

Copy Script From Sheet1 To Sheet2

Dec 14, 2009

i have a sheet called Template with this code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target.Row = 2 Then
If Target.Cells.Count 1 Then Exit Sub
boo = Target.Value
boobs = Target.Offset(-1, 0).Value
nocold = 4
WO_update_cust
End If
If Target.Column = 2 And Target.Row = 3 Then
If Target.Cells.Count 1 Then Exit Sub
boo = Target.Value
boobs = Target.Offset(-2, 0).Value
nocold = 5
WO_update_cust
End If
End Sub

i have another script than unhides a sheet and copys whats in the template to it.

Simply put i want to copy this script to it too.

i used a copy and add sheet method but i need to be able to do this in a shared workbook, hence the hidden sheets instead.

View 9 Replies View Related







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