Program or quicker way to data entry

[peter8848]

Dear All,

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

(A)
[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"] [/TD]
[TD="class: xl63, width: 64"]a[/TD]
[TD="class: xl63, width: 64"]b[/TD]
[TD="class: xl63, width: 64"]c[/TD]
[TD="class: xl63, width: 64"]d[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]99[/TD]
[TD="class: xl63, align: right"]99[/TD]
[TD="class: xl63, align: right"]81[/TD]
[TD="class: xl63, align: right"]54[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]67[/TD]
[TD="class: xl63, align: right"]69[/TD]
[TD="class: xl63, align: right"]66[/TD]
[TD="class: xl63, align: right"]94[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]50[/TD]
[TD="class: xl63, align: right"]64[/TD]
[TD="class: xl63, align: right"]91[/TD]
[TD="class: xl63, align: right"]57[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]62[/TD]
[TD="class: xl63, align: right"]59[/TD]
[TD="class: xl63, align: right"]91[/TD]
[TD="class: xl63, align: right"]57[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63, align: right"]90[/TD]
[TD="class: xl63, align: right"]65[/TD]
[TD="class: xl63, align: right"]65[/TD]
[TD="class: xl63, align: right"]92[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl63, align: right"]63[/TD]
[TD="class: xl63, align: right"]86[/TD]
[TD="class: xl63, align: right"]66[/TD]
[TD="class: xl63, align: right"]62[/TD]
[/TR]
</tbody>[/TABLE]


(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

 

[My Aswer Is This]

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>}}​

 

[Michael M]

@peter8848
By your comments, it sounds like your saying 2 different workbooks NOT worksheets !
Is that correct ??

 

[My Aswer Is This]

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?
​

 

[peter8848]

Hi Michael M,

You are correct and sorry about the confusion.

Cheers,

Peter

 

[peter8848]

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

 

[My Aswer Is This]

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.

 

[peter8848]

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

 

[Akuini]

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.

 

[peter8848]

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

 

[Akuini]

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 "-"?