Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
do you want the row to change when you copy the formula or not?
are you here?
i wasn't sure from your initial question
That would be ideal
so which is it
is the sheet name
and you want to refer to cell V2? regardless of where the formula is
or do you just want the V column?
I have data in another sheet organized by column (V2,V3,V4) that I would like to copy into a row on another sheet
one minute....let me try to explain
I have 97 sheets of data
I'm trying to compile the column V from all of those 97 sheets into a summary table
Column V can have up to 5 rows (V2,V3,V4,V5)
And I'm trying to copy them into columns in the summary table
So I'm trying to get row 2 in my summary to do the following:
Row #1 ='#1'!$V2 (next cell) = '#1'!$V3 (next cell) '#1'!$V4
Row #2 ='#2'!$V2 (next cell) = '#2'!$V3 (next cell) '#2'!$V4
I've tried writing out each formula across the top for all 5 V cell references with $V$2, $V$3, etc and just filling down but the autocomplete messes it all up
I land up with column progression to W in some rows if I fill sideways
And the worksheet reference stays constant at '#1' if I fill down
It doesn't make sense....wondering if this data set being built on an earlier version of MS office is causing problems because some cells fill properly and others do not
you may need a macro to do this
I've never done one
i could do one for you
will the cells be the same in each sheet
so it will always be V2
the easiest way to do this would be if you could send me your worksheet
do you need instructions for that
do you have a paperclip icon at the top of your chat window
where you type text?
but works on xls files
if you can get me the file it shouldn't take too long to do as I have written similar code for others
did that work?
looks like it
so which sheet is the output supposed to go on?
Trying to take the values in worksheets #1 through 94 in column V and place them in columns G-K in the Total WSL charts worksheet
also want to transfer column W to columns L-P
ok i got the first part
colimn W from the # XXXXX
did you see that
i can do the first part no problem
but not sure what you mean colum @
ok I may not have sent the most recent version as I just added column W today
what version of excel are you using by the way?
wanna make sure macros will work
if you send me the new file
i should be able to do what you need
column W can be inserted really anywhere in the sheet...for I have different progression data in columns L-P in the summary sheet...column W can be inserted before or after
so V should go in G-K
W go in L-P
does that sound good to you
let's put W in Q-U
give me a few minutes
to do it
just a quick fyi...some additional sheets (i.e. #68) are now present in the workbook but not added to the Total WSL Charts sheet. I've never worked with Macros but hoping they autopopulate if I insert rows for those sheets after it is written?
it will autopopulate for however many sheets you have a # XXXXX
it doesn't care if you have 1 sheet
or 3 million sheets
done:Donwload the file from this linkhttp://ge.tt/1Easw001/v/0?cSince this is a macro, you by default will get a security warning with a yellow barit will say something like "Macros have been disabled".when you first start excelyou will need to click enable, or it wont workyou will notice a populate button that I added to the right of all the data.click that to update the datalet me know if you have any questions, problems or concerns.PLEASE REMEMBER TO RATE MY SERVICE SO I GET PAID FOR MY TIMEYOU DO SO WITH THE SMILEYS DIRECTLY BENEATH THIS CHATthanks
sweet let me try it quick
the link isn't working
u let me double check it
how is it not working?
what happens when you click it
ok now it worked...the one above chrome said it could not find
gotto love chrome
looks great...only thing is I just realized some of the sheets have a 6th row in column V
can I just insert another column and drag/fill in the summary sheet?
well we can certainly modify for that, we just change the columns that the data goes too
so it would go from G to L then
instead of G to K
and R to V
do I need to step in to the macro to do so?
ill fix it in about 30 seconds
do we need to add an extra value for W as well
better question would have been....do you need to step into the macro?
I actually think I see it now in the code but it's probably safer if I stay out of it
here is the file with the changes
when you do rate, I would appreciate a bonus, for the extra work
you're the man....thank you very much
PLEASE RATE WITH THE SMILEYS BELOW THIS CHAT
lmao....u saved a life today. haha