hi guys,
i my file, in check x in column B, in column A is allocated a unique number. The rest of columns are copied in Master. i want if i modify something in a raw, updating in Master.
hi guys,
i my file, in check x in column B, in column A is allocated a unique number. The rest of columns are copied in Master. i want if i modify something in a raw, updating in Master.
Why not just something like...
=Sheet1!A3
Or, is your sample file too simplified?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
my file is simplified, ii possible to have 1000 raws in every sheet
OK, then maybe you need to show a more representative sample of what you are working with, along with what you expect?
i attached my file
That helps a lot, thanks.
Now, how do we know which data comes from which sheet?
i didn't think about that... maybe if in column B will be name of the sheet
in column D, sorry
If thats the case, then we could probably use INDIRECT, instead of VBA?
if is working, is ok
can to give me an example, please?
OK, can you update your file to show what it would look like with the sheet names?
(It's late here, I need to go to sleep soon, but Im sure another member will pick up where I left off)
i attached the new file
some help, please?
Apologies for the delay.
Try this in A3, copied down and across as needed...
=INDEX(INDIRECT($D3&"!A3:AG27"),COUNTIF($D$3:D3,D3),COLUMNS($A:A))
sorry, but doesn't working, can to put in my file?
My formula was a bit off....
=INDEX(INDIRECT($D3&"!A3:AG27"),COUNTIF($D$3:$D3,$D3),COLUMNS($A:A))
another optio, pleasE?
Why? What was wrong with the updated formula I gave you?
It work just fine in your sample WB
how can to do that with vba?
is possible to make this with vba?
how can to update all data in master if in another sheet something is changed?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks