Previous Topic Next Topic

EXCEL FORMULAS

Closed
TMASON97550 Posts 3 Registration date Tuesday 10 January 2017 Status Member Last seen 10 January 2017 - 10 Jan 2017 à 17:12
TMASON97550 Posts 3 Registration date Tuesday 10 January 2017 Status Member Last seen 10 January 2017 - 10 Jan 2017 à 18:12
HI,
I NEED HELP WITH CREATING A FORMULA FOR A SPREAD SHEET. THE WORK BOOK HAS THREE SHEETS (UNITS, COMPONENTS, LOADLIST). IN THE UNITS SHEET SETS OF ITEMS ARE SELECTED, THEN THE COMPONENTS SHEET TALLIES UP ALL ITEMS NEEDED TO COMPLETE THE SETS SELECTED FROM SHEET 1. MY COMPONENTS SHEET HAS 300+ ITEMS ON IT, I WANT ONLY THE ITEMS THAT GET TALLIED TO AUTOMATICALLY PORT OVER TO THE LOADLIST SHEET. THIS IS GOING TO BE USED BY CREWS IN THE FIELD TO SEND IN LISTS FOR HARDWARE, SO I NEED THE WORK BOOK TO DO THIS ACTION ITSELF. THERE ARE 6 COLUMNS (A- PART #, B- DESCRIPTION, C-QUANTITY, REPEAT FOR G, H, I) I WANT ALL THREE CELLS ASSOCIATED TO PORT OVER. CAN ANYONE HELP, THANKS.
Related:

2 responses

Réponse 1 / 2
Blocked Profile
10 Jan 2017 à 17:14
We sure can, if you weren't yelling at us!

We are volunteers. We do not create turn key solutions. Where are you stuck? Post what you have already written, and we can help!
It's kind of fun to do the impossible! -Walter Elias Disney
TMASON97550 Posts 3 Registration date Tuesday 10 January 2017 Status Member Last seen 10 January 2017
10 Jan 2017 à 17:59
I wasn't yelling, just speaking in all CAPS lol. Ok, first how do I link what i have to here. Please forgive me here, when you ask where i'm stuck, well if it has a keyboard, circuits and a screen, I'm stuck. lol I appreciate your volunteer work. I have the first 2 sheets working, unfortunately they are on my work computer, but I have it saved on my home computer, just not as up to date. What i have will still show what i'm doing and what i need help with. As far as my research has got me is i probably need to write a macros formula. help me with linking this and I'll show you, thanks.
Réponse 2 / 2
TMASON97550 Posts 3 Registration date Tuesday 10 January 2017 Status Member Last seen 10 January 2017
10 Jan 2017 à 18:12
Copy of Copy of PA LIST - NEW SYSTEM (61348).xls
Hey i think I figured it out.

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses