Automatically Mirror Specific Range On Another Worksheet
May 13, 2009
Hello, what I would like to do is take a portion of a sheet..... So the cells I want to mirror are in the proposal sheet cells B32 x F51. And then mirror the exact duplicate copy to another sheet. The other sheet should have those same values at A20 X G39. What I am trying to do is have a sheet that has skus, prices, and so forth and then when I add,delete, merge, color, or do anything to the cell on the "proposal creation" sheet I want it to mirror only a specific cells to another sheet that is "salesman copy" that we will print to clients. So this way ont he proposal copy a salesman can insert rows or even change the color of the cells and then have it mirror exactly the same on the "salesman copy" which is what we will print for clients.
View 9 Replies
ADVERTISEMENT
Aug 19, 2007
I gather data and several sheets within a workbook and sort the data regularly. I have a tally sheet that references these sheets. My problem is that if I make a cell bold or red in the main sheet it does not show bold or red on the tally sheet. Is there a way to get the format to carry over to the tally sheet?
View 2 Replies
View Related
Jun 17, 2008
How can I write a macro to mirror x data that will be charted using xy scatter? The original data is entered into excel using measuring equipment with a footswitch. I need excel to automatically mirror the incoming data as it comes in. It should look like my example only with 2 more columns to the right with mirrored x data in the 1st and the same Y data in the second. Example.xls
View 9 Replies
View Related
Jul 9, 2014
I would like to mirror a range of cells between two sheets in the same workbook, so that if the data is manually input into one of the cells in range (E5:H11) in 'Sheet 1', it is automatically updated in the corresponding cell in (H33:K39) of 'Sheet 2', and vice versa.
Using Office 2013. T
View 6 Replies
View Related
Aug 19, 2008
I am looking for VB code that will format a range of cells from a number format to a percentage format based on a reference cell. The reference cell is a drop down created from a list validation.
For example: If the reference cell (cell A1) =1 then cell range B2:C4 would be a number format. If A1 = 2 then cell range B2:C4 would be a percentage format.
I have searched for hours trying to find a relevant thread; I know they are out there, maybe I just wasn't typing in the correct search words.
View 5 Replies
View Related
Jun 4, 2008
i need to put a date stamp when a change is made in b3:b31 into e3:e31 for each row also i need to put a date stamp into g3:g31 when a change is made in F3:f31 i try to use 1 "worksheet-change" and it is fine once i use 2 i get Ambiguous Name Detected errors
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("b3:b31"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 3).ClearContents
Else
With .Offset(0, 3) ............
View 9 Replies
View Related
Mar 19, 2014
I've tested and I'm getting errors trying to reference a range in a specific sheet.
I want to sum a range for further calculation and can get this to work perfectly if I don't specify a sheet - but it sums the range in the wrong sheet as the code is within a With statement range:
[Code].....
I've checked that wsSumm contains the 'Summary' worksheet value and that's all fine, I've also tested the following:
[Code] ....
I've also tried replacing wsSumm with Worksheets("Summary") and Worksheets(1), but get exactly the same results, so no it's not a fault with the worksheet variable. Also tried using Application.WorksheetFunction.Sum, but again exactly the same results.
So, why I can't sum the range on the specified worksheet? Is is something to do with being inside a With statement for another worksheet - though I've not come across problems with this before...
View 3 Replies
View Related
Mar 26, 2014
I have a macro assigned to a button that saves the worksheet as a PDF in a certain folder, but what I cant do is make the Macro look at a certain cell to save the file as a specific batch number.
This is the macro I have so far, I want the macro to do as below but to also look at cell L3 in the same worksheet and save it as the number what is in that cell.
[Code] ......
View 1 Replies
View Related
Apr 16, 2014
I would like to change the greater than number to the value in cell 'I11' in sheet 'Linear Programming Data' and the less than number to the value in cell 'I12' in sheet 'Linear Programming Data'. The code I am using was done by recording a macro since I don't know how to code in vba.
Code:
Sub Results2()
' Results2 Macro
' copy table filter power by greater than and less than
Sheets("Finalizing Results 2").Select
Cells.Select
[Code] .......
View 2 Replies
View Related
Feb 14, 2012
I am fairly new to macros and have trouble with VBA. I have a file with multiple worksheets. Each worksheet contains the name of a specific location in cell A8. I want this name in cell A8 to be the name on the worksheet tab for each worksheet in my file but do not know how to accomplish this. Is that even possible?
View 3 Replies
View Related
Feb 15, 2009
I am starting within a workbook with a standard invoice/form. During the course of a month this invoice will be copied 20 to 30 times within the workbook and the amounts changed each time. Is there a way that I can:
a) Have amounts from 2 of the cells (say E30 and E31) within each new invoice worksheet automatically included on a summary page? These cells are calculated by formula.
b) (This one would be nice but is not essential) Have each new invoice worksheet that is added (by copying) automatically numbered sequentially in a cell (say A2) and also re-named with this number. The first existing invoice would be manually numbered and each additional invoice would follow from there.
View 5 Replies
View Related
Nov 4, 2013
I would like to take cells from sheet 2 and have them copied into sheet 3 automatically. How do I do this? So as I am updating information in my sheet two, I don't have to manually input the information into sheet 3.
I would like Sheet 2 cells O:3, O:4, O:5, O:6 quantities to automatically be updated in Sheet 3 cells A:2, A:3, A:4, A:5.
View 3 Replies
View Related
Jul 28, 2009
I would like to instantly mirror any selected cell within a specific column into another specified cell.
Example:
If A1 has the value 4, A2 has the value 6, A3 has 7, A4 has 9, and I click on those cells in the order above, I would like to see the cell I specify show the same value when I've selected (clicked on) them.
View 5 Replies
View Related
Aug 22, 2009
A macro was submitted in a similar thread, but I have a slightly different problem. I have empty cells, A1:A10, and in cells C1:C10 I have data. If A1 is selected, I would like to be able to click on any cell in colum C and that info then appears in A1. Then I will select A2, and again, click on any cell in C1:C10 and that appears in A2 and so on. I do not want cells A1 etc. to
change once populated. This can be a macro as well.
View 8 Replies
View Related
Nov 1, 2008
I have created a garden bed planting chart in excel. I made each cell a square where each cell will be equal to 1 square foot and simply typed in the plant name that will be planted in that spot. The planting beds will be on each side of a sidewalk. I want a mirror image of the layout for the opposite side of the sidewalk. How do I do this in excel?
View 9 Replies
View Related
Sep 3, 2009
in ROW 1 I have columns A thru AD populated with a number in each cell. what I need to do is take that number and fill the below cell with the number times a set character. for instance, A1 has "4" in it, so I want A2 to look like "----"
View 3 Replies
View Related
Feb 22, 2013
I want to make a mirror copy of worksheet so that i can use filter option more than one names for the same column and for same sheet.
View 5 Replies
View Related
Jun 25, 2013
Using Office 2011 for mac, but felt this question was best suited for general.
Here is the situation.
I have a workbook with three sheets. It's a price/invoice/labor workbook.
Sheet 1 has all the data, including my cost and loss/gain fields
Sheet 2 has labor costs and the totals are linked to Sheet1
Sheet 3 is the customer copy of the first sheet. It does not include wholesale and profit info.
I'm trying to link the cells so that when info changes in Sheet 1, it's reflected, in real time on Sheet3
Right now I'm using a formula per cell ='Sheet1'!XXX (where XXX = the cell/column location, ie D15). The first column I started has this formula in every cell, about 100 in all, copied by hand and changed to reflect. It works, but it seems like there has to be an easier way to mirror or link the data. I tried pasting special with links, but continue to get errors as the link pather includes the entire file data path from the local machine.
I still have about 200 cells left and I'm dreading doing this all by hand. Also, If I add a new row to sheet1, this will not reflect in sheet 3.
View 7 Replies
View Related
Nov 16, 2009
I have some software that was written for me that scrapes data. It has a file in it that mirrors the web pages that it is scraping.
I would like to actually import those web pages one at a time based on a condition in the browser. The code of the web page is html. When one of the 35 mirror web page's "MTP" = "POST", I would like for all the web page to be loaded into a sheet called WPS. I would want that to stay loaded until "MTP" = "OFF". There may be more that one of the mirrored web pages with "MTP" = "POST". In that case, only one can be loaded at a time and that is fine. Once the "MTP" = "OFF", I want it to go to the next mirrored web pages with "MTP" = "POST" and load that web page from the mirror file.
Here are 4 of the 35 web pages that are mirrored and their paths
C:TotearkmantotemirrorWPSAQU.HTM
C:TotearkmantotemirrorWPSBEY.HTM
C:TotearkmantotemirrorWPSCTN.HTM
C:TotearkmantotemirrorWPSDDN.HTM
View 9 Replies
View Related
Mar 9, 2007
How do I copy a range of cells containing formulas to another range of cells without chaning any of the letter or numbers from the original. I want a mirror copy of whats in A3:B10 to got to D3:E10..
View 3 Replies
View Related
Jun 7, 2007
Is there a way to mirror two ranges of data on different sheets - i.e. if I update one sheet, it updates on the second, without using formulas, macros.
View 3 Replies
View Related
Oct 9, 2009
Here is what i am trying to achieve. If the date 2/20/2010 is located at F53 & the cell next to it at H53 is populated with a number between 1 & 16, then i want the cell at J11 (42 rows further up) to auto populate with the number 1. When this occurs the cells beneath this, from J12 to J52 should also auto populate with the with consecutive numbers from 2 to 42. Would also like to see the cells with numbers 1 to 28, automatically format to orange & the cells containing numbers 29 to 42 automatically format to yellow. I plan to have this condition repeat several times later in the year, at dates that are to be decided. When these dates are decided i want to be able to enter a number from 1 to 16 & next to the date & all of the above automatically occurs.
View 14 Replies
View Related
Jul 1, 2014
Looking to have a macro call a subroutine every time it finds a cell meeting specific criteria.
Code in plain english would look like this:
For EACH cell in range A1:BZ500 meeting the following criteria:
Cell value is a date
AND
Cell's date is at least a week or more in the future
AND
Cell background (Fill) = RGB color code: (R:191 G:191 B:191)
DO the following:
Call repeatingsub
View 11 Replies
View Related
Oct 20, 2006
I have a list of names on my first sheet, and I want to mirror these on a second sheet, but at the start of a repeating table containing data releating to each named person. eg. I want a Name in
'Sheet 1'!A4
to display in
'Sheet 2'!A5
, and then the name in
'Sheet 1'!A5
to display in
'Sheet 2'!A32
View 3 Replies
View Related
May 12, 2008
What I am trying to do is to write a macro that will automatically copy six columns from worksheet (Sheet 1) to another worksheet (Sheet 2). i.e. ‘Description of Project’, ‘WBS Code’, ‘Rate’, ‘Employee Name’, ‘Premium’, ‘Invoice’, ‘Status’, ‘Total Cumulative Hours’, ‘Total Cumulative Amount’ from Worksheet (from Sheet 1 to Sheet 2)
The problem arises as I know the names of the columns to be copied in Sheet 1 (as details above) but they can be in any order in sheet 1.
In additional the columns ‘Total Cumulative Hours’, ‘Total Cumulative Amount’ are total columns so when they are copied from ‘Sheet 1’ to ‘Sheet 2’ their values should be copied as opposed to the formulas
View 9 Replies
View Related
Feb 23, 2010
to illustrate I attached a spreadsheet.The spreadsheet contains 5 colunms.
1. Names
2-4. Numbers
5. Sum of numbers (the formula for the sum is only entered in the first row)
What I want to do is automatically fill in sums from the second to the last row. I was trying it with the "record macro" function but failed because I don't know how to jump to the last row. CRTL-Shift-down is not useful in this case.
View 5 Replies
View Related
Jul 7, 2013
my 1st sheet like this : A1="Reg.No."
B1="Name"
i want -when type a No.&Name in A2 & B2 to inserted a new sheet (sheet2)which is it's name is that No.&Name and also a link between the cell and sheet...
View 1 Replies
View Related
Apr 28, 2014
Is it possible to have a column count up if two other cells meet criteria?
What I would like to happen (if it is even possible) is, if cell B1 equals CO and C1 is a duplicate, then G1 enters #1 for the first time it is duplicated, #2 for the 2nd time it is duplicated, etc.
Is this even capable of happening.
I am attaching my spreadsheet (TAB "AG Orders"). I filtered the spreadsheet so you can see an example of what I am looking for. I manually typed in column G but I was hoping these numbers could automatically populate.13-14 budget-AG test.xlsm
View 9 Replies
View Related
Mar 11, 2014
Is there anyway to read a specific cell from many excel files automatically and add them to a new workbook?
I tried to link that specific cell to a new workbook manually but now I have a problem: If I change the name of any workbook that is linked to the new workbook, Excel can't update the new file name
View 7 Replies
View Related
Nov 18, 2013
Is there a way for me to enter numbers in my cells and have them a specific color? I want all my odd numbers to be bold red with a yellow highlighted cell, my even Numbers to be green with a gray color cell.
I want it to look like this 7 and 8. I can not seem to find anything to show the high light but basically the red 7 will be in a yellow box and the green in a light gray. I will be entering rows and rows of anywhere from 4 to 8 digits
View 3 Replies
View Related
