+ Reply to Thread
Results 1 to 46 of 46

Identical data needed on all tabs, want to add a line across all tabs when added in tab1

  1. #1
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Identical data needed on all tabs, want to add a line across all tabs when added in tab1

    Hi All,

    So I have a Excel spread sheet with the same data in the first say 5 columns, things like first name, surname, reference number, package number, on every tab.

    Each tab deals with separate tasks.

    Tab 1 is the master data as such and pulls various info from the other tabs.

    The issue I have is that when a new line is added in tab 1 (addition of a new person, or a person is allocated a new package) I need that to be reflected across all tabs in the same row as it appears in the lead tab (Tab.1)

    Currently the sheet is populated using the INDIRECT formula to create a mirror image of the first tab on the subsequent tabs - problem arises when a new row is added in the middle of the data set, rather than at the start or end. The data all falls out of sync.

    Ultimately my opinion is that the user(s) of this sheet are using excel where they should be using a database tool, but the user(s) are adamant that they want to remain using excel to record and maintain this data......

    Can anyone suggest anything?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    You could use this
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    instead of INDIRECT.

    You can use that for the "static" master data and then add whatever information you need to the Task sheets.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Ok, so I see how that works differently to the INDIRECT formula.

    With INDIRECT they have been able to select the exact column data they wanted to repeat from the master data in the subsequent tabs.

    To pad this out a bit, in the subsequent tabs one is a list of invoices recorded against that person/package combination.

    So imagining the first five columns are plucked from the master data the users then are manually adding invoice details, i.e. invoice numbers and values to the respective rows.

    This was resulting in the issue then when a new person or package was added to the Master data and the INDIRECT formula does its thing the automated and manual data ends up on different rows.

    Any ideas how this could be resolved?

  4. #4
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Thanks for the formula, but I still have an issue

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Thanks for the formula, but I still have an issue
    I can imagine. Your design is a rod for your own back. Typically, you wouldn't want, or need to repeat rows/columns/cells. It is more usual to have, say, a client (or supplier) master list (worksheet) with a key field and separate transaction worksheets for invoices, payments, stock, whatever. You then enter the transactions in the transaction sheets. You can use the Master List(s) in Data Validation to ensure consistency and use VLOOKUP or INDEX/MATCH to return the detail relating to that Master entry ... though, more often than not, you probably only need one element.

    I'll see if anyone else has any ideas but, for me, I'm out.

    Regards, TMS

  6. #6
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Hi.

    I'd be willing to have a go at solving this, though unfortunately not unless an actual workbook was provided containing expected results for different scenarios.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  7. #7
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Thanks for your input

  8. #8
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Sample Sheet.xlsxOk here it is

  9. #9
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Well I'm not going to hack in without a password!!

    Regards

  10. #10
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Try again, other has a password
    Attached Files Attached Files

  11. #11
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    just for info, I have blanked some data out, but hopefully it still represents the issue here.

  12. #12
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Thanks. And which are the expected results in here?

    Regards

  13. #13
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Master data is the updated/maintained page.

    As you will see on other tabs INDIRECT is being used to bring in data from the 'Master' tab.

    Users are then adding data to the tabs manually in line with the respective reference number etc.

    Issue that arises is when a new person is added or a new package added to the Master sheet the data shifts per the formula (formula doing what it should) but the manually added data stays static and ends up on an incorrect line?

    Does that make sense?

    Thanks

  14. #14
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    I'm afraid not, no. Apologies.

    Perhaps you could give a concrete example involving actual cell references of what could go wrong, and what the result you would instead like to see is.

    Regards

  15. #15
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Sorry, do you mean my explanation doesn't make sense to you?

    Or you don't know a resolution?

    Thanks

  16. #16
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    I mean that I'm not quite sure of the issue you're describing and would prefer, if possible, to see a case where this issue has occurred, what negative consequences that issue has had on your workbook, and what instead should have occurred.

    Regards

  17. #17
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Hi
    If you want the row to be inserted in all tabs you can group or select all of them before adding a new data in master sheet and then insert a row in master sheet.
    So as all tabs are selected the row would be inserted in all the tabs
    If you have many tabs then you can use a macro to select all of them
    Please Login or Register  to view this content.
    Hope that helps!!
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  18. #18
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Master data = the maintained/updated data.

    Finance Tab = is generally OK and working. INDIRECT is pulling through the columns required and the rest of the columns (not populated by INDIRECT) are formula driven so calculate OK.

    Invoice List = Has an issue, Col A-C are populated by INDIRECT, but Col.D onwards are manually populated by a user. The issue arises when a new line is entered into the 'Master Data' tab as INDIRECT works and brings through the new line as it appears in the 'Master Data', thus extending Col A-C, but moving out of line the manually added data in Col D onwards.

    Case Mgmt Tab = Same issue as 'Invoice List'

    The issues have knock on affects on the other tabs, eg. Finance tab becomes inaccurate as SUMIFS is used and if the ref number has moved down, but the manually entered invoice detail added to 'Invoice List' changes the SUMIFS delivers a different answer.

    I'm looking for a solution to this that looks similar to what is presented here, maybe there is a way of anchoring the manual entries to the lines they are posted too, or an alternative formula to INDIRECT to bring the info required from the 'Master Data' to the subsequent tabs???

    Hope this better explains.

    Thanks

  19. #19
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Thanks.

    Quote Originally Posted by seash View Post
    The issue arises when a new line is entered into the 'Master Data' tab as INDIRECT works and brings through the new line as it appears in the 'Master Data', thus extending Col A-C, but moving out of line the manually added data in Col D onwards.
    This is the part I don't understand, and for which I was hoping you could give a specific example/instruction (e.g. "Go into the Master sheet and do such-and-such. Now go back into the Invoice list tab. Do you see what has happened? It should have been like this...").

    Perhaps someone else with a bit more insight will get there before I eventually work out what you mean!

    Regards

  20. #20
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Right, so if I put it like this.

    Go to Master Data, add a new person part way up the range/or add a new package to an individual.

    Now go to the invoice tab, INDIRECT has brought through the new line and as a result moves down col A-C, but D onwards have remained where they were prior to the addition of the new line in the Master Data.

    Do that make it any clearer?

    Thanks

  21. #21
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Im not saying that the sheet is doing something it shouldn't, more of a this is what we want it to do, what formula do I need to make it do that?

  22. #22
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Hello
    Did you try my solution??
    @xor lx
    Check attached this is what he is having trouble with...
    Attached Files Attached Files

  23. #23
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    I want to be able to add a populated line across all tabs.

    I'm aware how to use Tab grouping to make an amend occur across all tabs.

    Have you read my full explanation of this issue/resolve I'm looking for?

    Thanks

  24. #24
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    You may be onto something with the group 'add row' command.

    Is there a way to select certain tabs 'named' ones, and be able to add a button that can be pressed to make that selection prior to a user using 'insert rows'? Or even a macro that will encompass both functions? So a user would select the row where they want to insert a row then hit the button which would in turn, select the pre-defined tabs and insert a row at that same position in the tab, but in group so that insert row would appear across all macro selected tabs?

    Reason I ask is I need to resolve to be useable by lesser excel skilled users, and this needs to be as simple as possible for them to use.........

    Thanks

  25. #25
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Yes I read the whole explanation
    The problem you are facing is that the manually entered data is not shifting with the shift by indirect formula..
    So if you would just insert a row with all tabs selected then the manually entered data would also shift down?
    Would it help??
    Really Sorry if this won't help!!

  26. #26
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    I think it may help yes, did you see my last post

  27. #27
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Quote Originally Posted by seash View Post
    You may be onto something with the group 'add row' command.

    Is there a way to select certain tabs 'named' ones, and be able to add a button that can be pressed to make that selection prior to a user using 'insert rows'? Or even a macro that will encompass both functions? So a user would select the row where they want to insert a row then hit the button which would in turn, select the pre-defined tabs and insert a row at that same position in the tab, but in group so that insert row would appear across all macro selected tabs?

    Reason I ask is I need to resolve to be useable by lesser excel skilled users, and this needs to be as simple as possible for them to use.........

    Thanks
    Yes that's easy
    Try this macro
    Please Login or Register  to view this content.

  28. #28
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Forgot to mention
    This macro would select all sheets between the starttab and the endtab so you put start tab as master and the end tab as till whatever sheet you want the changes to occur or you can try this macro to select specific sheets
    Please Login or Register  to view this content.

  29. #29
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    I have an issue, not sure if Im doing this correctly.
    Entered the macro like this:
    Sub GroupTabs()
    Dim sh As Worksheet
    Worksheets(Array("Master", "Finance List", "Invoice List", "Case Management List")).Select
    Sheets(i).Select Replace:=False
    End Sub
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    Sheets("Master").Select
    End Sub

    The top part worked fine until I added the lower bit in.

    Sorry VBA/Macro knowledge limited but getting better

    Please Help

  30. #30
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Try this
    Please Login or Register  to view this content.

  31. #31
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    That's excellent, however I would like it to do a little more.

    In the newly inserted row is there a way to copy down the formula form the row above so that the manually inserted data in the Master feeds through all the other tabs.

    Does that make sense?

    Thanks

  32. #32
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Hello
    Try this
    Please Login or Register  to view this content.
    I have done for sheet Finance list
    So just type the first row which contains formula to be copied like A4:C4 and it would be pasted form A5:C5 to the end of the data...similarly do for others

  33. #33
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Sub GroupTabs()
    Worksheets(Array("Master", "Finance List", "Invoice List", "Case Management List")).Select
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

    Sheets("Master").Select
    Worksheets("Finance List").Range("A4:C4").Formula = Worksheets("Finance List").Range("A5:C5", Selection.End(xlDown)).Formula

    Sheets("Master").Select

    End Sub


    Entered as above, selected the 2nd row down in the master list and run the macro, straight away getting an error message stating runtime error '1004'.

    Rows are added across all other tabs - OK

    No formulas being dragged down though??

    Any ideas?
    Last edited by seash; 03-12-2015 at 08:03 AM.

  34. #34
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Really sorry my mistake
    This one would work for sure
    Please Login or Register  to view this content.
    Here you can see resize(,3) 3 is the number of columns present like A to C is 3 columns
    Hope that helps

  35. #35
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Hi there,
    I have changed to this but still no formulas are pulling down in the finance tab?

    Macro entered as below:

    Sub GroupTabs()
    Worksheets(Array("Master", "Finance List", "Invoice List", "Case Management List")).Select
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    Sheets("Finance List").Range("A4").End(xlDown).Offset(1).Resize(, 3).Formula = Sheets("Finance List").Range("A4:C4").Formula
    Sheets("Master").Select
    End Sub

  36. #36
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Hello
    Actually you may have many empty rows in finance sheet as we were trying macros again and again
    But practically we would insert only one blank row at a time...so only that would be automatically be filled with the formula...i.e. the first blank row after A4:C4 would be filled with formulas...

  37. #37
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    So what do I need to do, will this macro pull down the same formula as is shown directly above it?

    Or will it only allow a new row to be added and populated with the formula if its the 2nd row of data, then the 3rd, etc etc?

  38. #38
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    You need to do nothing... just put this macro after making the formula copy function for all sheets to your original file which doesn't have any blank rows....
    So whenever you select any row on the master sheet and press the button for the macro this macro would automatically insert a row in all the sheets mentioned in the macro and the formula would be copied to the first empty row which is found starting from cell A4...
    So each time you press it a new row would be inserted in all sheets and formula would be copied again to the first blank row found after cell A4...that empty row would be obviously the row which is just inserted by the macro ..

  39. #39
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    it works a treat, so to extend this to work across more than just the Finance List, I need to repeat the line, and ensure the number of rows that are needed to be replicated on these tabs is amended.

    One thing, do all the columns that I want to be populated by this formula need to be together, i.e. if I want 5 columns of data to be copied down do they need to display in A-E in my tab?

    Thanks

  40. #40
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Sub GroupTabs()
    Worksheets(Array("Master", "Finance List", "Invoice List", "Case Management List")).Select
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    Sheets("Finance List").Range("A4").End(xlDown).Offset(1).Resize(, 8).Formula = Sheets("Finance List").Range("A4:H4").Formula
    Sheets("Master").Select
    Sheets("Invoice List").Range("A4").End(xlDown).Offset(1).Resize(, 3).Formula = Sheets("Invoice List").Range("A4:C4").Formula
    Sheets("Master").Select
    Sheets("Case Management List").Range("A4").End(xlDown).Offset(1).Resize(, 11).Formula = Sheets("Case Management List").Range("A4:K4").Formula
    Sheets("Master").Select
    End Sub

  41. #41
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Not necessary.
    You can have your range anywhere
    Please Login or Register  to view this content.
    Sample--(to copy B4:E4)
    Please Login or Register  to view this content.
    Also no need to replicate Sheets("Master").Select again and again...just put it once at the end to come back to the master sheet...
    Please Login or Register  to view this content.

  42. #42
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Ok, Thanks

    Tried your code, but no formulas pulling down again?

    What am I doing wrong?

    Sorry my code skills need improvement.

    Thanks

  43. #43
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Ok Check attached
    This should work..
    Just select any row and press the go button
    Tell me if this works...
    Attached Files Attached Files

  44. #44
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Still no formulas pulling down in Finance, Invoice, Case Management

  45. #45
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Hi
    Are you kidding me??
    I tested it it is working perfectly
    I selected row 10 on sheet Master and pressed go button this is the result i got...
    Try again it must work...Or maybe there is a demon in your PC..hahahaaa...
    Reply me after trying again!!
    Attached Files Attached Files

  46. #46
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Re: Identical data needed on all tabs, want to add a line across all tabs when added in ta

    Working great, thanks

    Must have been a glitch before.

    Many thanks for your help with this.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro help: Separating data into tabs and creating a table of content of those tabs
    By AntiPivotTable in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2015, 11:57 AM
  2. Tab1 by location, needs to populate tabs by vendor
    By NSpeidell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-03-2012, 07:27 PM
  3. Excel 2007 : Macro needed to transfer data between tabs
    By Turfguy1854 in forum Excel General
    Replies: 2
    Last Post: 06-14-2012, 03:56 AM
  4. Copy pie chart into new tabs, and show the results from data on those tabs
    By Sydney Lee in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-23-2012, 07:50 PM
  5. Replies: 3
    Last Post: 04-16-2010, 10:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1