Adding data to proceding spreadsheets

March 12, 2018 at 17:24:47
Specs: Windows 10
I have a workbook with multiple spreadsheets to management project flows.
Each subsequent sheet (different aircraft) has the same columns:
A1: Date
B1: Hours
C1: Landings
D1: HS1
etc. all the way to N1.

I want the first spreadsheet to input the data for each of the different proceeding sheets. I want to input hours and landings conducted in the last 24 hours on each of the 7 aircraft. The data needs to add a new row with the date on the left, hours and landings added to the 2nd and 3rd column and hours and landings reduced in all subsequent columns.
HELP!?!?!


See More: Adding data to proceding spreadsheets

Report •

#1
March 12, 2018 at 20:21:37
You said: "I want the first spreadsheet to input the data for each of the different proceeding sheets."

By "proceeding" do you mean "preceding"? Preceding means "comes before". How can the first spreadsheet input data to sheets that come before it? Nothing comes before the first sheet.

You said: "reduced in all subsequent columns"

What do you mean by "reduced"?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

#2
March 14, 2018 at 14:20:18
You said: "I want the first spreadsheet to input the data for each of the different proceeding sheets."
By "proceeding" do you mean "preceding"? Preceding means "comes before". How can the first spreadsheet input data to sheets that come before it? Nothing comes before the first sheet.

-The first spreadsheet will be the input sheet. I want to input the hours and landings for each aircraft on a single sheet in order to alleviate having to go through each sheet to add the data manually. The proceeding sheets are the individual sheets for each aircraft. I want to the first sheet to populate the following sheets according to aircraft number.


You said: "reduced in all subsequent columns"

What do you mean by "reduced"?
Column A: Date
Column B: Total Hours (increasing hours)
Column C: Total Landings (increasing landings)
Column D: Date Check HS1
Column E: Hour Check HS2 (decreasing hours to 0)
Column F: Date Check A1
Column G: Hour Check A2 (decreasing hours to 0)
Column H: Landing Check A3 (decreasing landings to 0)
Column I: Date Check B1
Column J: Hour Check B2 (decreasing hours to 0)
Column K: Landing Check B3 (decreasing landings to 0)
Column L: Date Check C1
Column M: Hour Check C2 (decreasing hours to 0)
Column N: Landing Check C3 (decreasing landings to 0)

Not sure this this manner of explanation helps or not. please advise.



Report •

#3
March 14, 2018 at 18:28:24
OK, I'm going to assume that we have some sort of language issue here. In American English the phrase "proceeding sheets" makes no sense. The word "proceed" as a verb means to "move forward, especially after reaching a certain point". The word "proceeding" as noun usually means something similar to a court case.

By your description, I think you mean "subsequent sheets". Subsequent mean "to come later" or "to follow afterwards".

That said, I still don't know what you mean by "reduced". Maybe you mean reproduced, as in copy?

OK, so, I think I know what you want to do. However, since I can't see your workbook from where I'm sitting or know anything about your work process, I can't offer any suggestions at this point. I need more details.

For example, you said "I want to the first sheet to populate the following sheets according to aircraft number." In the example data that you posted, I don't see any column for aircraft number. How is the "solution" (whatever that may be) going to know which sheet to copy the data to?

I also don't know what you want done with all those "decreasing to 0" statements. Are you asking for a method to not only copy data from the input sheet to each individual sheet but also do calculations once the data is there? If so, you are going to have to supply a lot more detail related to your requirements.

Remember, you know exactly what you have, you know exactly how you do whatever it is that you do and you know exactly what you want the end result to be. All we know is what we read in your posts, so you need to be detailed and specific.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

Related Solutions

#4
March 14, 2018 at 18:42:51
Right, my Texican doesn't work well with others sometimes. No dramas mate. Coming afterwards, following, number 2, in sequence, after, etc.
In example. If the aircraft flew 10 hours and landed 20 times I want the corresponding sheet to add 10 hours to column b, and reduce 10 hours in columns E, G, J, and M, and add 20 landings to column C, and reduce 10 hours in columns H, K, and N.
If there was a way to send/post you my workbook I would. I learned VB and Java years ago and not longer remember enough to even get myself into trouble. I've been working this problem one and off for a few months, but can't find the code sequencing that works for what I want the database to do.
I wouldn't mind doing this in Access, but I'm not familiar enough with Access to know where to begin. I do know excel though. (To a point obviously).

Report •

Ask Question