[Boards: 3 / a / aco / adv / an / asp / b / bant / biz / c / can / cgl / ck / cm / co / cock / d / diy / e / fa / fap / fit / fitlit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mlpol / mo / mtv / mu / n / news / o / out / outsoc / p / po / pol / qa / qst / r / r9k / s / s4s / sci / soc / sp / spa / t / tg / toy / trash / trv / tv / u / v / vg / vint / vip / vp / vr / w / wg / wsg / wsr / x / y ] [Search | Free Show | Home]

Excel Experts I need your help

This is a blue board which means that it's for everybody (Safe For Work content only). If you see any adult content, please report it.

Thread replies: 25
Thread images: 1

File: IMG_2657.png (8KB, 300x300px) Image search: [Google]
IMG_2657.png
8KB, 300x300px
So my grandma needs me to write her a spreadsheet, gonna pay me $100, but this is what I can't figure out.
She does a monthly audit for people who pay dues for her organization. I need it so she can print a report, so basically if she entered a $5.00 and the date they paid, I need excel to read this range and print a separate report that will list all the names and the amount they paid, as well as their address and account type. Then these need to be separated by the date they paid.

Anyone understand this? I know it's hard to explain but basically I need excel to make reports of who paid each month and how much, but I can't get excel to write this info or read it from the list.

Please help thanks
>>
>>61065637
Sounds not hard. I'm sure that who uses excel everyday could do this.
>>
>>61065637
>my grandma
>she will pay me
Holy fuck, you soulless capitalist piece of shit kys.
>>
>>61065984
I know it's possible I just can't seem to get it right, like totaling it all and shit and using if statements to match who paid on the same day isn't hard, getting excel to print the associated data is hard as FUCK. Reminds me a bit of Enums in my java class, half tempted to just make a java program that reads csv's and prints the data directly
>>
>>61066137
Have you ever tried convincing your grandparents not to give you money after they offer it? Must be an orphan with no immediate family
>>
>>61065637
Just use Python
>>
>>61065637
I can't help but this sounds very achievable with VBA. Try uploading an example screenshot and you'll get more responses.
>>
I will do it for $99
>>
>>61066337
I'm a VBA wizard
>>
Manually create the desired output and then go backwards to determine which data you need where and how to fetch it.

Sound like you need conditional formulas to look for entered values and match/index for address and account type fetching.
>>
From what you describe it sounds like you'd be better off with creating a database instead in Access.
>>
>>61065637
>gonna pay me $100

I'll do it for $95. Actually I'll sub it out to a guy in India that will do it for $3, but I'll still charge her $95.
>>
>>61065637
Apache OpenOffice
>>
>>61066454
This
>>
>>61065637
>>61066473

I will do it for 93
>>
>grandma is going to type in name, date, amount
>wants to print out list of name, date, amount

Tell her to press Ctrl+P
paypal me $90 for my consulting fee
>>
Wouldn't you need 2 sheets of an Excel file?
>>
>>61066835
Then you need to make on the second sheet if A(sheet 1):2-A15 equal date then include name
>>
>>61065637
Probably best to write it to a blank sheet and print that sheet. You might be able to force it to hide rows\colums for unpaid accounts, set a print area, but that sounds like too much work.
>>
>>61066891
Then have Excel only print sheet 2
>>
>>61066137
Go fuck yourself communist pig. You will never amount to anything.
>>
>>61065637
>taking money from your grandma

kill
you're'st
Self
>>
>>61065637
>>61066521
I'll do it for 92
>>
>>61067029
this, wtf.
>>
>>61065637
Your explanation of what you need is difficult to follow. Give an example of the data in the format you have, and the format you hope to achieve. Show, don't tell.
Thread posts: 25
Thread images: 1


[Boards: 3 / a / aco / adv / an / asp / b / bant / biz / c / can / cgl / ck / cm / co / cock / d / diy / e / fa / fap / fit / fitlit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mlpol / mo / mtv / mu / n / news / o / out / outsoc / p / po / pol / qa / qst / r / r9k / s / s4s / sci / soc / sp / spa / t / tg / toy / trash / trv / tv / u / v / vg / vint / vip / vp / vr / w / wg / wsg / wsr / x / y] [Search | Top | Home]

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible.
Read more on this topic here - https://archived.moe/talk/thread/1694/


If you need a post removed click on it's [Report] button and follow the instruction.
DMCA Content Takedown via dmca.com
All images are hosted on imgur.com.
If you like this website please support us by donating with Bitcoins at 16mKtbZiwW52BLkibtCr8jUg2KVUMTxVQ5
All trademarks and copyrights on this page are owned by their respective parties.
Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.
This is a 4chan archive - all of the content originated from that site.
This means that RandomArchive shows their content, archived.
If you need information for a Poster - contact them.