Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Summary then export
I have a table of columns, some titles, others costs.
Think I may need to email the files to someone to better demonstrate it. Is it possible to create a macro button that will create an additional sheet that summarises all the headings in column 1 and sums their respective costs Then another button on the new sheet that will export the data into a template in their correct columns. I would greatly appreciate anyone's help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Summary then export
Make sure the columns have headers and create a Pivot Table? Or do you mean
something else? "Freddy" wrote: I have a table of columns, some titles, others costs. Think I may need to email the files to someone to better demonstrate it. Is it possible to create a macro button that will create an additional sheet that summarises all the headings in column 1 and sums their respective costs Then another button on the new sheet that will export the data into a template in their correct columns. I would greatly appreciate anyone's help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Summary then export
Yeah I mean something that is automated.
I am trying to build a template that will be sent out to various people all year round for population. The macro buttons are to speed things up for them as they seem incapable of doing anything themselves. "PaulW" wrote: Make sure the columns have headers and create a Pivot Table? Or do you mean something else? "Freddy" wrote: I have a table of columns, some titles, others costs. Think I may need to email the files to someone to better demonstrate it. Is it possible to create a macro button that will create an additional sheet that summarises all the headings in column 1 and sums their respective costs Then another button on the new sheet that will export the data into a template in their correct columns. I would greatly appreciate anyone's help |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Summary then export
Off the top of my head, something like this?
sub create_totals() dim i,n,x as integer i = 2 do until sheets("Sheet1").cells(i,1) = "" n = 2 x = 1 do until sheets("Sheet2").cells(n,2) = "" if sheets("Sheet2").cells(n,2) = Sheets("Sheet1").cells(i,1) then x = n n = n + 1 n = n + 1 if x = 1 then x = n sheets("sheet2").cells(x,2) = sheets("Sheet1").cells(i,1) sheets("Sheet2").cells(x,3) = sheets("Sheet2").cells(x,3) + sheets("Sheet1").cells(i,2) i = i + 1 loop end sub That will look down column A of "Sheet1" and add all the names to column B of "Sheet2" and in column C of "Sheet2" add in whatever is in column B of "Sheet1" so Job1 100 Job2 50 Job1 60 Job3 15 Job2 70 will end up as Job1 160 Job2 120 Job3 15 "Freddy" wrote: Yeah I mean something that is automated. I am trying to build a template that will be sent out to various people all year round for population. The macro buttons are to speed things up for them as they seem incapable of doing anything themselves. "PaulW" wrote: Make sure the columns have headers and create a Pivot Table? Or do you mean something else? "Freddy" wrote: I have a table of columns, some titles, others costs. Think I may need to email the files to someone to better demonstrate it. Is it possible to create a macro button that will create an additional sheet that summarises all the headings in column 1 and sums their respective costs Then another button on the new sheet that will export the data into a template in their correct columns. I would greatly appreciate anyone's help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a summary record | Excel Discussion (Misc queries) | |||
Create summary WB | Excel Programming | |||
Create Summary WB | Excel Programming | |||
Userform then export to summary to spreadsheet w. ability to edit | Excel Programming |