Replies

Thank you so very much.. That was exactly what I needed!

Thank you so very much.. That was exactly what I needed!

All of my macros are stored in my personal workbook so if I made a copy of my personal workbook then I would be saving all my Macros!

I have a big smile on my face right now and I am sure I am red, because when I read you email I did a big Homer Simpson- Doh!

All of my macros are stored in my personal workbook so if I made a copy of my personal workbook then I would be saving all my Macros!

I have a big smile on my face right now and I am sure I am red, because when I read you email I did a big Homer Simpson- Doh!

Yeah ~ I guess I should have said multiple Modules instead of Macros…

It occurred to me that what I really am doing is backing up my modules. Is there an easier way to do it than to export them?

Yeah ~ I guess I should have said multiple Modules instead of Macros…

It occurred to me that what I really am doing is backing up my modules. Is there an easier way to do it than to export them?

Thank you so much Steve…

That is EXACTLY what I was looking for.

Thank you so much Steve…

That is EXACTLY what I was looking for.

I gave it a try Steve, but that just put the Header into Column A all the way down.

I have included a very simplistic sample sheet. Since it won’t save with the History, you will have to recreate that, but I have already made some changes, and would like to know if it is possible to somehow have it automatically (Or through a MACRO) put in the Site # on the page…..

I gave it a try Steve, but that just put the Header into Column A all the way down.

I have included a very simplistic sample sheet. Since it won’t save with the History, you will have to recreate that, but I have already made some changes, and would like to know if it is possible to somehow have it automatically (Or through a MACRO) put in the Site # on the page…..

Problem Solved!

Thank you very much and I will keep this for future reference!

Thanks!

Problem Solved!

Thank you very much and I will keep this for future reference!

Thanks!

Sorry I should have been more specific, I forget you guys can’t read my mind!

I want to do the following
B4=R7
Print
B4=R8
Print
B4=R9
Print

I want to do this unit I hit a blank cell in Column R.

Thanks!

Sorry I should have been more specific, I forget you guys can’t read my mind!

I want to do the following
B4=R7
Print
B4=R8
Print
B4=R9
Print

I want to do this unit I hit a blank cell in Column R.

Thanks!

Well, yes I know that ….. I kind of want to go backwards in the process. I want to copy the cells and then paste the sum.

It may not make sense why I would want to do this, and I’d love to show my spreadsheet, but I can’t because it is sales information.