Born Again Excel Newbie! Help please with formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1616366%22%20slang%3D%22en-US%22%3EBorn%20Again%20Excel%20Newbie!%20Help%20please%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1616366%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20not%20used%20Excel%20for%20over%2015%20years%2C%20feels%20like%20a%20past%20life%2C%20and%20I%20think%20it%20must%20have%20gone%20through%20many%20many%20versions%20since%20I%20last%20worked%20with%20it.%3C%2FP%3E%3CP%3EI%20now%20own%20a%20gift%20shop%20and%20represent%20lots%20of%20other%20artists.%26nbsp%3B%20I%20have%20a%20spreadsheet%20I%20use%20to%20keep%20track%20of%20daily%20sales.%26nbsp%3B%20I%20then%20manually%20copy%20each%20entry%20row%20over%20to%20the%20artist's%20own%20page%20in%20the%20same%20workbook.%26nbsp%3B%20Is%20there%20a%20way%20to%20do%20this%20with%20a%20formula%3F%26nbsp%3B%20I%20have%20nested%20formula%20in%20the%20worksheet%20already%20but%20cannot%20figure%20this%20one%20out!%3C%2FP%3E%3CP%3EIs%20this%20the%20sort%20of%20question%20that%20is%20allowed%20in%20the%20forum%3F%3C%2FP%3E%3CP%3EI%20am%20utterly%20stuck!%3C%2FP%3E%3CP%3ETake%20care%3C%2FP%3E%3CP%3EKes%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1616366%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1616800%22%20slang%3D%22en-US%22%3ERe%3A%20Born%20Again%20Excel%20Newbie!%20Help%20please%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1616800%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F773390%22%20target%3D%22_blank%22%3E%40OceanGlass%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20answer%20your%20questions%20in%20reverse%20order%3A%3C%2FP%3E%3COL%3E%3CLI%3E%3CU%3E%3CEM%3EIs%20this%20the%20sort%20of%20question%20that%20is%20allowed%20in%20the%20forum%3F%3C%2FEM%3E%3C%2FU%3E%20It's%20absolutely%20the%20place%20to%20ask%20questions%20such%20as%20this.%3C%2FLI%3E%3CLI%3E%3CU%3E%3CEM%3EI%20then%20manually%20copy%20each%20entry%20row%20over%20to%20the%20artist's%20own%20page%20in%20the%20same%20workbook.%20Is%20there%20a%20way%20to%20do%20this%20with%20a%20formula%3F%20I%20have%20nested%20formula%20in%20the%20worksheet%20already%20but%20cannot%20figure%20this%20one%20out!%3C%2FEM%3E%20%3C%2FU%3EThere%20are%20several%20ways%20to%20do%20this.%20A%20question%20for%20you%3A%20what%20version%20of%20Excel%20do%20you%20have%3F%20I'm%20going%20to%20assume%20(since%20your%20working%20with%20artists)%20that%20you're%20on%20a%20Mac.%20My%20version%20of%20Mac%20Excel%2C%20when%20I%20click%20on%20the%20main%20menu%20%22Excel...About%20Microsoft%20Excel%22%20comes%20up%20with%20the%20image%20below%2C%20telling%20me%20I've%20got%20version%2016.40.%20This%20is%20important%20because%20there%20are%20features%20in%20the%20most%20recent%20that%20could%20be%20very%20helpful%20to%20you%20with%20this%20particular%20question%20you've%20asked.%3C%2FLI%3E%3CLI%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1598548932802.png%22%20style%3D%22width%3A%20249px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215109i35D28AF763C7C182%2Fimage-dimensions%2F249x221%3Fv%3D1.0%22%20width%3D%22249%22%20height%3D%22221%22%20title%3D%22mathetes_0-1598548932802.png%22%20alt%3D%22mathetes_0-1598548932802.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CU%3E%3CEM%3EI%20have%20a%20spreadsheet%20I%20use%20to%20keep%20track%20of%20daily%20sales.%3C%2FEM%3E%20%3C%2FU%3EWould%20you%26nbsp%3B%20be%20able%20to%20post%20a%20copy%20of%20that%20spreadsheet%2C%20or%20a%20good%20representative%20sampling%20of%20it%2C%20just%20taking%20care%20first%20to%20remove%20any%20actual%20names%20or%20other%20identifiable%20data.%20Use%20names%20like%20%22Mickey%20Mouse%2C%20Luke%20Skywalker%2C%20Wonder%20Woman...%22%20whatever...%3C%2FLI%3E%3CLI%3E%3CU%3E%3CEM%3EI%20have%20not%20used%20Excel%20for%20over%2015%20years%2C%20feels%20like%20a%20past%20life%2C%20and%20I%20think%20it%20must%20have%20gone%20through%20many%20many%20versions%20since%20I%20last%20worked%20with%20it.%3C%2FEM%3E%20%3C%2FU%3EWelcome%20to%20the%20club.%20I%20retired%2018%20years%20ago%20and%20was%20at%20the%20time%20(in%20the%20eyes%20of%20many%20colleagues%20at%20any%20rate)%20a%20%22power%20user.%22%20But%20oh%2C%20my...even%20though%20I%20stayed%20active%20in%20using%20Excel%20for%20my%20own%20purposes--tracking%20investments%20and%20the%20like--when%20I%20stumbled%20on%20this%20%3CSTRONG%3Etechcommunity%3C%2FSTRONG%3E%20website%20last%20October%20I%20was%20quickly%20blown%20away%20by%20all%20the%20changes%20I'd%20been%20unaware%20of.%3C%2FLI%3E%3C%2FOL%3E%3CP%3EAnyway...bottom%20line...if%20you%20could%20post%20a%20copy%20of%20the%20spreadsheet%20you've%20developed%2C%20after%20rending%20all%20names%20anonymous%2C%20I%20or%20one%20of%20the%20many%20other%20true%20experts%20can%20give%20you%20some%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

I have not used Excel for over 15 years, feels like a past life, and I think it must have gone through many many versions since I last worked with it.

I now own a gift shop and represent lots of other artists.  I have a spreadsheet I use to keep track of daily sales.  I then manually copy each entry row over to the artist's own page in the same workbook.  Is there a way to do this with a formula?  I have nested formula in the worksheet already but cannot figure this one out!

Is this the sort of question that is allowed in the forum?

I am utterly stuck!

Take care

Kes

1 Reply

@OceanGlass 

 

To answer your questions in reverse order:

  1. Is this the sort of question that is allowed in the forum? It's absolutely the place to ask questions such as this.
  2. I then manually copy each entry row over to the artist's own page in the same workbook. Is there a way to do this with a formula? I have nested formula in the worksheet already but cannot figure this one out! There are several ways to do this. A question for you: what version of Excel do you have? I'm going to assume (since your working with artists) that you're on a Mac. My version of Mac Excel, when I click on the main menu "Excel...About Microsoft Excel" comes up with the image below, telling me I've got version 16.40. This is important because there are features in the most recent that could be very helpful to you with this particular question you've asked.
  3. mathetes_0-1598548932802.png
  4. I have a spreadsheet I use to keep track of daily sales. Would you  be able to post a copy of that spreadsheet, or a good representative sampling of it, just taking care first to remove any actual names or other identifiable data. Use names like "Mickey Mouse, Luke Skywalker, Wonder Woman..." whatever...
  5. I have not used Excel for over 15 years, feels like a past life, and I think it must have gone through many many versions since I last worked with it. Welcome to the club. I retired 18 years ago and was at the time (in the eyes of many colleagues at any rate) a "power user." But oh, my...even though I stayed active in using Excel for my own purposes--tracking investments and the like--when I stumbled on this techcommunity website last October I was quickly blown away by all the changes I'd been unaware of.

Anyway...bottom line...if you could post a copy of the spreadsheet you've developed, after rending all names anonymous, I or one of the many other true experts can give you some help.