- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Need Excel Help - Formatting From A Data Sheet
Posted on 3/1/16 at 10:55 am
Posted on 3/1/16 at 10:55 am
I have a PDF that maps everything very particularly and the new version of our software cannot accommodate it.
My boss is very particular and wants the data the same way as we were able to do it before.
Basically, I have all of the raw data and need to build a macro to 'recreate' the PDF format.
I suspect it's going to be a lot of "If these values are the same, then total and sum, and put that 'here'... if they're NOT the same, then move to the next cell and start over... total and sum, and put THAT value HERE" kind of thing...
If anyone wouldn't mind, can you email me and we can coordinate some support?
TIA
<-- @gmail.com
My boss is very particular and wants the data the same way as we were able to do it before.
Basically, I have all of the raw data and need to build a macro to 'recreate' the PDF format.
I suspect it's going to be a lot of "If these values are the same, then total and sum, and put that 'here'... if they're NOT the same, then move to the next cell and start over... total and sum, and put THAT value HERE" kind of thing...
If anyone wouldn't mind, can you email me and we can coordinate some support?
TIA
<-- @gmail.com
2
Posted on 3/1/16 at 1:27 pm to yankeeundercover
Pretty vague description here...I've done a number of macros and things, so can offer to help, but I'm not sure what I'm getting into.
Posted on 3/1/16 at 2:49 pm to yankeeundercover
Is this a one time deal or going to be on a regular basis?
If one time, just do it with "If" formulas and be done. You will spend more time building the macro.
If regular, it will still be worth your time to do it once with formulas and then use those as a basis for your macro. You will need to write them either way.
If one time, just do it with "If" formulas and be done. You will spend more time building the macro.
If regular, it will still be worth your time to do it once with formulas and then use those as a basis for your macro. You will need to write them either way.
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News