Excel 2013 :: Mirror Range Of Cells In Different Sheets?

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


ADVERTISEMENT

Excel 2013 :: Printing A Range Of Cells?

Jun 11, 2014

I am using Excel 2013

I need to print to a printer that is not the default printer, a range of Cells e.g. B4:L28 on Sheet Print Out.

The code is to be added to a VBA routine that already exists that collects & arranges the data on the Print Out sheet from other sheets in the workbook. This routine is assigned to a button on another sheet.

View 2 Replies View Related

Excel 2013 :: Eliminating Blank Cells In Range In Row?

Nov 5, 2012

I am using windows 7 64bit sp1 and excel 2010 32bit sp1

I am trying to fix this formula (it takes a range in a unique column, and multiple row:

Code:
=IFERROR(INDEX($B$1:$B$6,SMALL((IF(LEN($B$1:$B$6),ROW(INDIRECT("1:"&ROWS($B$1:$B$6))))),ROW(A1)),1),"")
from here

I want to make it work on my array in a row, like this: (i need to remove the blank cells and the output have to be still in a row)

value1
empty cell
empty cell
value 2
value 3
empty cell
output:
value1
value2
value3

I need a function becouse I have dynamic table with something like 10k rows and 50 columns.

View 2 Replies View Related

Mirror Data Between Sheets?

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

Excel 2013 :: Speed Protect / Unprotect Sheets

Apr 29, 2014

I experience it takes a lot of time to protect/unprotect sheets in Excel 2013. However, only if the operation is made WITH PASSWORD. This was not the case in Excel 2007. Operation was fast independent with/witout password.

In attached file I have made an example where the time to protect/unprotect 25 sheets is investigated. Can make the test in Excel2013 to double check it is not my computer causing the time delay.

Result test - 25 sheets:
Protect - No password: 0,02 s
Unprotect - No password: 0,06 s
Protect - With password: 6,9 s
Unprotect - With password: 6,9 s

View 7 Replies View Related

Excel 2013 :: How To Hide And Unhide Headings From All Sheets At Once

May 14, 2014

i want to hide and unhide headings from all sheets at once (Excel 2013)

View 8 Replies View Related

Excel 2013 :: Auto Naming Pivot Sheets

Feb 28, 2014

Is there a macro available which will create a pre-defined name for a pivot sheet, which will contain the word "Pivot" followed by a underscore "_" and the name of the sheet on which the pivot is applied.

Example: I have data on a sheet called "Salary" and put a pivot on "Salary" on a new sheet, the new sheet should be auto named as "Pivot_Salary"

Am using Excel 2013

View 1 Replies View Related

How To Create Mirror Copy Of Sheets

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

Mirror Two Ranges Of Data On Different Sheets

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

Excel 2013 :: All Sheets Being Automatically Changed To Currency Format

Dec 2, 2013

We have 3 PCs, all running MS Office 2013. On 1 of these machines, it is doing strange things with formatting. If you open a document or try to paste anything into certain documents, it decides everything is currency format and assigns all sorts of wrong formatting to the entire sheet, or the entire document. There may be some cells in the doc that are indeed currency, but only a small proprtion. If I open a new, fresh document and paste into that document, it does not do this, it seems to work normally, only applying currency formatting where it might be applicable. On some larger docs that have this issue, no matter what I do, it just continues to apply these strange settings.

View 2 Replies View Related

Excel 2013 :: Generating Master Sheet From Other Sheets Within Same Workbook

Mar 25, 2014

I have a workbook with five sheets. One sheet is the Master and then one sheet each for four organizations. Each organization will populate data for their own sheet and I want Excel to automatically populate the Master with the info from each individual sheet.

I tried using and modifying the vba from this post [URL]). My workbook varies from the original in that the first seven rows are header rows so the first cell to be edited in each sheet is A8, I have 38 columns instead of 10, and I am using Excel 2013 instead of Excel 2003.

I figured out that I needed to change the vba to look like this to start copying from the first cell (A8) and to populate the master:

This seems to work, but until the first cell (A8) is populated in the organizations' sheets, it messes up the prior row on the Master (Row 7).

I've also noticed that undo becomes unavailable when switching between sheets and also copy/cut & paste between sheets doesn't work so I can't correct the way the script messes up the format initially (this I presume is due to the Copy Destination in the vba?).

View 1 Replies View Related

Excel 2013 :: How To Add Date Range

Mar 4, 2014

I have a big spreadsheet with IT / Finance data. Below is the formula, I currently have. I am summing column Y in Tab Savings Data Detail, where column A does not equal Parent, and The Value in Column AK on the Savings data details tab matches the value in current tab for cell B26 and where column G on the savings detail tab equals Transition to IT. I am adding that value to the second sumifs statement essentially the values in column X on the savings detail tab with the same criteria.

Now I need to add to each of these formulas. I need to sum only the values where the date value in column W on the data details tab is greater than or equal to 01/01/2013 and less than or equal to 12/31/2013

find the easiest way?

=SUMIFS('savings data details'!$Y:$Y,'savings data details'!$A:$A,"Parent",'savings data details'!$AK:$AK,$B26,'savings data details'!$G:$G,"Transition to IT")+
SUMIFS('savings data details'!$X:$X,'savings data details'!$A:$A,"Parent",'savings data details'!$AK:$AK,$B26,'savings data details'!$G:$G,"Transition to IT")

View 1 Replies View Related

Excel 2013 :: Get Range Of Results From Input

Aug 31, 2013

Here is an example of what I am trying to do in E2013.

The orange Bin is my input. It want that to return the column associated with the # as show in orange output column. I think this is an index command? I cannot seem to make it work.

Also - is there an easier way to insert sheets other than a screen grab and photos?

View 5 Replies View Related

Excel 2013 :: Conditional Formatting Twice And Over A Range?

Dec 26, 2013

Using Excel 2013.

I have two columns of numbers. For a row, if the right number is greater than the left number, then color it green, if it is less then color it red.

e.g.

A1 = 100 B1 = 101, then B1 gets colored green
A2 = 100 B2 = 99, then B2 gets colored red

etc.

I have clicked on conditional formatting with A2 selected, then chose A1 for values greater than and chose green. I then copied the formula for all rows. I then did the same for values less than and chose red.

It is not coloring the cells correctly. On some rows when B

View 9 Replies View Related

Excel 2013 :: Conditional Format Named Range

Mar 15, 2013

I have a spreadsheet that keeps track of the equipment we have on rent. Whenever we have a new rental, I insert a row and enter the information. I have several conditional formats I am applying - (1) making the font a light grey so that it is hard to see on any rental that has been called off, but invoicing isn't complete on, (2) making the font red on any item that is within 3 days of the term, and highlighting any row that isn't showing an invoice in over 45 days. When anything is completed (rental has been called off, and the final invoice has been approved), I cut the row out and put it in a sheet entitled "Closed Equipment". When I cut out closed records or add new records, it will occasionally mess up my conditional formatting by only referencing one row. Additionally, I don't want the conditional formatting to transfer over to the "Closed Equipment" tab.

Would this be easier to keep clean and straight if I used VBA? Or should I just continue to occasionally check my conditional formatting and clean it up? I thought if I used a Named Range instead of cell references, it might work better, but entering named range "On_Rent" converts to the cell range ($A$4:$AA$194).

I am using Windows 8, Excel 2013. The file is on a network drive, and others in the office can look at it (they all run Windows 7, and either Excel 2010 or 2007), but they look at it so seldom.

View 1 Replies View Related

Mirror Chart Source Range

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

Excel 2013 :: Find And Replace Values In Selected Range?

Jul 13, 2014

I have Excel 2013. I would like to use the code below but I need it to let me select the range instead of specifying it in the code, then pop up a form into which I can fill in what I want it to search and what I need it replaced with.

[Code] ......

View 3 Replies View Related

Excel 2013 :: VBA Macro For Selecting Current Week Range

May 30, 2013

I currently have this beast of a code running in Excel 2013:

HTML Code:
Sub OBTAIN_RAW_DATA_MACRO()
Dim NextCol As Long

'Copy data
Workbooks.Open Filename:= _

[Code] ........

However the issue lies in that once the data is refreshed, the slicers reading off the above raw data/pivots, automatically select all weeks, however this is not beneficial for the data being presented.

Is there anyway to have, once the Pivots have been updated, for the macro to then check and select current week range (beginning Monday) only?

View 4 Replies View Related

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 View Related

Excel 2013 :: Formula Test If Value Matches Any Item In Array Or Range?

Mar 19, 2014

Using Excel 2013,

It trying to see if the Month() of a date is in a Array / Range

I tried =IF(MONTH(E8)={2,6,9,11},"Yes","No") where E8 = 9/30/12

View 2 Replies View Related

Excel 2013 :: Transpose Data Cells And Formulas?

Mar 3, 2014

How do I transpose a horizontal reading excel into a vertical reading excel and transpose all of the data and formulas?

View 1 Replies View Related

Excel 2013 :: Lock Cells Dependent On Another Contents

May 23, 2014

I am looking for a macros to lock a cells dependent on another's value.

I have a spread sheet for quote numbers I don't want the employees to take a quote number (A) unless all cells have been completed in cells (C-K).

however there is another condition within this where if cell K says yes then lock Cells N O and P, however if it says No these cell must also be completed to take a quote number.

I have also added a macro to force enable macro with a welcome page and a macro to log the user name date and time of entry, I don't want to loose this it seems each time I try a macro for the locking cells or data validation it disables these macros.

View 1 Replies View Related

Mirror Image Or Flipping Cells

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

Excel 2013 :: How To Translate All Characters Of Selected Cells To Unicode

Apr 19, 2014

In Excel 2013, how do I translate all characters of selected cells to Unicode?

There is a formula to translate the first character into Unicode [=UNICODE(text)] and that formula would have worked fine for me .Only if it could translate all the characters to Unicode not just the first one.

View 1 Replies View Related

Excel 2013 :: Translate All Characters Of Selected Cells To Unicode?

Apr 19, 2014

In Excel 2013, how do I translate all characters of selected cells to Unicode? There is a formula to translate the first character into Unicode [=UNICODE(text)] and that formula would have worked fine for me .Only if it could translate all the characters to Unicode not just the first one.

View 10 Replies View Related

Excel 2013 :: Merge ALL Cells With Same Value In A Sheet (rows And Columns)

May 11, 2014

We are doing a graduation project on an international airport, consist of scheduling flights on check-in counters automatically.

long story short, we ended up with an excel sheet like this: Screen_Shot_2014-05-11_at_4.png

Were y-axis are the check-in counters and x-axis is the timeline horizon (cell per 5-minutes)

I will do a VLOOKUP, to change each flight number to it's ID from an other sheet.

But the problem is that i want to AUTO-MERGE all cells with same value, because they represent one flight! and if i shortened the column width i can't see anything.

I want it to be like this: (i've done this manually, and it's VERY time consuming with errors because we have to do it for all days.)

Screen_Shot_2014-05-11_at_46FDQO.png

I googled for days, i only found Visual basic commands i guess? that only merge same rows. and they were poorly made. beside that it didn't work properly. Method to do it automatically?

EXCEL 2013

View 3 Replies View Related

Excel 2013 :: Highlight Cells If Data In 2 Columns Match

May 27, 2014

Please see the attached example. I'm trying to highlight cells only if 2 values in the row match 2 values in another row. If a book title/author combination matches that of another title/author combination in a different row, it would highlight. Some alternate rows will contain different titles by the same author, and some rows will have like titles by different authors...but they should not highlight.

The only situation where highlighting would occur is if the title/author pairing appears in another row.

I'm trying to decide if this would be a conditional formatting/highlighting rule, or if it would be a macro/vbs?

I'm using Excel 2013.

Pairing example.PNG

View 14 Replies View Related

Excel 2013 :: Merge ALL Cells With Same Value In A Sheet (Rows AND Columns)

May 11, 2014

We are doing a graduation project on an international airport, consist of scheduling flights on check-in counters automatically.

Excel sheet like this:

Were y-axis are the check-in counters and x-axis is the timeline horizon (cell per 5-minutes)

I will do a VLOOKUP, to change each flight number to it's ID from an other sheet.

But the problem is that i want to AUTO-MERGE all cells with same value, because they represent one flight! and if i shortened the column width i can't see anything.

I want it to be like this: (i've done this manually, and it's VERY time consuming with errors because we have to do it for all days.) Any method to do it automatically?

EXCEL 2013

View 3 Replies View Related

Excel 2013 :: Mail Merging From Excel Database To Outlook

Apr 15, 2014

Using EXcel 2013, Windows 8

I have an Excel worksheet with one column being e-mail addresses. Other columns are Christian names, etc

Ideally can I create a full Mail merge with Outlook using whatever data I want. But probably just e-mail address and Christian name?

Otherwise be able to send one e-mail to all the e-mail addresses, without a major re-type.

View 2 Replies View Related

Delete Sheets Where Sheet Name Not In Range Of Cells?

Mar 13, 2014

I am looking for some code to scan my sheet names and delete all the sheets that don't have names corresponding to the values within a cell range contained on another sheet in the workbook. For example, if any sheet name, excluding a few reserved sheets, doesn't equal one of the values contained in cells A2:A23 on sheet "XYZ" then delete it.

The best solution I could come up with using my experience was to loop through each sheet and compare the name to each cell in the named range, but if it's possible to somehow declare the named range so that each sheet only has to compare to it that would be ideal;

View 10 Replies View Related







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