Switch back and forth between 2 worksheets

Question

I am working in 1 workbook, with 2 worksheets. Everyday, employees submit their individual reports to me. I go into worksheet 1 and enter the net sales, then switch to worksheet 2 and enter the tips. When i get the next report from the next employee, i do the same.

What I want to know is, is there a quicker way to switch to the 2nd worksheet and vice versa? So if i go to worksheet 1 and enter a total for employee A, can I do something like hit ENTER and that will automatically take me to worksheet 2 to the employee A field? Then the same thing when I start working on employee B?

Both worksheets are the same cells, same info, the only difference is one asks for net sales, the other asks for tips earned. I cannot combine them because they are 2 weeks worth of info that do not fit into one sheet and i cannot create a formula b/c the tips will always be different, based on what the costumer felt like tipping that day.

Answer 1

Hi, thanks for helping. Yes, the cells are in the same location. In worksheet 1 I enter the employees Net Sales and in worksheet 2 I go and enter the tips they tell me they earned from those net sales.

Answer 2

This sounds like it could actually be accomplished fairly readily given a couple of things to reference.

• Any common cross-reference between the two entries is a necessity. A unique employee ID would be best suited, but a first and last name could suffice.
• An offset between where you are inputting the data (e.g. column) and where you expect the data to arrive (e.g. remote worksheet column). Workbook names, worksheet names and any disparate local or network paths are very important if the two worksheets are not within the same workbook.

Given those two pieces of information, a routine could be built. Error control would be basic to start and get better as unforeseen situations arose.

---

• If this proposed solution has resolved your issue(s), please return and mark it as Answered for others to consider.

Answer 3

Depending on the size of your dataset, you could do all your entering of data on ONE sheet, and link it to the other (two) sheets, either by linking formulas or by VBA..........or maybe the two worksheets could be combined into one.

hth

Vaya con Dios,

Chuck, CABGx3

Answer 4

Are the cells in the same location?  Like Z100 for employee A in both worksheets?

---

gsnu201005

Answer 5

Hi, why you don't put a formula in sheet2 to capture the data from sheet 1 could you post an example of your data