Main Area and Open Discussion > General Software Discussion

Anyone familiar with Excel? [Case Closed]

(1/5) > >>

dantheman:
Have an Excel file set up with 14 tabs (12 for each month, 1 for reserve & 1 for monthly results).
Let's say the reserve tab has various $ or Euro amounts to be used on a monthly basis.
So far, i've had to copy/paste from the reserve onto the specified month then clear the reserve items, thus leaving a space of many items that can not be deleted without breaking code.
What i'm hoping to do, is that the empty space created in the reserve tab be automatically filled or moved up with remaining items (monetized items) instead of having to copy/paste again and clear the lines where they were before.

If i can get this part done, i would be a very happy man!   :)

anandcoral:
Very easy.

Just upload your xls file and let us have a go on it.  :)

Regards,

Anand

dantheman:
Sorry for the delay anandcoral.
Forgot to tick off notification to replies! duh!

Anyway, will p.m. Excel file to you as it seems it can't be uploaded here.
Hope it's not too messy for you to work with.  :-[

tomos:
will p.m. Excel file to you as it seems it can't be uploaded here.
-dantheman (November 09, 2017, 08:30 AM)
--- End quote ---

you can zip it, or changing the extension might work. (You cant send files per forum PM)

wraith808:
will p.m. Excel file to you as it seems it can't be uploaded here.
-dantheman (November 09, 2017, 08:30 AM)
--- End quote ---

you can zip it, or changing the extension might work. (You cant send files per forum PM)
-tomos (November 09, 2017, 01:37 PM)
--- End quote ---

Or you can share it with a service like dropbox if you have one...

Navigation

[0] Message Index

[#] Next page