Batch add additional calculation to a function while maintaining cell

**lithos_g** · 08-20-2020, 02:48 AM

Hello,
This is my 1st post!

I have A1 cell with function ='c:\1\[1.xls]Α'!A1

This function exists in 10.000 corresponding cells.

I want to add +'c:\2\[1.xls]Α'!A1

How can I batch add to every 9.999 cells with the corresponding cell for a final result like below:

A1 cell -> ='c:\1\[1.xls]Α'!B1+'c:\2\[1.xls]Α'!B1
.
.
.
K222 cell -> ='c:\1\[1.xls]Α'!K222+'c:\2\[1.xls]Α'!K222

Thanks in advance for your reply!

**sweep** · 08-20-2020, 07:09 AM

Hi,

This should do as you need:

Please Login or Register  to view this content.

**lithos_g** · 08-20-2020, 07:19 AM

Thanks!

How can I also make the same for multiple worksheets in my workbook?

**sweep** · 08-20-2020, 08:05 AM

You could loop through the sheets and run the above code on each sheet...

Please Login or Register  to view this content.

**lithos_g** · 08-21-2020, 02:57 AM

Thanks for the help!

I tried to run it but it returns an error at the line 12 rCell.....
It says "object variable or with block variable not set"

**sweep** · 08-21-2020, 04:51 AM

Ah sorry. The code was unchecked.

Please Login or Register  to view this content.

If that doesn't work could you please post a sample of your workbook?

**lithos_g** · 08-21-2020, 05:48 AM

I just found out that inside "+'c:\2\[1.xls]A'!" is does not accept Greek characters like that "+'c:\2\[έγραφο.xls]A'!"

If I run the script as you posted it, it works though!

**sweep** · 08-21-2020, 07:07 AM

Not an issue I've worked with previously, sorry. I do think you'll need to take a look at the ChrW() function though.

Good luck!

**Blackandw60427** · 08-21-2020, 07:08 AM

Stupid question and sorry for using this post, but how do i create a new issue?

**TDFrench** · 08-21-2020, 07:14 AM

Don't worry i figured it out

**sweep** · 08-21-2020, 07:17 AM

@Blackandw60427, Click "Forum" just under the site banner at the top of the page, click the appropriate forum for your question, then click "post new thread"

**lithos_g** · 08-27-2020, 06:54 AM

Dear Sweep,
I found a better way to "read" the position of a cell, so I don't have problem if its A01 or A1222!
I used this code below:

Please Login or Register  to view this content.

So it starts reading after "!" and stops reading before "+" and then its stored at cellNum

Don't you think its better?

**sweep** · 09-03-2020, 07:59 AM

If it works for you, it's good!

Batch add additional calculation to a function while maintaining cell

LinkBack

Thread Tools

Rate This Thread

Display

Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Re: Batch add additional calculation to a function while maintaining cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Additional calculation providing both conditions are met

Calculate Between Two Times With Additional If Calculation

Trying to create a batch by batch and weekly schedule adherence sheet.

[SOLVED] COUNTA calculation - Formula in cell refers to arange with additional numbers adjacent?

Excel 2007 : Deleting Duplicates WHILE maintaining additional columns

cell ref in function formula change when inserting additional colu

[SOLVED] additional month calculation

Bookmarks

Bookmarks

Posting Permissions