> > 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.
