Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 158819 times)

Offline Zevi16

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Mar 2015
  • Posts: 2091
  • Total likes: 65
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #540 on: February 17, 2016, 12:17:54 AM »
what version of office do you have now?

can you upload the .ods to google sheets and then download as excel?
Sorry for not updating. I went on the old laptop and saved as .xls file.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #541 on: February 19, 2016, 09:26:22 AM »
Help!

Anyway to recover data, formatting, calcs, tickmarks etc from an excel book that was saved as csv??

I do not have this auto saved anywhere. - I believe that the work was done in a csv workbook, - but it seems that after I save, close it and reopen everything is DEAD.
 :'(

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12649
  • Total likes: 7333
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #542 on: February 19, 2016, 09:43:46 AM »
Help!

Anyway to recover data, formatting, calcs, tickmarks etc from an excel book that was saved as csv??

I do not have this auto saved anywhere. - I believe that the work was done in a csv workbook, - but it seems that after I save, close it and reopen everything is DEAD.
 :'(
oy vey-good luck with that. Did it a couple of times. I think I once found a temporaray file for what I did and was able to copy a lot of what I did from there but not all. I think that itself was very YMMV
Feelings don't care about your facts

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #543 on: February 19, 2016, 10:01:56 AM »
oy vey-good luck with that. Did it a couple of times. I think I once found a temporaray file for what I did and was able to copy a lot of what I did from there but not all. I think that itself was very YMMV
Yeah, I think its over. Oh well.

But I think i remember that this happened to me once, and when saving the csv as xls it came back! Not happening now though. 

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12649
  • Total likes: 7333
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Problem
« Reply #544 on: February 19, 2016, 10:17:50 AM »
Maybe it was here?
C:\Users\%username%\AppData\Roaming\Microsoft\Excel\
Feelings don't care about your facts

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #545 on: February 19, 2016, 10:30:47 AM »
Maybe it was here?
C:\Users\%username%\AppData\Roaming\Microsoft\Excel\
Hey! it is there!
 

I thought I looked in the auto save folder before but I guess I had something off or it reappeared? Anyway, its there  :D

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2655
  • Total likes: 51
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Problem
« Reply #546 on: February 19, 2016, 12:53:15 PM »
Nice!
I know the feeling (especially on a short Friday).

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #547 on: March 02, 2016, 03:56:42 PM »
Is there a simple formula for cell A1 to equal cell A1 on the previous sheet (tab)?

Offline MarkS

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2009
  • Posts: 3741
  • Total likes: 27
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Excel Problem
« Reply #548 on: March 02, 2016, 04:01:21 PM »
Is there a simple formula for cell A1 to equal cell A1 on the previous sheet (tab)?
Umm, =Sheet1!A1

Grouping is also a great way to setup several tabs to have similar headers etc

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #549 on: March 02, 2016, 04:22:47 PM »
Umm, =Sheet1!A1

Grouping is also a great way to setup several tabs to have similar headers etc
I mean that each sheet should have the one before it. 25 tabs.
So I can input it once with all sheets selected or something..

Offline dealfinder85

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2013
  • Posts: 3752
  • Total likes: 8
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Problem
« Reply #550 on: March 02, 2016, 04:23:35 PM »
I mean that each sheet should have the one before it. 25 tabs.
So I can input it once with all sheets selected or something..
highlight all the tabs and enter that formula that MarkS said into A1 on the first (second) tab?

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12104
  • Total likes: 2156
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #551 on: March 02, 2016, 04:29:58 PM »
highlight all the tabs and enter that formula that MarkS said into A1 on the first (second) tab?
+1
I mean that each sheet should have the one before it. 25 tabs.
So I can input it once with all sheets selected or something..
They can all reference the first tab and it will lead to the same results
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #552 on: March 02, 2016, 04:33:56 PM »
I don't want the first tab!
Want the PREVIOUS tab

Offline dealfinder85

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Feb 2013
  • Posts: 3752
  • Total likes: 8
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Problem
« Reply #553 on: March 02, 2016, 04:36:33 PM »
I don't want the first tab!
Want the PREVIOUS tab
if each tab's A1 equals the A1 on the previous tab, arent they all the same?

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3307
  • Total likes: 517
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Problem
« Reply #554 on: March 02, 2016, 04:41:10 PM »
I don't want the first tab!
Want the PREVIOUS tab
But if you're making a chain, one tab has to be the first tab in the chain, even if it's not the first on the screen.

Are you saying you want to be able to change the value in any of the sheets, and have it applied to all the sheets? Maybe write a Worksheet_Change macro that you can copy into all the sheets?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #555 on: March 02, 2016, 04:44:56 PM »
But if you're making a chain, one tab has to be the first tab in the chain, even if it's not the first on the screen.

Are you saying you want to be able to change the value in any of the sheets, and have it applied to all the sheets? Maybe write a Worksheet_Change macro that you can copy into all the sheets?
Yes every sheet has changed values.

Thought it might be possible w a formula.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #556 on: March 02, 2016, 04:46:09 PM »
if each tab's A1 equals the A1 on the previous tab, arent they all the same?
It's more like every sheet z30 should equal the previous sheet x20

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3307
  • Total likes: 517
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Problem
« Reply #557 on: March 02, 2016, 04:56:30 PM »
It's more like every sheet z30 should equal the previous sheet x20
Except the one on the sheet you're entering it. That one obviously has to be filled with a value, while the others would be a formula. But that doesn't hold if you want this to be true on any sheet.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12104
  • Total likes: 2156
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Problem
« Reply #558 on: March 02, 2016, 05:08:39 PM »
It's hard to know for sure without understanding your use case, but I'm wondering if you might do better in an Access Database.
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #559 on: March 02, 2016, 05:42:44 PM »
It's hard to know for sure without understanding your use case, but I'm wondering if you might do better in an Access Database.
Nah, just did it manualy-  took 5 min