Please send me a sample file with a little explanation there
Pada 11/09/2013 20:10, georgebeegl...@gmail.com menulis:
Hi De Premor,
Thanks so much for the accurate information yesterday. We are
currently using that for one of our workbooks.
Yesterday, you nailed putting the value into the TOTALS worksheet in
A1 and then each time the values were cleared and the macro was run
again it replaced that value........which is exactly what we needed
and using.
Kind of the same situation with the workbook you provided yesterday
but instead of being placed in A1, we would like it placed in B1 and
then not over-ride the value but use the next cell in that column.
The problem is that Column A (in the Totals worksheet) has labels
already :
COLUMN A
DENVER
BOSTON
HOUSTON
SEATTLE
When we run the macro to transfer the totals from worksheet1 to the
TOTALS worksheet we would like it placed in B1 which would be the
corresponding value for Denver. But it places the value in B5 which is
a blank row.
Then the next time we tally up the values on worksheet1 we would like
the value to be places in B2 which would be the corresponding value
for Boston.
If you still need an example I can provide one.....please let me know.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners
and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
