Auto-populate information from one tab to another

**thorray** · 10-18-2021, 03:02 PM

I am needing help to auto-populate information from 1 tab "Log book" to "Total Reporting" tab. I attached a test file to show what I am trying to do better.

From the "Log book" tab I am trying to auto generate column "I - Recipient, to Total Reporting tab column A", I am also trying to get the zip code from first tab to move independently to a separate column on column B of "Total reporting".

Then "OFC USE" column D to total reporting tab column C.

Then column D "code" to populate in Column D of total reporting.

Then Column G "Totals" to populate into Column E "Cost" column of total reporting tab.

And last is to populate column H "log number" into column F of total reporting tab.

If anyone knows how to do this or can help it would be greatly appreciated.

**ORoos** · 10-18-2021, 11:53 PM

If you simply want to 'copy' the information to the Report sheet with slightly different columns and splitting the area code out, try the attached.

**thorray** · 10-19-2021, 05:49 PM

I attached the updated sheet. But for some reason cannot get the first column to work and the last column separates the logs number into 5 different boxes. IS there a way to get them all under the comments tab? Also is there a way to auto-input the "no & nA" into columns E & F as data is filled in?

**ORoos** · 10-19-2021, 07:13 PM

To enter 'NO' into a cell if something is in cell A2. For example in E2 try (note as this cell is currently blank, nothing will show):
=IF(NOT(ISBLANK(A2)),"NO","")

In column H (Comments), try: =IF(ISBLANK('REPORT LOG'!B5),"",'REPORT LOG'!B5 &" "&'REPORT LOG'!C5 &" "&'REPORT LOG'!D5&" "&'REPORT LOG'!E5&" "&'REPORT LOG'!F5)

I am not sure what you want in column A. Which filed is the 'Recipient Name' value you want to get across.

**thorray** · 11-05-2021, 01:28 PM

Solved, thank you.

Auto-populate information from one tab to another

LinkBack

Thread Tools

Rate This Thread

Display

Auto-populate information from one tab to another

Re: Auto-populate information from one tab to another

Re: Auto-populate information from one tab to another

Re: Auto-populate information from one tab to another

Re: Auto-populate information from one tab to another

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to auto-populate information from one tab to the other

auto populate cells based on previous information

Auto populate date when information is entered in another cell

auto populate information from one workbook to another

Auto-populate Information

Auto Populate Cells Dependant on Information in Previous Cell

Auto populate workbook with table information

Bookmarks

Bookmarks

Posting Permissions