1.carrying entire row to another sheet using vlookup
I would like to use a vlookup function but instead of bringing back one
cell (for example 3rd cell to the right of the value) I would like to
bring back an entire column. How do I do that?
2.setting a formula in cell on a totals sheet using VB
I have a Totals sheet with several worksheets that represent projects. The
number of worksheets(projects) will be added or deleted depending on project
What I'm trying to do is have a Macro to run that will count the number of
worksheets (since the number is not constant) and force the formula -
+ 'sheetName" !B2 + 'sheetName' !B2 - into cell B2 on the Totals sheet.
Can anyone help
3.Carrying formulas from one sheet to the next within the same file
I have 52 tabs set up, one for each week of the year. I enter data in the
top of my grid on one sheet and I want it to add it to the cumulative total
below. Each week I want to copy and paste the grid with formulas to the next
week (worksheet) but it is not carrying over the formulas. I have the name
of the referenced sheet in quotes in the formula. How do I overcome this so
I do not have to plug in the formulas every week? Thanks in advance.
4.carrying over a column formula from one sheet to another copie
Thanks again Pete, BTW, I checked out the cpearson.com link and found it
very helpful too. Thanks for that tip! Carl
> Assume you only have one sheet - Sheet1 - and that you are using
> columns A, B and C starting in row 2, allowing a row for headings. You
> can copy the sheet into the same workbook by CTRL-drag, i.e. hold the
> CTRL key down and drag the tab of Sheet1. Rename this second sheet as
> Sheet2, and in A2 enter this formula:
> Copy this formula down for as many items as you have in Sheet1. You
> might like to clear all the data from column B of this sheet.
> Now, copy Sheet2 using CTRL-drag and rename it to Sheet3. Highlight
> column A of Sheet3 and press CTRL-H (same as Edit | Replace) and enter
> Find What: Sheet1
> Replace With: Sheet2
> Click Replace All.
> You can repeat this procedure until you have enough sheets.
> Hope this helps.
> Carl wrote:
> > I have a worksheet that has three columns all part of a formula. Very
> > simple, the first column is the beginning subtotal, the second is any
> > additional numbers, the last column is the total of the two previous columns.
> > I want to make copies of the master sheet and carry over the total from one
> > sheet to the next copied sheet, however I need the numbers in the Total
> > column to end up in the Subtotal column of the copied sheet, and so on with
> > multiple copies.
> > Can this be done?
> > Thank you for your valued suggestions! Carl
5.carrying over a column formula from one sheet to another copied sh
I have a worksheet that has three columns all part of a formula. Very
simple, the first column is the beginning subtotal, the second is any
additional numbers, the last column is the total of the two previous columns.
I want to make copies of the master sheet and carry over the total from one
sheet to the next copied sheet, however I need the numbers in the Total
column to end up in the Subtotal column of the copied sheet, and so on with
Can this be done?
Thank you for your valued suggestions! Carl
6. Excel formula carrying forward in protected sheet
7. Carry data from sheet to sheet automatically
8. carry down total