Excel Help

Smitho3

Smitho3

Smitho3

Soldato
Joined
18 Oct 2002
Posts
2,837
Location
Cardiff
Hi Guys, I dont normally ask for help for things like this but im completely out of my depth. I am pretty good with excel formulae but require help developing a button using what i would asume is macro.

This is quite a big ask so if your bored and have some spare time please add me to MSN so i can explain.

Regards

Lee

[email protected]
 
trescodrucey said:
post the question! we can all help!
Click to expand...
Pretty much a macro to copy some data from 3 cells to another 3 cells. :) Not sure what Smitho3's problem is, perhaps how to get the toolbar to add buttons to show in Excel 2007?

That and something else he wants that I'm not sure what he actually wants done. :p
 
Hi guys, Thanks to MarcLister for all his help today. The solution has not quite been reached as yet so if anyone with VBA experience could help it would be appreciated.
Below is a snippet of our MSN Convo from earlier:

Marc says:
s l o w l y
Smitho3 says:
Basically this is going to be an excel document that calculates a fundraisers contribution, their commission, the charities share and their hourly rate.
Smitho3 says:
At the end of each 4 week period I want to be able to transfer the running total that’s held in the red cells at the bottom of the 4 week display into the cells in the table provided to the right
Smitho3 says:
Then I need to clear all the data on the sheet and start a new 4 week period
Smitho3 says:
The button needs to do 2 things, transfer the relevant data held in the red fields over to the table on the right, giving the user the option to select which period to add it to.
Smitho3 says:
Once done it needs to clear the data held in the fields so you can start a new 4 week period
Smitho3 says:
Does that make sense?

If anyone thinks they can perform this then please let me know. I have absolutely no experience in anything other than simple excel formulae.
 
Not strictly answering your question, but I thought I'd throw it out there anyway. Is there any need to clear the data, and transferring it around? What about just retaining all the data, keeping on going and going, then using (say) a pivot table to summarise the data by month?

That also gives you the benefit of being able to see where the historical data comes from.
 
Cobertizo said:
Not strictly answering your question, but I thought I'd throw it out there anyway. Is there any need to clear the data, and transferring it around? What about just retaining all the data, keeping on going and going, then using (say) a pivot table to summarise the data by month?

That also gives you the benefit of being able to see where the historical data comes from.
Click to expand...

Thats sounds good, very good. Its not something i would be able to do though.
 
You must log in or register to reply here.
Back
Top Bottom