Program or quicker way to data entry

peter8848

Board Regular
Joined
Oct 7, 2018
Messages
112
Dear All,

We have data entry from one spreadsheet (A) to another (B) as below:

(A)
abcd
199998154
267696694
350649157
462599157
590656592
663866662

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>


(b) Instead of entering the cell as = A1 + B1 + C2 + D5 we need to enter as " = +99 + 99 + 66 + 92,

Is there any quciker way to do it or any possible vba solutions?

Cheers,

Peter
 
I thought you said you wanted to add up the Values in The ranges you mentioned.

Which would not always be
= +99 + 99 + 66 + 92"

Why do you keep saying:
= +99 + 99 + 66 + 92"

And I asked for sheet names which you never gave me.
<strike>
</strike>
 
Upvote 0

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
@peter8848
By your comments, it sounds like your saying 2 different workbooks NOT worksheets !
Is that correct ??
 
Upvote 0
Yes I now see what Michael pointed out.
Your original post said:

We have data entry from one
spreadsheet
(A) to another (B) as below:


Spreadsheet is a Term Excel used in the Early 1970's

Excel now uses the terms:
Workbook and
Worksheet

So are you talking about two different WorkBooks or Two Different Worksheets?

 
Upvote 0
Hi My Aswer Is This,

I was about to reply you with this confusion created by me but Michael is lot of quicker. Sorry about the confusion.

Yes, this is correct we used a lot inter workbook links here.

Cheers,

Peter
 
Upvote 0
So we are dealing with two different Workbooks.

Well then if you want a Vba solution we would need to know the names of both Workbooks

And Both Worksheets and Both Workbooks would have to be open.

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.
 
Upvote 0
Hi My Aswer Is This,

Yes, but for now we can just call it Workbook A (Source Data) and Workbook B (Calculation of the sum)

Very keen to see how the code should be written on this.

Thanks anyway.

Cheers,

Peter
 
Upvote 0
Hi, Peter

I think you should explain with more detail, step by step.
When you want to enter data in workbook B, what is the active workbook, A or B?
If it is B then you can directly enter “= 99 + 99 + 66 + 92” into a cell, so what’s the problem?
If it is A then I suggest using an inputbox to enter that data, and have VBA to get the sum then insert it to a cell in workbook B.
 
Upvote 0
Hi Akuini,

Sorry what i meant was both active workbook A and B, when I select the range of the cells in workbook A, VBA will directly enter “= 99 + 99 + 66 + 92” from the range selected in workbook A into a cell in workbook B. Is it possible?

At present we need to data entry for everything.

Cheers,

Peter
 
Upvote 0
Sorry what i meant was both active workbook A and B
Well, actually what you mean is both workbook are open but only A is active. Because we can only have 1 active workbook, that is where the focus is on.
when I select the range of the cells in workbook A, VBA will directly enter “= 99 + 99 + 66 + 92”
So you want to enter data by selecting some cells not by typing?
Is the operator always "+"? or there could "-"?
 
Upvote 0

Forum statistics

Threads
1,213,533
Messages
6,114,179
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top